SMBMPSTL

Storm BMP Asset Inspection Test Results

Field Name

Caption

Mask

Description

Field Type

BR_AVAL

Authority Value

nnnnnnnn.nn

Authority Value

Double

BR_BML

Below Min Limit

 

Below Minimum Limit

Boolean

BR_BP_ID

Site Testing Record No

nnnnnnnn

Link to SMBMPST.BP_ID

Long Integer

BR_CRT_BY

Created By

25x

Created By

Text

BR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BR_EMSL

Exceeds Max Surcharge

 

Exceeds Maximum Surcharge Limit

Boolean

BR_EPL

Exceeds Permit Limit

 

Exceeds Permit Limit

Boolean

BR_ESL

Exceeds Surcharge Limit

 

Exceeds Surcharge Limit

Boolean

BR_ID

Insp Test Results Rec #

nnnnnnnn

Autonumber ID

Long Integer

BR_ITEM

Item

30x

Item

Text

BR_ML

Minimum Limit

nnnnnnnn.nn

Minimum Limit

Double

BR_MOD_BY

Last Mod By

25x

Last Modified By

Text

BR_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

BR_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BR_MSL

Max Surcharge Limit

nnnnnnnn.nn

Maximum Surcharge Limit

Double

BR_NUMBER

Line Number

nnnn

Line Number

Integer

BR_PL

Permit Limit

nnnnnnnn.nn

Permit Limit

Double

BR_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

BR_SL

Surcharge Limit

nnnnnnnn.nn

Surcharge Limit

Double

BR_SVAL

Self Monitored Value

nnnnnnnn.nn

Self Monitored Value

Double

BR_UOM_CD

UOM

nnn

UOM

Integer

BR_UOM_TY

UOM Text

25x

UOM Text

Text