SWIPTEN

Enforcement Records table

Field Name

Caption

Mask

Description

Field Type

EN_AMTPAID

Amount Paid

nnnnnnnn.nn

Amount Paid

Double

EN_COMP

Completed

 

Completed

Boolean

EN_CRT_BY

Created By

25x

Created By

String

EN_CRT_DTTM

Creation Date Time

hh:mm am

Creation Date Time

DateTime

EN_DDESC

Detailed Description

999x

Detailed Description

String

EN_DOC_FLG

Document Available

 

Document Available

Boolean

EN_ETYP_CD

Enforcement Type

nnn

Enforcement Type

Integer

EN_ETYP_TY

Enforcement Type Text

50x

Enforcement Type Text

String

EN_FINE

Fine Amount

nnnnnnnn.nn

Fine Amount

Double

EN_ID

Enforcement Rec #

nnnnnnnn

Enforcement Rec #

Long Integer

EN_IF_ID

Facility Rec #

nnnnnnnn

Link to SWIPTF.IF_ID

Long Integer

EN_II_ID

Facility Inspection Rec #

nnnnnnnn

Link to SWIPTFI.II_ID

Long Integer

EN_INV_DT

Invoiced Date

mm/dd/yyyy

Invoiced Date

DateTime

EN_INVACCT

Invoice Acct No

45x

Invoice Acct No

String

EN_INVOICE

Invoice Number

25x

Invoice Number

String

EN_MOD_BY

Last Modified By

25x

Last Modified By

String

EN_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

DateTime

EN_MOD_TM

Last Modified Time

hh:mm am

Last Modified Time

DateTime

EN_OCCR_DT

Occurred Date

mm/dd/yyyy

Occurred Date

DateTime

EN_PAID_DT

Paid Date

mm/dd/yyyy

Paid Date

DateTime

EN_PAYM_CD

Payment Method

nnn

Payment Method

Integer

EN_PAYM_TY

Payment Method Text

50x

Payment Method Text

String