Work Order Inspection Construction Activity
Field Name |
Caption |
Mask |
Description |
Field Type |
DC_AS_DT |
Arrived Site Date |
mm/dd/yyyy |
Arrived Site Date |
Date/Time |
DC_AS_TM |
Arrived Site Time |
hh:mm am |
Arrived Site Time |
Date/Time |
DC_CRT_BY |
Created By |
25x |
Created By |
Text |
DC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
DC_DI_ID |
Daily Inspect Rec # |
nnnnnnnn |
Long Integer |
|
DC_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
DC_ET_DT |
End Travel Date |
mm/dd/yyyy |
End Travel Date |
Date/Time |
DC_ET_TM |
End Travel Time |
hh:mm am |
End Travel Time |
Date/Time |
DC_ID |
Site Visit Rec # |
nnnnnnnn |
Site Visit Record ID for Construction Activities of Daily Inspections |
Long Integer |
DC_INIDTTM |
|
|
Initiated Date/Time |
Date/Time |
DC_INSPTIME |
Insp Time (hrs) |
nnn.nn |
Inspection Time (hrs) |
Double |
DC_LS_DT |
Left Site Date |
mm/dd/yyyy |
Left Site Date |
Date/Time |
DC_LS_TM |
Left Site Time |
hh:mm am |
Left Site Time |
Date/Time |
DC_MINSPTM |
Manual Insp Time |
nnn.nn |
Manually entered Inspection Time (hrs) |
Double |
DC_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
DC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
DC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
DC_MTT1 |
Manual Travel Time 1 |
nnn.nn |
Manually entered Travel Time 1 (hrs) |
Double |
DC_MTT2 |
Manual Travel Time 2 |
nnn.nn |
Manually entered Travel Time 2 (hrs) |
Double |
DC_ONSITE |
On Site? |
|
On Site Logical |
Boolean |
DC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
DC_ST_DT |
Start Travel Date |
mm/dd/yyyy |
Start Travel Date |
Date/Time |
DC_ST_TM |
Start Travel Time |
hh:mm am |
Start Travel Time |
Date/Time |
DC_TASK1_CD |
Arrived Task |
15x |
Travel Time 1 Task |
Text |
DC_TASK1_TY |
Arrived Task Text |
50x |
Travel Time 1 Text |
Text |
DC_TASK2_CD |
Inspection Task |
15x |
Inspection Time Task |
Text |
DC_TASK2_TY |
Inspection Task Text |
50x |
Inspection Time Task Text |
Text |
DC_TASK3_CD |
Departed Task |
15x |
Travel Time 2 Task |
Text |
DC_TASK3_TY |
Departed Task Text |
50x |
Travel Time 2 Task Text |
Text |
DC_TT1 |
Travel Time 1 (hrs) |
nnn.nn |
Travel Time 1 (hrs) - Travel time calculated as Arrived Site Date/Time less Start Travel Date/Time |
Double |
DC_TT2 |
Travel Time 2 (hrs) |
nnn.nn |
Travel Time 2 (hrs) - Travel time calculated as End Travel Date/Time less Left Site Date/Time |
Double |
DC_USER1 |
User 1 |
|
User 1 Logical |
Boolean |
DC_USER2 |
User 2 |
|
User 2 Logical |
Boolean |
DC_USER3 |
User 3 |
50x |
User 3 Text |
Text |