Communication Device/Phone Activity History Tracker for ITS
Field Name |
Caption |
Mask |
Description |
Field Type |
DH_ACTN_CD |
Action |
nnn |
Action |
Integer |
DH_ACTN_DT |
Action Date |
mm/dd/yyyy hh:mm am |
Action Date |
DateTime |
DH_ACTN_TM |
Action Time |
mm/dd/yyyy hh:mm am |
Action Time |
DateTime |
DH_ACTN_TY |
Action Text |
50x |
Action Text |
String |
DH_AG_ID |
AutoGate RecordNumber |
nnnnnnnn |
Long Integer |
|
DH_AL_ID |
PDMS Record Number |
nnnnnnnn |
Long Integer |
|
DH_AS_NUM |
Asset Number |
50x |
Asset Number |
String |
DH_ATYP_CD |
Asset Type |
nnn |
Asset Type |
Integer |
DH_ATYP_TY |
Asset Type Text |
50x |
Asset Type Text |
String |
DH_CO_ID |
Communication Record Number |
nnnnnnnn |
Long Integer |
|
DH_CRT_BY |
Created By |
25x |
Created By |
String |
DH_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
DH_DE_ID |
Communication Device Record Number |
nnnnnnnn |
Long Integer |
|
DH_DM_ID |
DMS Record Number |
nnnnnnnn |
Long Integer |
|
DH_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
DH_DP_ID |
PDMS Record Number |
nnnnnnnn |
Long Integer |
|
DH_ID |
Communication Device History Record Number |
nnnnnnnn |
Communication Device History Record Number |
Long Integer |
DH_KI_ID |
Kiosk Record Number |
nnnnnnnn |
Long Integer |
|
DH_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
DH_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
DH_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
DH_NOTES |
Notes or Short Comment |
255x |
Notes or Short Comment |
String |
DH_PU_ID |
Anti-Icing Pump House Record Number |
nnnnnnnn |
Long Integer |
|
DH_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
DH_RW_ID |
RWIS Record Number |
nnnnnnnn |
Long Integer |
|
DH_SO_ID |
Sensor Record Number |
nnnnnnnn |
Long Integer |