SMQFIB

Field Name

Caption

Mask

Description

Field Type

FM_BA_NUMBER

BMP Asset Number

25x

Link to SMBMP.BA_NUMBER

String

FM_BA_TYPE

Type Text

25x

Type Text

String

FM_BMPCOMM

BMP Comments

250x

BMP Comments

String

FM_BMPINSP

Was BMP Inspected?

Was BMP Inspected?

Boolean

FM_BMPINSPCOMM

BMP Inspection Comments

250x

BMP Inspection Comments

String

FM_CA_DT

Corrective Action must be completed by Date

mm/dd/yyyy hh:mm am

Corrective Action must be completed by Date

DateTime

FM_CORRACT

Corrective Actions

250x

Corrective Actions

String

FM_CRT_BY

Created By

25x

Created By

String

FM_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

FM_DOC_FLG

Document Flag

Document Flag

Boolean

FM_FB_ID

Management Plan BMP Asset Rec #

nnnnnnnn

Link to SMQFB.FB_ID

Long Integer

FM_FI_ID

Management Plan Inspection Rec #

nnnnnnnn

Link to SMQFI.FI_ID

Long Integer

FM_FUI_DT

Follow-up Inspection Date

mm/dd/yyyy hh:mm am

Follow-up Inspection Date

DateTime

FM_FUR_CD

Follow-up Required? Yes, No, N/A

nnn

Follow-up Required? Yes, No, N/A

Integer

FM_FUR_TY

Follow-up Required Text

50x

Follow-up Required Text

String

FM_ID

Management Plan BMP Asset Inspection Rec #

nnnnnnnn

Management Plan BMP Asset Inspection Rec #

Long Integer

FM_INSP_DT

Inspection Date

mm/dd/yyyy hh:mm am

Inspection Date

DateTime

FM_INSPE_TM

Inspection End Time

mm/dd/yyyy hh:mm am

Inspection End Time

DateTime

FM_INSPS_TM

Inspection Start Time

mm/dd/yyyy hh:mm am

Inspection Start Time

DateTime

FM_LOEA_CD

Level of Enforcement Action Taken

10x

Level of Enforcement Action Taken

String

FM_LOEA_TY

Level of Enforcement Action Taken Text

60x

Level of Enforcement Action Taken Text

String

FM_MAINTNEED

Is maintenance needed at this time?

Is maintenance needed at this time?

Boolean

FM_MOD_BY

Last Modified By

25x

Last Modified By

String

FM_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

FM_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

FM_MOSLARVAE

Mosquitoes or mosquito larvae present?

Mosquitoes or mosquito larvae present?

Boolean

FM_PASS_CD

BMP Pass/Fail - Options Pass/Fail

nnn

BMP Pass/Fail - Options Pass/Fail

Integer

FM_PASS_TY

BMP Pass/Fail Text

50x

BMP Pass/Fail Text

String

FM_ROWVER

Rowversion for optimistic locking

TimeStamp