SMQFCO

Storm Water Quality Management Plan Conversations

Field Name

Caption

Mask

Description

Field Type

FC_AREP_CD

Agency Representative

nnn

Agency Representative

Integer

FC_AREP_TY

Agency Representative Text

50x

Agency Representative Text

String

FC_CDIR_CD

Contact Direction

nnn

Contact Direction

Integer

FC_CDIR_TY

Contact Direction Text

50x

Contact Direction Text

String

FC_CONTACT

Contact

50x

Contact

String

FC_CONV_DT

Conversation Date

mm/dd/yyyy hh:mm am

Conversation Date

DateTime

FC_CONV_TM

Conversation Time

mm/dd/yyyy hh:mm am

Conversation Time

DateTime

FC_CRT_BY

Created By

25x

Created By

String

FC_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

FC_DESC

Short Description

254x

Short Description

String

FC_DOC_FLG

Document Available

 

Document Available

Boolean

FC_ID

Management Plan Conversation Rec #

nnnnnnnn

Unique ID

Long Integer

FC_MOD_BY

Modified By

25x

Modified By

String

FC_MOD_DT

Modified Date

mm/dd/yyyy hh:mm am

Modified Date

DateTime

FC_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

FC_PHONE

Phone

25x

Phone

String

FC_QF_ID

Management Plan Record No

nnnnnnnn

Link to SMQF.QF_ID

Long Integer

FC_REC_DT

Recorded Date

mm/dd/yyyy hh:mm am

Recorded Date

DateTime

FC_REC_TM

Recorded Time

mm/dd/yyyy hh:mm am

Recorded Time

DateTime

FC_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp