SMQCSIC

Storm Water Quality Commerical SIC Codes

Field Name

Caption

Mask

Description

Field Type

KS_CRT_BY

Created By

25x

Created By

String

KS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

KS_ID

Commercial SIC Rec #

nnnnnnnn

Commercial SIC Rec #

Long Integer

KS_MOD_BY

Last Modified By

25x

Last Modified By

String

KS_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

KS_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

KS_QC_ID

Commercial Record No

nnnnnnnn

Link to SMQC.QC_ID

Long Integer

KS_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

KS_SIC_CD

SIC Code

nnn

SIC Code

Integer

KS_SIC_TY

SIC Text

50x

SIC Text

String