Permit Status Tracking table
Field Name |
Caption |
Mask |
Description |
Field Type |
TT_CRT_BY |
Created By |
25x |
Created By |
String |
TT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
TT_DESC |
Description |
100x |
Description |
String |
TT_DT |
Date |
mm/dd/yyyy |
Date |
DateTime |
TT_ID |
Permit Status Rec # |
nnnnnnnn |
Permit Status Rec # |
Long Integer |
TT_IF_ID |
Facility Rec # |
nnnnnnnn |
Long Integer |
|
TT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
TT_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
DateTime |
TT_MOD_TM |
Last Modified Time |
hh:mm am |
Last Modified Time |
DateTime |
TT_STAT_CD |
Status |
nnn |
Status |
Integer |
TT_STAT_TY |
Status Text |
25x |
Status Text |
String |
TT_TM |
Time |
hh:mm am |
Time |
DateTime |