SMQFB

Storm Water Quality Management Plan BMP Asset Records

Field Name

Caption

Mask

Description

Field Type

FB_BA_ID

BMP Asset Rec #

nnnnnnnn

Link to SMBMP.BA_ID

Long Integer

FB_BA_NUMBER

BMP Asset Number

25x

BMP Asset Number

String

FB_CRT_BY

Created By

25x

Created By

String

FB_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

FB_ID

Management Plan BMP Asset Rec #

nnnnnnnn

Management Plan BMP Asset Rec #

Long Integer

FB_MOD_BY

Last Modified By

25x

Last Modified By

String

FB_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

FB_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

FB_QF_ID

Management Plan Rec #

nnnnnnnn

Link to SMQF.QF_ID

Long Integer

FB_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp