SMQSICH

Storm Water Quality Construction Site Inspection Checklist

Field Name

Caption

Mask

Description

Field Type

HP_CRT_BY

Created By

25x

Created By

String

HP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

HP_HI_ID

Construction Site Inspection Table

nnnnnnnn

Link to SMQSI.HI_ID

Long Integer

HP_ID

Autonumber ID

nnnnnnnn

Autonumber ID

Long Integer

HP_MOD_BY

Last Modified By

25x

Last Modified By

String

HP_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

HP_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

HP_NOTE

Note

250x

Note

String

HP_NUMBER

Line Number

nnn

Line Number

Integer

HP_PASS_CD

Pass

nnn

Pass

Integer

HP_PASS_TY

Pass Text

25x

Pass Text

String

HP_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

HP_TEXT

Checklist Instructions

250x

Checklist Instructions

String