SMQICOUT

Storm Water Quality Industrial Community Outreach Program

Field Name

Caption

Mask

Description

Field Type

UH_AREP_CD

Agency Representative

nnn

Agency Representative

Integer

UH_AREP_TY

Agency Representative Text

50x

Agency Representative Text

String

UH_CRT_BY

Created By

25x

Created By

String

UH_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

UH_ID

Industrial Community Outreach Rec #

nnnnnnnn

Unique ID

Long Integer

UH_ITEM_CD

Item

10x

Item

String

UH_ITEM_TY

Item Text

60x

Item Text

String

UH_MOD_BY

Last Modified By

25x

Last Modified By

String

UH_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

UH_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

UH_OUT_DT

Outreach Date

mm/dd/yyyy hh:mm am

Outreach Date

DateTime

UH_OUT_TM

Outreach Time

mm/dd/yyyy hh:mm am

Outreach Time

DateTime

UH_QI_ID

Industrial Record No

nnnnnnnn

Link to SMQI.QI_ID

Long Integer

UH_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

UH_UI_ID

Industrial Inspection Record No

nnnnnnnn

Link to SMQII.UI_ID

Long Integer