Sewer IPT Facility Violations
Field Name |
Caption |
Mask |
Description |
Field Type |
FV_AMTPAID |
Amount Paid |
-nnnnnnn.nn |
Fine Amount Paid |
Double |
FV_COMP |
Completed |
|
Completed Flag - This violation has had all of the followup efforts completed |
Boolean |
FV_CRT_BY |
Created By |
25x |
Created By |
Text |
FV_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FV_DDESC |
Detailed Description |
999x |
Detailed Description |
Text |
FV_DESC |
Description |
254x |
Code Violation Description |
Text |
FV_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
FV_ETYP_CD |
Enforcement Type |
nnnn |
Enforcement Type |
Integer |
FV_ETYP_TY |
Enforcement Type Text |
50x |
Enforcement Type Text |
Text |
FV_FINE |
Fine Amount |
-nnnnnnn.nn |
Fine Amount |
Double |
FV_ID |
Violation Rec # |
|
Violation Record Number |
Long Integer |
FV_IF_ID |
Facility Rec # |
|
Long Integer |
|
FV_II_ID |
Facility Inspection Rec # |
nnnnnnnn |
Long Integer |
|
FV_INV_DT |
Invoiced Date |
mm/dd/yyyy |
Invoiced Date |
Date/Time |
FV_INVACCT |
Invoice Acct No |
45x |
Invoice Acct No |
Text |
FV_INVOICE |
Invoice Number |
25x |
Invoice Number |
Text |
FV_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
FV_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
FV_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
FV_OCCR_DT |
Occured Date |
mm/dd/yyyy |
Occured Date |
Date/Time |
FV_PAID_DT |
Paid Date |
mm/dd/yyyy |
Date Fine Paid |
Date/Time |
FV_PAYM_CD |
Payment Method |
nnnn |
Fine Payment Method |
Integer |
FV_PAYM_TY |
Payment Method Text |
50x |
Fine Payment Method Text |
Text |
FV_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
FV_VIOL |
Notice/Violation |
20x |
Code Violation |
Text |