RCRA Pipeline Download Summary
Page status: 2025-June-25: Under development
The Enforcement and Compliance History Online (ECHO) system pipeline analysis of data from the Resource Conservation and Recovery Act (RCRA) shows links between Compliance Monitoring Activities (CMA) to any related violations and/or enforcement actions.
The download contains five files:
- PIPELINE_RCRA_READ_ME
- PIPELINE_RCRA_00_COMPLETE
- PIPELINE_RCRA_01_EVALUATIONS
- PIPELINE_RCRA_02_VIOLATIONS
- PIPELINE_RCRA_03_ENFORCEMENT_ACTIONS
PIPELINE_RCRA_READ_ME
This Read Me CSV file contains details about all five provided files in the pipeline_rcra_downloads.zip.
PIPELINE_RCRA_00_COMPLETE
This is the complete table of the RCRA pipeline analysis supporting the ECHO Pipeline RCRA Table. This table is the source table used to create the other included tables of Evaluations, Violations and Enforcement Actions. This table does NOT contain the ISN_RCR_EVAL key. This table is provided for completeness, however it is recommended to use the other three tables together with the ISN_RCR_EVAL to link all evaluations to their violations and enforcement actions.
| REGISTRY_ID | Char | 40 | 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. |
| SOURCE_ID | Char | 12 | The RCRA facility identification number. |
| EVAL_TYPE | Char | 3 | EVAL_ prefixes represent Evaluation (Compliance Monitoring Activities (CMA)) |
| EVAL_TYPE_DESC | Char | 80 | |
| EVAL_IDENTIFIER | Char | 3 | |
| EVAL_LEAD_AGENCY | Char | 5 | |
| EVAL_ACTIVITY_LOCATION | Char | 2 | |
| EVAL_DATE | Date | ||
| 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. |
| PIPELINE_FLAG | Char | 1 | An internally generated flag to indicate if the facility has at least one evaluation (eval_identifier) linked to a violation and/or enforcement action. If a facility does not have at least one evaluation linked to a violation nor enforcement action, then this value will be null, and the pipeline table will not render on the ECHO DFR page . |
| VIOL_TYPE | Char | 92 | |
| VIOL_SEQ | Number | 4, 0 | |
| VIOL_ACTIVITY_LOCATION | Char | 2 | |
| VIOL_DETERMINED_BY_AGENCY | Char | 1 | |
| VIOL_AGENCY | Char | 10 | |
| VIOL_DETERMINED_DATE | Date | ||
| ACTUAL_RTC_DATE | Date | The actual date noted for Returning To Compliance. This value may be null. This column is not the value presented in the Pipeline table. | |
| VIOL_RTC_DATE | Char | 40 | A character string representation of the ACTUAL_RTC_DATE which will replace nulls with appropriate messages. This is the value returned on the ECHO Pipeline table. |
| FOUND_VIOLATION | Char | 1 | |
| ENF_TYPE_DESC | Char | 80 | |
| CASE_ID | Char | 25 | |
| ENF_ACTION_DATE | Date | ||
| PENALTY_AMOUNT | Number | ||
| ENF_COMP_ACTION_COST | Number |
PIPELINE_RCRA_01_EVALUATIONS
This table is the non-repeating list of each RCRA evaluation and provides the ISN_RCR_EVAL key. Use the ISN_RCR_EVAL key to link to the violations in the PIPELINE_RCRA_02_VIOLATIONS table, and the enforcement actions in PIPELINE_RCRA_03_ENFORCEMENT_ACTIONS table.
| Element | Data Type | Length | Notes |
|---|---|---|---|
| ISN | NUMBER | ||
| ISN_RCR_EVAL | Char | 120 | This is the key that identifies each unique Compliance Monitoring Activity (CMA) / Evaluation to their linked Violation and/or Enforcement Action. |
| REGISTRY_ID | Char | 40 | The Federal Registry ID of the facility |
| SOURCE_ID | Char | 12 | The RCRA facility ID |
| EVAL_TYPE | Char | 3 | |
| EVAL_TYPE_DESC | Char | 80 | |
| EVAL_IDENTIFIER | Char | 3 | |
| EVAL_LEAD_AGENCY | Char | 5 | |
| EVAL_ACTIVITY_LOCATION | Char | 2 | |
| EVAL_DATE | Date | ||
| OFFICIAL_FLAG | Char | 1 | |
| PIPELINE_FLAG | Char | 1 | An internal value used by the website to indicate if the Pipeline table should be rendered. |
| NUM_OF_VIOLS | NUMBER | The number of violations linked to an evaluation (CMA). Added for QAQC purposes. | |
| NUM_OF_EA | NUMBER | The number of enforcement actions linked to an evaluation (CMA) with the ISN_RCR_EVAL key. |
PIPELINE_RCRA_02_VIOLATIONS
This provides all violations linked by ISN_RCR_EVAL key to the evaluations provided in the PIPELINE_RCRA_01_EVALUATIONS.csv table. There will be at least on record (row) for each ISN_RCR_EVAL value. Some evaluations will not have a violation, and those rows will be empty.
PIPELINE_RCRA_03_ENFORCEMENT_ACTIONS
This provides all enforcement actions linked to each evaluation by ISN_RCR_EVAL key. There will be at least on record (row) for each ISN_RCR_EVAL value. Some evaluations will not have a enforcement actions, and their row will be empty.