Sewer FOG Hauler Events
Field Name |
Caption |
Mask |
Description |
Field Type |
HE_ASGN_CD |
Assigned To |
4x |
Assigned To |
Text |
HE_ASGN_TY |
Assigned To Text |
40x |
Assigned To Text |
Text |
HE_COMP_DT |
Completed Date |
mm/dd/yyyy |
Completed Date |
Date/Time |
HE_CRT_BY |
Created By |
25x |
Created By |
Text |
HE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
HE_DESC |
Desc |
254x |
Description |
Text |
HE_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
HE_DUE_DT |
Due Date |
mm/dd/yyyy |
Due Date |
Date/Time |
HE_EVENT_CD |
Event |
10x |
Event |
Text |
HE_EVENT_TY |
Event Text |
60x |
Event Text |
Text |
HE_GROUP |
Group |
40x |
Group |
Text |
HE_HA_ID |
Waste Hauler Record # |
nnnnnnnn |
Long Integer |
|
HE_ID |
Events Record # |
nnnnnnnn |
Notification Record Number |
Long Integer |
HE_LATE |
Late |
|
Late Flag |
Boolean |
HE_LOG_DT |
Logged Date |
mm/dd/yyyy |
Logged Date |
Date/Time |
HE_LOG_TM |
Logged Time |
hh:mm am |
Logged Time |
Date/Time |
HE_MOD_BY |
Last Mod By |
40x |
Last Modified By |
Text |
HE_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
HE_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
HE_PERF_CD |
Performed By |
4x |
Performed By |
Text |
HE_PERF_TY |
Performed By Text |
40x |
Performed By Text |
Text |
HE_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
HE_USER10 |
User 10 |
30x |
User 10 |
Text |
HE_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
HE_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
HE_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
HE_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
HE_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
HE_USER16 |
User 16 |
mm/dd/yyyy |
User 16 |
Date/Time |
HE_USER17 |
User 17 |
mm/dd/yyyy |
User 17 |
Date/Time |
HE_USER18 |
User 18 |
mm/dd/yyyy |
User 18 |
Date/Time |
HE_USER19 |
User 19 |
mm/dd/yyyy |
User 19 |
Date/Time |
HE_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
HE_USER1TY |
User 1 Text |
30x |
User 1 Text |
Text |
HE_USER20 |
User 20 |
mm/dd/yyyy |
User 20 |
Date/Time |
HE_USER21 |
User 21 |
|
User 21 |
Boolean |
HE_USER22 |
User 22 |
|
User 22 |
Boolean |
HE_USER23 |
User 23 |
|
User 23 |
Boolean |
HE_USER24 |
User 24 |
|
User 24 |
Boolean |
HE_USER25 |
User 25 |
|
User 25 |
Boolean |
HE_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
HE_USER2TY |
User 2 Text |
30x |
User 2 Text |
Text |
HE_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
HE_USER3TY |
User 3 Text |
30x |
User 3 Text |
Text |
HE_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
HE_USER4TY |
User 4 Text |
30x |
User 4 Text |
Text |
HE_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
HE_USER5TY |
User 5 Text |
30x |
User 5 Text |
Text |
HE_USER6 |
User 6 |
30x |
User 6 |
Text |
HE_USER7 |
User 7 |
30x |
User 7 |
Text |
HE_USER8 |
User 8 |
30x |
User 8 |
Text |
HE_USER9 |
User 9 |
30x |
User 9 |
Text |
HE_VIOL |
Violation |
|
Violation Flag |
Boolean |