Sewer FOG Facility Violations
Field Name |
Caption |
Mask |
Description |
Field Type |
VI_AMTPAID |
Amount Paid |
-nnnnnnn.nn |
Fine Amount Paid |
Double |
VI_COMP |
Completed |
|
Completed Flag - This violation has had all of the followup efforts completed |
Boolean |
VI_CRT_BY |
Created By |
25x |
Created By |
Text |
VI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
VI_DDESC |
Detailed Description |
999x |
Detailed Description |
Text |
VI_DESC |
Description |
254x |
Code Violation Description |
Text |
VI_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
VI_ETYP_CD |
Enforcement Type |
nnnn |
Enforcement Type |
Integer |
VI_ETYP_TY |
Enforcement Type Text |
50x |
Enforcement Type Text |
Text |
VI_FA_ID |
Facility Rec # |
|
Long Integer |
|
VI_FINE |
Fine Amount |
-nnnnnnn.nn |
Fine Amount |
Double |
VI_FN_ID |
Facility Inspection Rec # |
nnnnnnnn |
Long Integer |
|
VI_ID |
Violation Rec # |
|
Violation Record Number |
Long Integer |
VI_INV_DT |
Invoiced Date |
mm/dd/yyyy |
Invoiced Date |
Date/Time |
VI_INVACCT |
Invoice Acct No |
45x |
Invoice Acct No |
Text |
VI_INVOICE |
Invoice Number |
25x |
Invoice Number |
Text |
VI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
VI_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
VI_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
VI_OCCR_DT |
Occured Date |
mm/dd/yyyy |
Occured Date |
Date/Time |
VI_PAID_DT |
Paid Date |
mm/dd/yyyy |
Date Fine Paid |
Date/Time |
VI_PAYM_CD |
Payment Method |
nnnn |
Fine Payment Method |
Integer |
VI_PAYM_TY |
Payment Method Text |
50x |
Fine Payment Method Text |
Text |
VI_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
VI_VIOL |
Notice/Violation |
20x |
Code Violation |
Text |