Sewer FOG Facility Violations
Field Name |
Caption |
Mask |
Description |
Field Type |
VA_CACTION |
Corrective Action |
20x |
Corrective Action |
Text |
VA_COMP |
Completed |
|
Completed |
Boolean |
VA_COMP_DT |
Completion Date |
mm/dd/yyyy |
Completed Date |
Date/Time |
VA_CRT_BY |
Created By |
25x |
Created By |
Text |
VA_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
VA_DDESC |
Detailed Description |
999x |
Detailed Description |
Text |
VA_DESC |
Corrective Action Desc |
999x |
Corrective Actionn Description |
Text |
VA_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
VA_DUE_DT |
Due Date |
mm/dd/yyyy |
Due Date |
Date/Time |
VA_FA_ID |
Facility Rec # |
|
Long Integer |
|
VA_ID |
Corrective Rec # |
|
Violation Corrective Action Record Number |
Long Integer |
VA_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
VA_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
VA_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
VA_NOT_DT |
Notification Date |
mm/dd/yyyy |
Notification Date |
Date/Time |
VA_NOTES |
Notes |
254x |
Notes |
Text |
VA_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
VA_VI_ID |
Facility Inspection Rec # |
|
Long Integer |