CAA Pipeline Download Summary
The Enforcement and Compliance History Online (ECHO) system pipeline analysis of data from the Clean Air Act (CAA) shows links between Compliance Monitoring Activities (CMA) to any related violations and/or enforcement actions.
The terms "Compliance Monitoring Activities" and "Evaluations" will be used interchangeably on this page.
The download contains the following file:
PIPELINE_CAA_00_COMPLETE
| Element | Data Type | Length | Notes |
|---|---|---|---|
| SORT_ORDER | Number | A generated field to aid in the linkage creation. | |
| SORT_DATE | Date | A linkage creation helper field to help get the proper display order by date. | |
| SOURCE_ID | Char | 30 | The Clean Air Act facility identification number. |
| REGISTRY_ID | Char | 50 | The Federal Registry Identification number. Software programs reading the CVS may attempt to convert this to scientific notation. This is a character field to preserve leading zeros. |
| AIR_NAME | Char | 200 | The facility name. |
| PIPELINE_FLAG | Char | 1 | An internally generated flag to indicate at least violation (VIOL_ACTIVITY_ID) linked to an evaluation and/or enforcement action. A value of "Y" means "Yes a link does exist" and the pipeline table should render on the ECHO DFR page. |
| OFFICIAL_FLAG | Char | 1 | This flag is set to 'Y' when an entry is counted as compliance monitoring strategy activities. Programs without compliance monitoring strategies will have this flag set to null and are not counted as on-site activities within EPA’s Annual Results. |
| EVAL_FLAG | Char | 1 | An internally generated flag to indicate if there is at least one Compliance Monitoring Activity (CMA) (evaluation) to the violation activity id (VIOL_ACTIVITY_ID). |
| EVAL_SORT_ORDER | Number | An internally generated field to help with the sort order of the evaluations data. | |
| EVAL_ACTIVITY_ID | Number | The evaluation activity identification value. | |
| EVAL_TYPE_DESC | Char | 100 | The description of the evaluation type. |
| EVAL_LEAD_AGENCY | Char | 5 | The agency responsible for evaluation. |
| EVAL_DATE | Date | The date of the evaluation. | |
| VIOL_FLAG | Char | 1 | A system generated flag indicating a violation is present. Entries noted as violation not found with have a generated VIOL_ACTIVITY_ID to use as links between Evaluations and Enforcement Actions. A generated VIOL_ACTIVITY_ID starts with either "9906" or "9913". |
| VIOL_SORT_ORDER | Number | An internally generated value to aid with the proper ordering of the identified violations. | |
| FOUND_VIOLATION | Char | 1 | A flag indicating if a violation was found. |
| VIOL_ACTIVITY_ID | Number | The key linking all violations to their Compliance Monitoring Activities (CMA) and/or Enforcement Actions (EA). This is a number, and should NOT be converted to scientific notation. Values that start with either "9906" or "9913" did not have an actual violation activity identification number, so these are system generated for purposes of creating the pipeline table. | |
| VIOL_TYPE | Char | 40 | A description of the found violation type. |
| VIOL_TYPE_SORT | Number | A generated field providing a sort order of the violation types found. | |
| VIOL_LEAD_AGENCY | Char | 6 | The agency responsible for identifying the violation. |
| VIOL_PROGRAMS | Char | 4000 | The programs under which the violation is defined. |
| VIOL_POLLUTANT_CODES | Char | 4000 | A list of the pollutant codes of the violation |
| VIOL_POLLUTANT_DESCS | Char | 4000 | A list of the pollutant descriptions of the violation |
| VIOL_START_DATE | Date | The start date of the violation | |
| VIOL_END_DATE_DATE | Date | The end date of the violation. | |
| VIOL_END_DATE | Char | 40 | A character representation of the violation end date. This is the value represented in the Pipeline table on the ECHO DFR |
| EA_FLAG | Char | 1 | A system generated flag indicating if there is an enforcement action. |
| EA_SORT_ORDER | Number | A system generated sort order for proper displaying of the enforcement action. | |
| EA_ACTIVITY_ID | Number | The enforcement action activity identification | |
| EA_FEA_ACTIVITY_ID | Number | The formal enforcement activity id | |
| EA_TYPE | Char | 100 | The type of enforcement action |
| EA_DATE | Date | Date of the Enforcement Action | |
| FEA_ISSUE_DATE_FLAG | Char | 1 | A flag indicating there is a formal enforcement date of issue |
| EA_PENALTY_AMT | Number | The enforcement action penalty amount |