Sewer IPT Facility Violation Corrective Actions
Field Name |
Caption |
Mask |
Description |
Field Type |
IZ_CACTION |
Corrective Action |
20x |
Corrective Action |
Text |
IZ_COMP |
Completed |
|
Completed |
Boolean |
IZ_COMP_DT |
Completion Date |
mm/dd/yyyy |
Completion Date |
Date/Time |
IZ_CRT_BY |
Created By |
25x |
Created By |
Text |
IZ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
IZ_DDESC |
Detailed Description |
999x |
Detailed Description |
Text |
IZ_DESC |
Corrective Action Desc |
999x |
Corrective Actionn Description |
Text |
IZ_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
IZ_DUE_DT |
Due Date |
mm/dd/yyyy |
Due Date |
Date/Time |
IZ_FV_ID |
Notice Rec # |
nnnnnnnn |
Long Integer |
|
IZ_ID |
Corrective Rec # |
|
Violation Corrective Action Record Number |
Long Integer |
IZ_IF_ID |
Facility Rec # |
|
Long Integer |
|
IZ_II_ID |
Facility Inspection Rec # |
|
Long Integer |
|
IZ_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
IZ_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
IZ_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
IZ_NOT_DT |
Notification Date |
mm/dd/yyyy |
Notification Date |
Date/Time |
IZ_NOTES |
Notes |
254x |
Notes |
Text |
IZ_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |