SMQICO

Storm Water Quality Industrial Conversations

Field Name	Caption	Mask	Description	Field Type
UC_AREP_CD	Agency Representative	nnn	Agency Representative	Integer
UC_AREP_TY	Agency Representative Text	50x	Agency Representative Text	String
UC_CDIR_CD	Contact Direction	nnn	Contact Direction	Integer
UC_CDIR_TY	Contact Direction Text	50x	Contact Direction Text	String
UC_CONTACT	Contact	50x	Contact	String
UC_CONV_DT	Conversation Date	mm/dd/yyyy hh:mm am	Conversation Date	DateTime
UC_CONV_TM	Conversation Time	mm/dd/yyyy hh:mm am	Conversation Time	DateTime
UC_CRT_BY	Created By	25x	Created By	String
UC_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
UC_DESC	Short Description	254x	Short Description	String
UC_DOC_FLG	Document Available		Document Available	Boolean
UC_ID	Industrial Conversation Rec #	nnnnnnnn	Unique ID	Long Integer
UC_MOD_BY	Modified By	25x	Modified By	String
UC_MOD_DT	Modified Date	mm/dd/yyyy hh:mm am	Modified Date	DateTime
UC_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
UC_PHONE	Phone	25x	Phone	String
UC_QI_ID	Industrial Record No	nnnnnnnn	Link to SMQI.QI_ID	Long Integer
UC_REC_DT	Recorded Date	mm/dd/yyyy hh:mm am	Recorded Date	DateTime
UC_REC_TM	Recorded Time	mm/dd/yyyy hh:mm am	Recorded Time	DateTime
UC_ROWVER			Rowversion for optimistic locking	TimeStamp