SMQCNA

Storm Water Quality Industrial Notifications

Field Name

Caption

Mask

Description

Field Type

KE_CRT_BY

Created By

25x

Created By

String

KE_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

KE_ID

Commercial NAICS Rec #

nnnnnnnn

Auto ID

Long Integer

KE_MOD_BY

Last Modified By

25x

Last Modified By

String

KE_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

KE_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

KE_NAIC_CD

NAICS Code

10x

NAICS Code

String

KE_NAIC_TY

NAICS Text

60x

NAICS Text

String

KE_QC_ID

Commercial Record No

nnnnnnnn

Link to SMQC.QC_ID

Long Integer

KE_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp