SMQCCOUT

Storm Water Quality Commercial Community Outreach Program

Field Name

Caption

Mask

Description

Field Type

KH_AREP_CD

Agency Representative

nnn

Agency Representative

Integer

KH_AREP_TY

Agency Representative Text

50x

Agency Representative Text

String

KH_CRT_BY

Created By

25x

Created By

String

KH_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

KH_ID

Commercial Community Outreach Rec #

nnnnnnnn

Commercial Community Outreach Rec #

Long Integer

KH_ITEM_CD

Item

10x

Item

String

KH_ITEM_TY

Item Text

60x

Item Text

String

KH_KI_ID

Commercial Inspection Record No

nnnnnnnn

Link to SMQCI.KI_ID

Long Integer

KH_MOD_BY

Last Modified By

25x

Last Modified By

String

KH_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

KH_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

KH_OUT_DT

Outreach Date

mm/dd/yyyy hh:mm am

Outreach Date

DateTime

KH_OUT_TM

Outreach Time

mm/dd/yyyy hh:mm am

Outreach Time

DateTime

KH_QC_ID

Commercial Record No

nnnnnnnn

Link to SMQC.QC_ID

Long Integer

KH_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp