SMBMPSV

Storm BMP Asset Violations

Field Name

Caption

Mask

Description

Field Type

BV_AI_ID

Asset Inspection Rec #

nnnnnnnn

Link to SMBMPI.AI_ID

Long Integer

BV_AMTPAID

Amount Paid

-nnnnnnn.nn

Fine Amount Paid

Double

BV_BA_ID

Asset Rec #

nnnnnnnn

Link to SMBMP.BA_ID

Long Integer

BV_BS_ID

Site Rec #

nnnnnnnn

Link to SMBMPS.BS_ID

Long Integer

BV_COMP

Completed

 

Completed Flag - This violation has had all of the followup efforts completed

Boolean

BV_CRT_BY

Created By

25x

Created By

Text

BV_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BV_DDESC

Detailed Description

999x

Detailed Description

Text

BV_DESC

Description

254x

Code Violation Description

Text

BV_DOC_FLG

Document Available

 

Document Flag

Boolean

BV_ETYP_CD

Enforcement Type

nnnn

Enforcement Type

Integer

BV_ETYP_TY

Enforcement Type Text

50x

Enforcement Type Text

Text

BV_FINE

Fine Amount

-nnnnnnn.nn

Fine Amount

Double

BV_ID

Violation Rec #

nnnnnnnn

Violation Record Number

Long Integer

BV_INV_DT

Invoiced Date

mm/dd/yyyy

Invoiced Date

Date/Time

BV_INVACCT

Invoice Acct No

45x

Invoice Acct No

Text

BV_INVOICE

Invoice Number

25x

Invoice Number

Text

BV_MOD_BY

Last Modified By

25x

Last Modified By

Text

BV_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

BV_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BV_OCCR_DT

Occured Date

mm/dd/yyyy

Occured Date

Date/Time

BV_PAID_DT

Paid Date

mm/dd/yyyy

Date Fine Paid

Date/Time

BV_PAYM_CD

Payment Method

nnnn

Fine Payment Method

Integer

BV_PAYM_TY

Payment Method Text

50x

Fine Payment Method Text

Text

BV_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

BV_VIOL

Notice/Violation

20x

Code Violation

Text