Work Permit Check List
Field Name |
Caption |
Mask |
Description |
Field Type |
PH_CRT_BY |
Created By |
25x |
Created By |
Text |
PH_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PH_ID |
Checklist Rec # |
nnnnnnnn |
Autonumber ID |
Long Integer |
PH_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PH_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
PH_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PH_NOTE |
Note |
250x |
Note |
Text |
PH_NUMBER |
No |
nnnn |
Line Number |
Long Integer |
PH_PASS_CD |
Pass |
nnn |
Pass |
Integer |
PH_PASS_TY |
Pass Text |
25x |
Pass Text |
Text |
PH_PERF_DT |
Date Performed |
mm/dd/yyyy |
Performed Date |
Date/Time |
PH_PF_ID |
Permit Type Rec # |
nnnnnnnn |
Long Integer |
|
PH_PP_ID |
Permit Rec # |
nnnnnnnn |
Long Integer |
|
PH_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PH_SCHD_DT |
Scheduled Date |
mm/dd/yyyy |
Scheduled Date |
Date/Time |
PH_STAT_CD |
Status |
nnn |
Status |
Integer |
PH_STAT_TY |
Status Text |
25x |
Status Text |
Text |
PH_TEXT |
Checklist |
100x |
Checklist Instructions |
Text |
PH_USER1_CD |
User 1 |
nnn |
User 1 |
Integer |
PH_USER1_TY |
User 1 Text |
50x |
User 1 Text |
Text |
PH_USER2 |
User 2 |
30x |
User 2 |
Text |
PH_USER3 |
User 3 |
-nnnnnnnn.nn |
User 3 |
Double |
PH_USER4_DT |
User 4 |
mm/dd/yyyy |
User 4 Date |
Date/Time |
PH_USER5 |
User 5 |
|
User 5 |
Boolean |
PH_USER6_CD |
User 6 |
nnn |
User 6 |
integer |
PH_USER6_TY |
User 6 Text |
50x |
User 6 Text |
String |
PH_USER7_CD |
User 7 |
nnn |
User 7 |
integer |
PH_USER7_TY |
User 7 Text |
50x |
User 7 Text |
String |
PH_USER8_CD |
User 8 |
nnn |
User 8 |
integer |
PH_USER8_TY |
User 8 Text |
50x |
User 8 Text |
String |
PH_USER9_CD |
User 9 |
nnn |
User 9 |
integer |
PH_USER9_TY |
User 9 Text |
50x |
User 9 Text |
String |
PH_USER10CD |
User 10 |
nnn |
User 10 |
integer |
PH_USER10TY |
User 10 Text |
50x |
User 10 Text |
String |
PH_USER11 |
User 11 |
50x |
User 11 |
String |
PH_USER12 |
User 12 |
50x |
User 12 |
String |
PH_USER13 |
User 13 |
50x |
User 13 |
String |
PH_USER14 |
User 14 |
50x |
User 14 |
String |
PH_USER15 |
User 15 |
50x |
User 15 |
String |
PH_USER16 |
User 16 |
nnnnnnnn.nn |
User 16 |
Double |
PH_USER17 |
User 17 |
nnnnnnnn.nn |
User 17 |
Double |
PH_USER18 |
User 18 |
nnnnnnnn.nn |
User 18 |
Double |
PH_USER19 |
User 19 |
nnnnnnnn.nn |
User 19 |
Double |
PH_USER20 |
User 20 |
nnnnnnnn.nn |
User 20 |
Double |
PH_USER21 |
User 21 |
mm/dd/yyyy hh:mm am |
User 21 |
DateTime |
PH_USER22 |
User 22 |
mm/dd/yyyy hh:mm am |
User 22 |
DateTime |
PH_USER23 |
User 23 |
mm/dd/yyyy hh:mm am |
User 23 |
DateTime |
PH_USER24 |
User 24 |
mm/dd/yyyy hh:mm am |
User 24 |
DateTime |
PH_USER25 |
User 25 |
mm/dd/yyyy hh:mm am |
User 25 |
DateTime |
PH_USER26 |
User 26 |
|
User 26 |
Boolean |
PH_USER27 |
User 27 |
|
User 27 |
Boolean |
PH_USER28 |
User 28 |
|
User 28 |
Boolean |
PH_USER29 |
User 29 |
|
User 29 |
Boolean |
PH_USER30 |
User 30 |
|
User 30 |
Boolean |