SMQCCO

Storm Water Quality Commercial Conversations

Field Name	Caption	Mask	Description	Field Type
KC_AREP_CD	Agency Representative	nnn	Agency Representative	Integer
KC_AREP_TY	Agency Representative Text	50x	Agency Representative Text	String
KC_CDIR_CD	Contact Direction	nnn	Contact Direction	Integer
KC_CDIR_TY	Contact Direction Text	50x	Contact Direction Text	String
KC_CONTACT	Contact	50x	Contact	String
KC_CONV_DT	Conversation Date	mm/dd/yyyy hh:mm am	Conversation Date	DateTime
KC_CONV_TM	Conversation Time	mm/dd/yyyy hh:mm am	Conversation Time	DateTime
KC_CRT_BY	Created By	25x	Created By	String
KC_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
KC_DESC	Short Description	254x	Short Description	String
KC_DOC_FLG	Document Available		Document Available	Boolean
KC_ID	Commercial Conversation Rec #	nnnnnnnn	Unique ID	Long Integer
KC_MOD_BY	Modified By	25x	Modified By	String
KC_MOD_DT	Modified Date	mm/dd/yyyy hh:mm am	Modified Date	DateTime
KC_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
KC_PHONE	Phone	25x	Phone	String
KC_QC_ID	Commercial Record No	nnnnnnnn	Link to SMQC.QC_ID	Long Integer
KC_REC_DT	Recorded Date	mm/dd/yyyy hh:mm am	Recorded Date	DateTime
KC_REC_TM	Recorded Time	mm/dd/yyyy hh:mm am	Recorded Time	DateTime
KC_ROWVER			Rowversion for optimistic locking	TimeStamp