Sewer IPT Facility Events
Field Name |
Caption |
Mask |
Description |
Field Type |
IE_ASGN_CD |
Assigned To |
4x |
Assigned To |
Text |
IE_ASGN_TY |
Assigned To Text |
40x |
Assigned To Text |
Text |
IE_COMP_DT |
Completed Date |
mm/dd/yyyy |
Completed Date |
Date/Time |
IE_CRT_BY |
Created By |
25x |
Created By |
Text |
IE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
IE_DESC |
Description |
254x |
Description |
Text |
IE_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
IE_DUE_DT |
Due Date |
mm/dd/yyyy |
Due Date |
Date/Time |
IE_EVENT_CD |
Event |
10x |
Event |
Text |
IE_EVENT_TY |
Event Text |
60x |
Event Text |
Text |
IE_GROUP |
Group |
40x |
Group |
Text |
IE_ID |
Events Record # |
nnnnnnnn |
Notification Record Number |
Long Integer |
IE_IF_ID |
Facility Record # |
nnnnnnnn |
Long Integer |
|
IE_LATE |
Late |
|
Late Flag |
Boolean |
IE_LOG_DT |
Logged Date |
mm/dd/yyyy |
Logged Date |
Date/Time |
IE_LOG_TM |
Logged Time |
hh:mm am |
Logged Time |
Date/Time |
IE_MOD_BY |
Last Mod By |
40x |
Last Modified By |
Text |
IE_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
IE_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
IE_PERF_CD |
Performed By |
4x |
Performed By |
Text |
IE_PERF_TY |
Performed By Text |
40x |
Performed By Text |
Text |
IE_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
IE_USER10 |
User 10 |
30x |
User 10 |
Text |
IE_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
IE_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
IE_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
IE_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
IE_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
IE_USER16 |
User 16 |
mm/dd/yyyy |
User 16 |
Date/Time |
IE_USER17 |
User 17 |
mm/dd/yyyy |
User 17 |
Date/Time |
IE_USER18 |
User 18 |
mm/dd/yyyy |
User 18 |
Date/Time |
IE_USER19 |
User 19 |
mm/dd/yyyy |
User 19 |
Date/Time |
IE_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
IE_USER1TY |
User 1 Text |
30x |
User 1 Text |
Text |
IE_USER20 |
User 20 |
mm/dd/yyyy |
User 20 |
Date/Time |
IE_USER21 |
User 21 |
|
User 21 |
Boolean |
IE_USER22 |
User 22 |
|
User 22 |
Boolean |
IE_USER23 |
User 23 |
|
User 23 |
Boolean |
IE_USER24 |
User 24 |
|
User 24 |
Boolean |
IE_USER25 |
User 25 |
|
User 25 |
Boolean |
IE_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
IE_USER2TY |
User 2 Text |
30x |
User 2 Text |
Text |
IE_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
IE_USER3TY |
User 3 Text |
30x |
User 3 Text |
Text |
IE_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
IE_USER4TY |
User 4 Text |
30x |
User 4 Text |
Text |
IE_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
IE_USER5TY |
User 5 Text |
30x |
User 5 Text |
Text |
IE_USER6 |
User 6 |
30x |
User 6 |
Text |
IE_USER7 |
User 7 |
30x |
User 7 |
Text |
IE_USER8 |
User 8 |
30x |
User 8 |
Text |
IE_USER9 |
User 9 |
30x |
User 9 |
Text |
IE_VIOL |
Violation |
|
Violation Flag |
Boolean |