
RCRA Pipeline Download Summary
Page status: 2025-June-27: 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
Please note the terms Evaluation and Compliance Monitoring Activities (CMA) are used interchangeably.
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.
Element | Data Type | Length | Notes |
---|---|---|---|
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)). Evaluation Types and Descriptions are presented in their own table below. |
EVAL_TYPE_DESC | Char | 80 | Evaluation Types and Descriptions are presented in their own table below. |
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. A value of "Y" means yes a link does exist and the table should render. If a facility does not have at least one evaluation linked to a violation nor enforcement action, then this value will be "N", and the pipeline table will not render on the ECHO DFR page . |
VIOL_TYPE | Char | 92 | Violation Types and Descriptions are presented in their own table below. |
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 used to create the VIOL_RTC_DATE (see below), but is not the value presented in the Pipeline table. | |
VIOL_RTC_DATE | Char | 40 | A character string representation of the ACTUAL_RTC_DATE (see above) 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 | An internally generated number used as part of the unique key: ISN_RCR_EVAL | |
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. The key consists of:
For example: 20250621_eval-0104934 |
REGISTRY_ID | Char | 40 | The Federal Registry ID of the facility |
SOURCE_ID | Char | 12 | The RCRA facility ID |
EVAL_TYPE | Char | 3 | Evaluation Types and Descriptions are presented in their own table below |
EVAL_TYPE_DESC | Char | 80 | Evaluation Types and Descriptions are presented in their own table below |
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.
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 |
VIOL_TYPE | Char | 92 | Violation Types and Descriptions are presented in their own table below. |
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 | ||
VIOL_RTC_DATE | Char | 40 | |
FOUND_VIOLATION | Char | 1 |
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.
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 |
ENF_TYPE_DESC | Char | 80 | Enforcement Action Descriptions are presented in their own table below. |
CASE_ID | Char | 25 | |
ENF_ACTION_DATE | Date | ||
PENALTY_AMOUNT | Number | ||
ENF_COMP_ACTION_COST | Number |
Evaluation Types and Descriptions
Evaluation Type | Evaluation Description |
---|---|
CAC | Corrective Action Compliance Evaluation |
CAV | Compliance Assistance Visit |
CDI | Case Development Inspection |
CEI | Compliance Evaluation Inspection |
CSE | Compliance Schedule Evaluation |
FCI | Focused Compliance Inspection |
FRR | Financial Record Review |
FSD | Facility Self Disclosure |
FUI | Follow-Up Inspection |
GME | Groundwater Monitoring Evaluation |
NIR | No 3007 Information Request Received |
NRR | Non-Financial Record Review |
OAM | Operation And Maintenance Inspection |
Violation Types and Descriptions
Violation Type and Description |
---|
257.90E: CCR Report - GW monitoring |
257.91: CCR GW Monitoring |
260.A: Hazardous Waste Management System - General |
260.B: HW Management System - Definitions |
260.C: HW Management System - Rulemaking Petitions |
261.A: Listing - General |
261.B: Listing - Criteria |
261.BB: Listing - Air Emissions Standards - Equipment Leak |
261.C: Listing - Characteristics |
261.CC: Listing- Air Emisions Standards- Tanks/Containers |
261.D: Listing - Lists of HW |
261.E: Listing - Characteristics |
261.E: Listing - Exclusion / Exemptions |
261.H: Listing - Financial Requirements |
261.I: Listing - Container Use and Management |
261.J: Listing - Tank Systems Standards |
261.M: Listing - Preparedness and Response |
262.34(a): Generators - General |
262.A: Generators - General |
262.B: Generators - Manifest |
262.C: Generators - Pre-transport |
262.D: Generators - Records/Reporting |
262.E: Generators - Exports |
262.F: Generators - Imports |
262.H: Generators - Transboundary Shipments for Recovery |
262.H: Generators - Transfrontier Shipments for Recovery |
262.K: Generators- Academic Labs |
262.L: Episodic Generators |
262.M: Preparedness, Prevention, and Emergency Procedures |
263.A: Transporters - General |
263.B: Transporters - Manifest System and Recordkeeping |
263.B: Transporters - Manifest and Recordkeeping |
263.C: Transporters - HW Discharges |
264.A: TSD - General |
264.AA: TSD - Air Emission Standards - Process Vents |
264.B: TSD - General Facility Standards |
264.BB: TSD - Air Emission Standards for Equipment Leaks |
264.C: TSD - Preparedness and Prevention |
264.CC: TSD - Air Emission Standards - Tanks/SI/Containers |
264.D: TSD - Contingency Plan and Emergency Procedures |
264.DD: TSD - Containment Building Standards |
264.E: TSD - Manifest/Records/Reporting |
264.EE: TSD - Munitions/Explosives Storage |
264.F: TSD - Releases from SWMUs |
264.FF: TSD - Fees for eManifest Program |
264.G: TSD - Closure/Post-Closure |
264.H: TSD - Financial Requirements |
264.I: TSD - Container Use and Management |
264.J: TSD - Tank System Standards |
264.K: TSD - Surface Impoundment Standards |
264.L: TSD - Waste Pile Standards |
264.N: TSD - Landfill Standards |
264.O: TSD - Incinerator Standards |
264.S: TSD - Corrective Action for SWMUs |
264.W: TSD - Drip Pad Standards |
264.X: TSD - Miscellaneous Unit Standards |
265.A: TSD IS-General |
265.AA: TSD IS-Air Emission Standards - Process Vents |
265.B: TSD IS-General Facility Standards |
265.BB: TSD IS-Air Emission Standards - Equipment Leaks |
265.C: TSD IS-Preparedness and Prevention |
265.CC: TSD IS-Air Emission Standards - Tank/SI/Container |
265.D: TSD IS-Contingency Plan and Emergency Procedures |
265.DD: TSD IS-Containment Building Standards |
265.E: TSD IS-Manifest/Records/Reporting |
265.EE: TSD IS-Munitions/Explosives Storage |
265.F: TSD IS-Ground-Water Monitoring |
265.FF: TSD IS-Fees for eManifest Program |
265.G: TSD IS-Closure/Post-Closure |
265.H: TSD IS-Financial Requirements |
265.I: TSD IS-Container Use and Management |
265.J: TSD IS-Tank System Standards |
265.K: TSD IS-Surface Impoundment Standards |
265.L: TSD IS-Waste Pile Standards |
265.N: TSD IS-Landfill Standards |
265.O: TSD IS-Incinerator Standards |
265.P: TSD IS-Thermal Treatment |
265.Q: TSD IS-Chemical, Physical, AND Treatment |
265.W: TSD IS-Drip Pad Standards |
266.C: Specific - Use Constituting Disposal |
266.F: Specific - Precious Metal Recovery |
266.G: Specific - Batteries Reclaimed |
266.H: Specific - Boilers and Industrial Furnaces |
266.N: Specific - Mixed Waste Exemption |
266.P: Hazardous Waste Pharmaceuticals |
267.E: Manifest System-Recordkeeping, Rpting, Notifying |
268.A: LDR - General |
268.C: LDR - Prohibitions |
268.D: LDR - Treatment Standards |
268.E: LDR - Storage Prohibitions |
270.A: Permits - General Information |
270.B: Permits - Application |
270.C: Permits - Conditions |
270.D: Permits - Changes |
270.F: Permits - Special Forms |
270.G: Permits - Interim Status |
270.I: Permits - MACT Standards |
271.A: State Authorization Requirements |
273.A: Universal Waste - General |
273.B: Universal Waste - Small Quantity Handlers |
273.C: Universal Waste - Large Quantity Handlers |
273.D: Universal Waste - Transporters |
273.E: Universal Waste - Destination Facilities |
273.G: Universal Waste - Petitions to Include Other Waste |
279.A: Used Oil - Definitions |
279.B: Used Oil - Applicability |
279.C: Used Oil - Generators |
279.D: Used Oil - Collection Centers / Aggregation Point |
279.D: Used Oil - Collection Centers AND Point |
279.E: Used Oil - Transporter and Transfer Facility |
279.F: Used Oil - Processors and Re-refiners |
279.G: Used Oil - Burners of Off-Spec for Energy Recovery |
279.H: Used Oil - Fuel Marketers |
279.I: Used Oil - Dust Suppressant and Disposal |
FEA: Formal Enforcement Agreement or Order |
FSS: Federal or State Statute |
No New Violations Reported |
No Violation Identified |
PCR: Permit Condition or Requirement |
Undetermined |
XXS: State Statute or Regulation |
Enforcement Action Descriptions
Enforcement Action Description |
---|
30-Day Compliance Warning Letter |
3007 Letter |
3008(A) Expedited Settlement Agreement |
Abatement Order |
Action Dismissed |
Administrative Conference (Enforcement Conference Held With Facility) |
Administrative Order |
Administrative Order Appeals Process |
Administrative Penalty/Fine Collected |
Administrative Referral To Denr Collection Unit |
Administrative Referrals To Other Programs |
Administrative Referrals To Other Rcra Programs |
Agreed Order For Penalty. (Eeao - Expedited Enforcement Action Offer). |
Appeal |
Assigned To Enforcement |
Back In Compliance Ltr |
Bureau Director Decision Date |
Call-In Meeting-Settlement Meeting |
Capsb Compliance Assurance Action Letter |
Case Closed- Informal Rtc, Dereferral Or Other |
Central Office Nov Letter |
Civil Action For Compliance |
Civil Administrative Penalty [Following Hearing] |
Civil Judicial Complaint |
Commisioner'S Order - Final |
Commissioner'S Order - Initial |
Compl Corresp 15 Day Or 280(3007) Letter |
Compliance Advisory |
Compliance Communication Letter |
Consent Agreement |
Consent Assessment Of Civil Penalty |
Consent Order And Agreement |
Consent Order, No Penalties |
Criminal Indictment |
De Cease And Desist Order |
De Letter Of Warning (Low) |
De Notice Of Admin Penalty / Order |
De Notice Of Concil. Proceedings / Order |
De Notice Of Violation (Nov) |
Decision To End Case-No Further Action |
Demand For Stipulated Penalties |
Demand For Stipulated Penalty |
Demand Notice |
Dep Consent Order |
Dep Final Administrative Order |
Dep Meeting |
Dep Notice Of Violation (Nov) |
Dep Referral To Ogc |
Dep Short Form Consent Order |
Dep Warning Letter |
Director-Division Warning Letter |
District Referral To Enforcement |
Document Received |
Draft Consent Order |
Drop Action |
Drop Enforcement Action |
Enf. Action Request |
Enforcement Conference |
Enforcement Referral |
Epa Regions To Epa Hq Administrative Referral |
Epa To State Administrative Referral |
Esc Referral Back To Regional Office |
Executed Stipulation Agreement |
Expedited Citation Formal Penalty Action |
Expedited Citation Informal Penalty Action |
Expedited Enforcement Offer |
Expedited Penalty |
Extension Granted |
Facility Enforcement Meeting 3008(A) (Compliance Settlement) |
Failure To Comply With Informal Enforcement Action |
Field Citation |
Field Citation - Md Nov |
Field Compliance Order |
Field Fast Track Order Initiation |
Field Inspection Report |
Field Noc |
Field Noc |
Field Notice Of Violation |
Final 3008(A) Compliance Order |
Final 3008(A) Sfo Order |
Final 3008(H) I.S. Ca Order |
Final Civil Judicial Action For Compliance And/Or Monetary Penalty |
Final Civil Judicial Action For Imminent And Substantial Endangerment |
Final Civil Judicial Action For Interim Corrective Action |
Final Consent Order |
Final Determination-Administrative Order Executed |
Final Expedited Enforcement Offer |
Final Imminent Hazard Order |
Final Judicial Order Issued |
Final Penalty |
Final Penalty Assessment |
Final Penalty Letter |
Final Penalty Settlement Order |
Final Settlement |
Forgiveable & Non-Forgiveable Apo |
Forgiveable Admn Penalty Order(Apo) |
Immediate Action Letter |
Informal Actions |
Informal Written Notification |
Information Request Letter(3007) |
Init. 3008(H) I.S. Ca Order |
Initial 3008(A) Compliance |
Initial 3008(A) Compliance |
Initial Civil Judicial Action For Compliance And/Or Monetary Penalty |
Initial Civil Judicial Action For Corrective Action |
Initial Consent Degree Judgement |
Initial Expedited Enforcement Offer |
Initial Imminent And Substantial Endangerment Order |
Initial Monitoring,Analysis,Test Order |
Initial Proposed Consent Order |
Injunctive Relief |
Inspection Report Sent No Viol No Response |
Inspection Report W/Violations (Mailed Date) |
Inspection Report Written |
Inspector Fact Finding Letter - Warning Letter |
Internal Agency Referral |
Investigative & Inspection Cost 3008(A) (Compliance Order) |
Ipcb Administrative Complaint |
Ipcb Final Administrative Order |
Judicial Consent Decree |
Letter Of Intent To Initiate Enforcement Action |
Letter Of Warning |
Letter Of Warning (Low) |
Multi Site Ca/Fo |
No Further Action |
Noc/Notice Of Opportunity To Correct |
Noc/Nov Received By Facility |
Non-Forgiveable Apo |
Notice Of Civil Administrative Penalty |
Notice Of Deficiency |
Notice Of Determination |
Notice Of Hearing And Complaint |
Notice Of Intent To Pursue Legal Action |
Notice Of Noncompliance |
Notice Of Noncompliance Letter |
Notice Of Potential Penalty |
Notice Of Violation |
Notice Of Violation & Settlement |
Notice Of Violation (Nov) |
Notice Of Violation Letter |
Notice Of Violation With Penalty (Novp) |
Notice To Comply |
Nov Received By Facility |
Nov/Initial State Admin Consent Order |
Nov/Received By Facility |
Novco With Penalty |
Partial Judicial Order |
Penalty Assessment Team Meeting |
Penalty Negotiation Letter |
Petition For Contempt |
Pre-Enforcement Notice |
Proposed Agreed Order (Pao) Sent |
Proposed Cao |
Rcra Action Dropped- No Violation |
Rcra Action Dropped-No Violation |
Rcra To Cercla Administrative Referral |
Receive Facility Documentation |
Received Facility Documentation |
Referral To Attorney General |
Referral To Department Of Justice |
Referral To Enforcement |
Referral To Esc Enforcement Screen Comm. |
Referred To Civil Administrative Penalty (Cap) Program |
Referred To Environmental Enforcement |
Release Of Notice Of Violation |
Release Of Violation |
Remanded For Hearing |
Remedial Action Order |
Return To Compliance Letter |
Revised Proposed Consent Order |
Revoked Or Dismissed Initial Formal 210 Compliance Order |
Rtc - Cafo Signed |
Satisfaction Letter |
Schedule Of Compliance |
Seal Order |
Second Letter Of Warning (120) |
Settlement Agreement |
Show Cause Conference |
Show Cause Meeting |
Show Cause Meeting - Declined |
Single Site Ca/Fo |
Single Site Cafo And Dcc |
Site Complaint |
Snc Determined |
Special Order Pursuant To 10.1-1186 |
State Compliance Order 3008(A) |
State Consent/Compliance Order 3008(A) |
State Rcra/Refer To State Superf/Remedia |
State To Epa Administrative Referral |
Stipulated Judicial Order, With Penalty |
Stipulated Penalty Call-In |
Stipulated Penalty Demand Letter |
Summary Citation |
Summary Of Violations |
Technical Assistance Letter Sent |
Ten Day Letter |
Termination Of Enforcement Order |
Unilateral Order |
Unilateral Order, No Penalties |
V3 Conversion Compliance Advisory |
Verbal Informal |
Violation Letter - Intent To Submit To Deq Enf |
Violation Notice (Vn) |
Warning Letter |
Wi State Administrative Order |
Written Complaint |
Written Informal |