SMQSV

Storm Water Quality Construction Site Violations

Field Name

Caption

Mask

Description

Field Type

HV_AMTPAID

Fine Amount Paid

nnnnnnnn.nn

Fine Amount Paid

Double

HV_COMP

Completed Flag

 

This violation has had all of the followup efforts completed

Boolean

HV_CRT_BY

Created By

25x

Created By

String

HV_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

HV_DDESC

Detailed Description

999x

Detailed Description

String

HV_DESC

Code Violation Description

254x

Code Violation Description

String

HV_DOC_FLG

Document Flag

 

Document Flag

Boolean

HV_ETYP_CD

Enforcement Type

nnn

Enforcement Type

Integer

HV_ETYP_TY

Enforcement Type Text

50x

Enforcement Type Text

String

HV_FINE

Fine Amount

nnnnnnnn.nn

Fine Amount

Double

HV_HI_ID

Construction Site Inspection Record No

nnnnnnnn

Link to SMQSI.HI_ID

Long Integer

HV_ID

Violation Record Number

nnnnnnnn

Auto ID

Long Integer

HV_INV_DT

Invoiced Date

mm/dd/yyyy hh:mm am

Invoiced Date

DateTime

HV_INVACCT

Invoice Acct No

45x

Invoice Acct No

String

HV_INVOICE

Invoice Number

25x

Invoice Number

String

HV_MOD_BY

Last Modified By

25x

Last Modified By

String

HV_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

HV_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

HV_OCCR_DT

Occured Date

mm/dd/yyyy hh:mm am

Occured Date

DateTime

HV_PAID_DT

Date Fine Paid

mm/dd/yyyy hh:mm am

Date Fine Paid

DateTime

HV_PAYM_CD

Fine Payment Method

nnn

Fine Payment Method

Integer

HV_PAYM_TY

Fine Payment Method Text

50x

Fine Payment Method Text

String

HV_QS_ID

Construction Site Record No

nnnnnnnn

Link to SMQS.QS_ID

Long Integer

HV_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

HV_VIOL

Code Violation

20x

Code Violation

String