Column Name: CORRECTIVE_ACTION_ID

Description: Contains an identifying value referencing a corrective action in the primacy agency's system of record. This column is conditionally mandatory based upon the type of violation per the rule reporting guidance. As an example, both IESWTR and GWR require that when reporting a type 45 - failure to address a deficiency, that the corrective action prescribed to the water system by the primacy agency be reported with the violation (GWR 141.403(a)(4)).
Envirofacts Table Name(s):

• VIOLATION

Properties:

• Type:VARCHAR2
• Length:40

Definition Source:DataMart Table