Sewer IPT Facility Notifications
Field Name |
Caption |
Mask |
Description |
Field Type |
IT_ASGN_CD |
|
4x |
Assigned To |
Text |
IT_ASGN_TY |
|
40x |
Assigned To Text |
Text |
IT_COMP_DT |
|
|
Completed Date |
Date/Time |
IT_CRT_BY |
Created By |
25x |
Created By |
Text |
IT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
IT_DESC |
|
254x |
Description |
Text |
IT_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
IT_DUE_DT |
|
|
Due Date |
Date/Time |
IT_EVENT_CD |
|
10x |
Event |
Text |
IT_EVENT_TY |
|
60x |
Event Text |
Text |
IT_GROUP |
|
40x |
Group |
Text |
IT_ID |
Notification Record # |
nnnnnnnn |
Notification Record Number |
Long Integer |
IT_IF_ID |
Facility Record # |
nnnnnnnn |
Long Integer |
|
IT_LATE |
|
|
Late Flag |
Boolean |
IT_MOD_BY |
Last Mod By |
40x |
Last Modified By |
Text |
IT_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
IT_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
IT_NOT_CD |
Notification Code |
nnn |
Notification |
Integer |
IT_NOT_TY |
Notification Type |
25x |
Notification Text |
Text |
IT_PERF_CD |
|
4x |
Performed By |
Text |
IT_PERF_TY |
|
40x |
Performed By Text |
Text |
IT_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
IT_SENT_BY |
Sent By |
40x |
Sent By |
Text |
IT_SENT_DT |
Date Sent |
mm/dd/yyyy |
Sent Date |
Date/Time |
IT_VIOL |
|
|
Violation Flag |
Boolean |