SMQFVC

Storm Water Quality Management Plan Violation Corrective Actions

Field Name	Caption	Mask	Description	Field Type
FA_CACTION	Corrective Action	20x	Corrective Action	String
FA_COMP	Completed		Completed	Boolean
FA_COMP_DT	Completed Date	mm/dd/yyyy hh:mm am	Completed Date	DateTime
FA_CRT_BY	Created By	25x	Created By	String
FA_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
FA_DDESC	Detailed Description	999x	Detailed Description	String
FA_DESC	Corrective Actionn Description	999x	Corrective Actionn Description	String
FA_DOC_FLG	Document Flag		Document Flag	Boolean
FA_DUE_DT	Due Date	mm/dd/yyyy hh:mm am	Due Date	DateTime
FA_FV_ID	Management Plan Inspection Violation Record No	nnnnnnnn	Link to SMQFV.FV_ID	Long Integer
FA_ID	Management Plan Violation Corrective Action Record Number	nnnnnnnn	Management Plan Violation Corrective Action Record Number	Long Integer
FA_MOD_BY	Last Modified By	25x	Last Modified By	String
FA_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
FA_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
FA_NOT_DT	Notification Date	mm/dd/yyyy hh:mm am	Notification Date	DateTime
FA_NOTES	Notes	254x	Notes	String
FA_QF_ID	Management Plan Rec No	nnnnnnnn	Link to SMQF.QF_ID	Long Integer
FA_ROWVER			Rowversion for optimistic locking	TimeStamp