SMQMCO

Storm Water Quality Municipal Conversations

Field Name

Caption

Mask

Description

Field Type

LC_AREP_CD

Agency Representative

nnn

Agency Representative

Integer

LC_AREP_TY

Agency Representative Text

50x

Agency Representative Text

String

LC_CDIR_CD

Contact Direction

nnn

Contact Direction

Integer

LC_CDIR_TY

Contact Direction Text

50x

Contact Direction Text

String

LC_CONTACT

Contact

50x

Contact

String

LC_CONV_DT

Conversation Date

mm/dd/yyyy hh:mm am

Conversation Date

DateTime

LC_CONV_TM

Conversation Time

mm/dd/yyyy hh:mm am

Conversation Time

DateTime

LC_CRT_BY

Created By

25x

Created By

String

LC_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

LC_DESC

Short Description

254x

Short Description

String

LC_DOC_FLG

Document Available

 

Document Available

Boolean

LC_ID

Municipal Conversation Rec #

nnnnnnnn

Auto ID

Long Integer

LC_MOD_BY

Modified By

25x

Modified By

String

LC_MOD_DT

Modified Date

mm/dd/yyyy hh:mm am

Modified Date

DateTime

LC_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

LC_PHONE

Phone

25x

Phone

String

LC_QM_ID

Municipal Record No

nnnnnnnn

Link to SMQM.QM_ID

Long Integer

LC_REC_DT

Recorded Date

mm/dd/yyyy hh:mm am

Recorded Date

DateTime

LC_REC_TM

Recorded Time

mm/dd/yyyy hh:mm am

Recorded Time

DateTime

LC_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp