Park Art Inspection Checklists
Field Name |
Caption |
Mask |
Description |
Field Type |
DQ_AT_ID |
Inspection Record Number |
nnnnnnnn |
Long Integer |
|
DQ_COND_CD |
Condition |
nnn |
Condition |
Integer |
DQ_COND_TY |
Condition Text |
25x |
Condition Text |
String |
DQ_CRT_BY |
Created By |
25x |
Created By |
String |
DQ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
DQ_ID |
Autonumber ID |
nnnnnnnn |
Autonumber ID |
Long Integer |
DQ_INSP_DT |
Inspection Date |
mm/dd/yyyy hh:mm am |
Inspection Date |
DateTime |
DQ_INSP_TM |
Inspection Time |
mm/dd/yyyy hh:mm am |
Inspection Time |
DateTime |
DQ_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
DQ_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
DQ_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
DQ_NOTE |
Note |
255x |
Note |
String |
DQ_NUMBER |
Line Number |
nnnnnnnn |
Line Number |
Long Integer |
DQ_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
DQ_TEXT |
Checklist Instructions |
100x |
Checklist Instructions |
String |