Sewer FOG Hauler Drivers
Field Name |
Caption |
Mask |
Description |
Field Type |
HD_ACTIVE |
Active |
|
Active Vehicle |
Boolean |
HD_COMMENT |
Short Comment |
254x |
Short Comment |
Text |
HD_CRT_BY |
Created By |
25x |
Created By |
Text |
HD_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
HD_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
HD_EXP_DT |
Permit Expiration Date |
mm/dd/yyyy |
Permit Expiration Date |
Date/Time |
HD_HA_ID |
Hauler Record No |
nnnnnnnn |
Long Integer |
|
HD_ID |
Driver Record No |
nnnnnnnn |
Driver Record Number |
Long Integer |
HD_LICENSE |
Drivers License # |
30x |
License Number |
Text |
HD_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
HD_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
HD_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
HD_NAME |
Driver Name |
50x |
Driver Name |
Text |
HD_PERMIT |
Permitted |
|
Permitted |
Boolean |
HD_RET_DT |
Retired Date |
mm/dd/yyyy |
Retired Date |
Date/Time |
HD_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |