SMQFIBC

Storm Water Quality Management Plan BMP Inspection Maintenance/Deficiencies

Field Name

Caption

Mask

Description

Field Type

FZ_CRT_BY

Created By

25x

Created By

String

FZ_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

FZ_DEF_CD

Pass

10x

Pass

String

FZ_DEF_TY

Pass Text

60x

Pass Text

String

FZ_FM_ID

Management Plan BMP Inspection Rec #

nnnnnnnn

Link to SMQFIB.FM_ID

Long Integer

FZ_ID

Management Plan BMP Inspection Maintenance/Deficiencies Rec #

nnnnnnnn

Autonumber ID

Long Integer

FZ_MOD_BY

Last Modified By

25x

Last Modified By

String

FZ_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

FZ_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

FZ_NOTE

Note

250x

Note

String

FZ_NUMBER

Line Number

nnn

Line Number

Integer

FZ_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

FZ_TEXT

Checklist Instructions

250x

Checklist Instructions

String