SMQIV

Field Name

Caption

Mask

Description

Field Type

UV_AMTPAID

Fine Amount Paid

nnnnnnnn.nn

Fine Amount Paid

Double

UV_COMP

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

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

Boolean

UV_CRT_BY

Created By

25x

Created By

String

UV_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

UV_DDESC

Detailed Description

999x

Detailed Description

String

UV_DESC

Code Violation Description

254x

Code Violation Description

String

UV_DOC_FLG

Document Flag

Document Flag

Boolean

UV_ETYP_CD

Enforcement Type

nnn

Enforcement Type

Integer

UV_ETYP_TY

Enforcement Type Text

50x

Enforcement Type Text

String

UV_FINE

Fine Amount

nnnnnnnn.nn

Fine Amount

Double

UV_ID

Industrial Violation Record Number

nnnnnnnn

Industrial Violation Record Number

Long Integer

UV_INV_DT

Invoiced Date

mm/dd/yyyy hh:mm am

Invoiced Date

DateTime

UV_INVACCT

Invoice Acct No

45x

Invoice Acct No

String

UV_INVOICE

Invoice Number

25x

Invoice Number

String

UV_MOD_BY

Last Modified By

25x

Last Modified By

String

UV_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

UV_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

UV_OCCR_DT

Occured Date

mm/dd/yyyy hh:mm am

Occured Date

DateTime

UV_PAID_DT

Date Fine Paid

mm/dd/yyyy hh:mm am

Date Fine Paid

DateTime

UV_PAYM_CD

Fine Payment Method

nnn

Fine Payment Method

Integer

UV_PAYM_TY

Fine Payment Method Text

50x

Fine Payment Method Text

String

UV_QI_ID

Industrial Record No

nnnnnnnn

Link to SMQI.QI_ID

Long Integer

UV_ROWVER

Rowversion for optimistic locking

TimeStamp

UV_UI_ID

Industrial Inspection Record No

nnnnnnnn

Link to SMQII.UI_ID

Long Integer

UV_VIOL

Code Violation

20x

Code Violation

String