Sewer FOG Facility Events
Field Name |
Caption |
Mask |
Description |
Field Type |
EV_ASGN_CD |
Assigned To |
4x |
Assigned To |
Text |
EV_ASGN_TY |
Assigned To Text |
40x |
Assigned To Text |
Text |
EV_COMP_DT |
Completed Date |
mm/dd/yyyy |
Completed Date |
Date/Time |
EV_CRT_BY |
Created By |
25x |
Created By |
Text |
EV_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
EV_DESC |
Desc |
254x |
Description |
Text |
EV_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
EV_DUE_DT |
Due Date |
mm/dd/yyyy |
Due Date |
Date/Time |
EV_EVENT_CD |
Event |
10x |
Event |
Text |
EV_EVENT_TY |
Event Text |
60x |
Event Text |
Text |
EV_FA_ID |
Facility Record # |
nnnnnnnn |
Long Integer |
|
EV_GROUP |
Group |
40x |
Group |
Text |
EV_ID |
Events Record # |
nnnnnnnn |
Notification Record Number |
Long Integer |
EV_LATE |
Late |
|
Late Flag |
Boolean |
EV_LOG_DT |
Logged Date |
mm/dd/yyyy |
Logged Date |
Date/Time |
EV_LOG_TM |
Logged Time |
hh:mm am |
Logged Time |
Date/Time |
EV_MOD_BY |
Last Mod By |
40x |
Last Modified By |
Text |
EV_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
EV_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
EV_PERF_CD |
Performed By |
4x |
Performed By |
Text |
EV_PERF_TY |
Performed By Text |
40x |
Performed By Text |
Text |
EV_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
EV_USER10 |
User 10 |
30x |
User 10 |
Text |
EV_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
EV_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
EV_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
EV_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
EV_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
EV_USER16 |
User 16 |
mm/dd/yyyy |
User 16 |
Date/Time |
EV_USER17 |
User 17 |
mm/dd/yyyy |
User 17 |
Date/Time |
EV_USER18 |
User 18 |
mm/dd/yyyy |
User 18 |
Date/Time |
EV_USER19 |
User 19 |
mm/dd/yyyy |
User 19 |
Date/Time |
EV_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
EV_USER1TY |
User 1 Text |
30x |
User 1 Text |
Text |
EV_USER20 |
User 20 |
mm/dd/yyyy |
User 20 |
Date/Time |
EV_USER21 |
User 21 |
|
User 21 |
Boolean |
EV_USER22 |
User 22 |
|
User 22 |
Boolean |
EV_USER23 |
User 23 |
|
User 23 |
Boolean |
EV_USER24 |
User 24 |
|
User 24 |
Boolean |
EV_USER25 |
User 25 |
|
User 25 |
Boolean |
EV_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
EV_USER2TY |
User 2 Text |
30x |
User 2 Text |
Text |
EV_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
EV_USER3TY |
User 3 Text |
30x |
User 3 Text |
Text |
EV_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
EV_USER4TY |
User 4 Text |
30x |
User 4 Text |
Text |
EV_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
EV_USER5TY |
User 5 Text |
30x |
User 5 Text |
Text |
EV_USER6 |
User 6 |
30x |
User 6 |
Text |
EV_USER7 |
User 7 |
30x |
User 7 |
Text |
EV_USER8 |
User 8 |
30x |
User 8 |
Text |
EV_USER9 |
User 9 |
30x |
User 9 |
Text |
EV_VIOL |
Violation |
|
Violation Flag |
Boolean |