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:

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.

ElementData TypeLengthNotes
REGISTRY_IDChar40The 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_IDChar12The RCRA facility identification number.
EVAL_TYPEChar3EVAL_ prefixes represent Evaluation (Compliance Monitoring Activities (CMA)).  Evaluation Types and Descriptions are presented in their own table below.
EVAL_TYPE_DESCChar80Evaluation Types and Descriptions are presented in their own table below.
EVAL_IDENTIFIERChar3 
EVAL_LEAD_AGENCYChar5 
EVAL_ACTIVITY_LOCATIONChar2 
EVAL_DATEDate  
OFFICIAL_FLAGChar1This 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_FLAGChar1An 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_TYPEChar92Violation Types and Descriptions are presented in their own table below.
VIOL_SEQNumber4, 0 
VIOL_ACTIVITY_LOCATIONChar2 
VIOL_DETERMINED_BY_AGENCYChar1 
VIOL_AGENCYChar10 
VIOL_DETERMINED_DATEDate  
ACTUAL_RTC_DATEDate 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_DATEChar40A 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_VIOLATIONChar1 
ENF_TYPE_DESCChar80 
CASE_IDChar25 
ENF_ACTION_DATEDate  
PENALTY_AMOUNTNumber  
ENF_COMP_ACTION_COSTNumber  

 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.

ElementData TypeLengthNotes
ISNNUMBER An internally generated number used as part of the unique key: ISN_RCR_EVAL
ISN_RCR_EVALChar120

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:

  • the run date of the ECHO refresh run in YYYYMMDD format,
  • a character string "_eval-",
  • a char representation of the ISN

For example: 20250621_eval-0104934

REGISTRY_IDChar40The Federal Registry ID of the facility
SOURCE_IDChar12The RCRA facility ID
EVAL_TYPEChar3Evaluation Types and Descriptions are presented in their own table below
EVAL_TYPE_DESCChar80Evaluation Types and Descriptions are presented in their own table below
EVAL_IDENTIFIERChar3 
EVAL_LEAD_AGENCYChar5 
EVAL_ACTIVITY_LOCATIONChar2 
EVAL_DATEDate  
OFFICIAL_FLAGChar1 
PIPELINE_FLAGChar1An internal value used by the website to indicate if the Pipeline table should be rendered.
NUM_OF_VIOLSNUMBER The number of violations linked to an evaluation (CMA).  Added for QAQC purposes.
NUM_OF_EANUMBER 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.

ElementData TypeLengthNotes
ISNNUMBER  
ISN_RCR_EVALChar120This is the key that identifies each unique Compliance Monitoring Activity (CMA) / Evaluation to their linked Violation and/or Enforcement Action.
REGISTRY_IDChar40The Federal Registry ID of the facility
SOURCE_IDChar12The RCRA facility ID
VIOL_TYPEChar92Violation Types and Descriptions are presented in their own table below.
VIOL_SEQNumber4, 0 
VIOL_ACTIVITY_LOCATIONChar2 
VIOL_DETERMINED_BY_AGENCYChar1 
VIOL_AGENCYChar10 
VIOL_DETERMINED_DATEDate  
ACTUAL_RTC_DATEDate  
VIOL_RTC_DATEChar40 
FOUND_VIOLATIONChar1 

 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.

ElementData TypeLengthNotes
ISNNUMBER  
ISN_RCR_EVALChar120This is the key that identifies each unique Compliance Monitoring Activity (CMA) / Evaluation to their linked Violation and/or Enforcement Action.
REGISTRY_IDChar40The Federal Registry ID of the facility
SOURCE_IDChar12The RCRA facility ID
ENF_TYPE_DESCChar80Enforcement Action Descriptions are presented in their own table below.
CASE_IDChar25 
ENF_ACTION_DATEDate  
PENALTY_AMOUNTNumber  
ENF_COMP_ACTION_COSTNumber  

 


Evaluation Types and Descriptions

Evaluation TypeEvaluation Description
CACCorrective Action Compliance Evaluation
CAVCompliance Assistance Visit
CDICase Development Inspection
CEICompliance Evaluation Inspection
CSECompliance Schedule Evaluation
FCIFocused Compliance Inspection
FRRFinancial Record Review
FSDFacility Self Disclosure
FUIFollow-Up Inspection
GMEGroundwater Monitoring Evaluation
NIRNo 3007 Information Request Received
NRRNon-Financial Record Review
OAMOperation 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