RCRAInfo National Reports

1. RCRAInfo National Reports 2005 RCRAInfo National Users Conference August 2 – 5, 2005 Nashville, TN

2. PRESENTATION OUTLINE • Physical Location vs. Activity Location Selection Options • Standard Selection Criteria for CM&E Reports • Standard Report Format for CM&E Reports • New Reports Available in V3 • Enforcement Sensitive Information • Report Security • BR Reporting Table • BARRT Query Tool

3. ACTIVITY LOCATION VS. PHYSICAL LOCATION SELECTION OPTIONS Choose either a Physical Location (state/region/national) OR an Activity Location (state) • Physical Location Options: • Regardless of where the activity occurred • Only activities performed within the specified physical site location • Only activities performed outside the specified physical site location • Activities Performed In Options: • Regardless of where the site is physically located • Only sites physically located within the specified activity performance location • Only sites physically located outside the specified activity performance location

4. EXAMPLE 1 Example Data: Results:

5. EXAMPLE 2 Example Data: Results:

6. EXAMPLE 3 Example Data: Results:

7. SELECTING A PHYSICAL OR ACTIVITY LOCATION

8. STANDARD OPTIONS AVAILABLE FOR V3 REPORTS (CM&E REPORTS) • Physical Location • Activity Performed In • Group of Ids • Handler Name • Handler ID • Location County Code • Location Zip Code • Location City • State District • Date Range (based on applicable data)

9. STANDARD OPTIONS AVAILABLE FOR V3 REPORTS (CM&E REPORTS) (Cont’d) • Universe • Operating TSDs • Full Enforcement TSDs • Large Quantity Generator • Small Quantity Generator • Conditionally-Exempt Small Quantity Generator • Transporters • Significant Non-Compliers • Extract Flag (All / Public Sites Only / Non-Public Sites Only) • Display Code Descriptions • Unaddressed SNC (State only/ EPA only/ All) • Addressed SNC (State only/ EPA only/ All) • SNC with a Compliance Schedule (State only/ EPA only/All)

10. STANDARD SELECTION CRITERIA

11. V3 REPORT FORMATS EVALUATION INFORMATION Line 1 - Evaluation Type, Evaluation Start Date, Activity Location, Agency, Evaluation Identifier, Responsible Person, Suborganization, Found Violation Flag Line 2 - Citizen Complaint Flag, Multi-media Inspection Flag, Sampling Flag, Not Subtitle C Flag, Day Zero, Focus Area (applies only to FCI evaluations) Line 3 - Notes

12. V3 REPORT FORMATS (cont’d) VIOLATION INFORMATION Line 1 - Activity Location, Violation Type, Determined Date, Determination Agency, Responsible Agency, Scheduled Compliance Date, Actual RTC Date, Violation Sequence Line 2 - Citation Sequence, Citation Type, Citation, Notes Line 3 - Former Citation Line 4 - Notes

13. V3 REPORT FORMATS (cont’d) ENFORCEMENT INFORMATION Line 1 - Activity Location, Enforcement Type, Enforcement Date, Enforcement Identifier, Docket Number, Agency, Responsible Person, Suborganization, Responsible Attorney, Proposed Penalty, Final Monetary Penalty, Collected Amount, Total Final Penalty Line 2 - SNY Date, Corrective Action Component Flag, Disposition Status, Disposition Status Date, Appeal Initiated Date, Appeal Resolution Date, CA/FO Sequence, Respondent Name, Lead Agency Line 3 - SEP Sequence, SEP Type, Expenditure Amount, Scheduled Completion Date, Defaulted Date Line 4 - Notes

14. SAMPLE REPORT LAYOUT

15. NEW REPORTS AVAILABLE IN V3 • QA/QC REPORTS • QA/QC Commitment/Initiative Data • review progress towards the accomplishment of commitments; list commitments that are not linked to an evaluation. • QA/QC of SNY/SNN Evaluations Not Linked to Violations • review SNY and/or SNN evaluations that are not linked to • violations. Note: the linking of violations to SNY/SNN evaluations is optional, therefore, this report will not have meaning for some implementers. • QA/QC Information Request Data • review open information requests and information requests that • are not linked to an evaluation.

16. NEW REPORTS AVAILABLE IN V3 (cont’d) • QA/QC REPORTS • QA/QC RCRA Section 6002 Data • review EPA conducted evaluations at federal facilities. • QA/QC SNCs With Open Technical Requirements • review sites that have been unclassified as a SNC but • have remaining open technical requirements. • QA/QC of Open SEPs • review open supplemental environmental projects (SEPs) that are • coming due or that are past due.

17. NEW REPORTS AVAILABLE IN V3 (cont’d) • EVALUATION-BASED REPORTS • Count of RCRA Section 6002 Data • counts the number of RCRA 6002 inspections performed, number • of RCRA 6002 questionnaires distributed, number of RCRA 6002 • questionnaires completed and mailed, number of inspector • questionnaires received by FFEO, and number of site questionnaires • received by FFEO.

18. NEW REPORTS AVAILABLE IN V3 (cont’d) • EVALUATION-BASED REPORTS • Pre-Inspection Report • provides inspectors with all relevant site information prior to an • inspection including evaluation information, violation information, • enforcement information, the most recent waste activity (biennial • report) information, the most recent permit information, and all • corrective action activity. Evaluations With Found Violation of “Undetermined” provides evaluations which are still being worked on (i.e., a determination has not been made regarding if the evaluation found any violations)

19. CM&E EVALUATION REPORTS

20. NEW REPORTS AVAILABLE IN V3 (cont’d) VIOLATION-BASED REPORTS Tickler Report for Scheduled Return to Compliance (RTC) Dates provides sites/violations whose scheduled return to compliance (RTC) dates that are coming due or that are past due. Citation Report allows users to report violations based on citations which were violated, either federal citation or state citation (if defined in RCRAInfo).

21. CM&E VIOLATION REPORTS

22. NEW REPORTS AVAILABLE IN V3 (cont’d) ENFORCEMENT-BASED REPORTS Listing of Multiple Consent Agreements/Final Orders (CA/FOs) provides information regarding multi-locational consent agreements/final orders (CA/FOs) Tickler Report for Technical Requirements provides enforcement actions where the technical requirements are coming due or that are past due. Tickler Report for Payments That Are Over Due provides payment information for payments that are past due. Tickler Report for SEPs That Are Over Due provides enforcement information and SEP information for SEPs that are past due. Open CM&E Activities Report reports facilities with pending enforcement actions and unresolved violations.

23. CM&E ENFORCEMENT REPORTS

24. REPORTS FOR PUBLIC USE VS. INTERNAL USE • CM&E FOIA Report – Only report designed for public use • Enforcement Sensitive Information • Commitment/Initiative Information until it is linked to an evaluation • 400 series enforcement actions (Judicial Referrals) that are linked to violations that are not linked to 500 series actions (Civil Judicial Action) • Criminal Actions (enforcements 700-709) and Referrals to Criminal (710-719) that are linked to violations that are not linked to Criminal Indictments (enforcement action 720-729), or Criminal Convictions (enforcement action 730-739), or Criminal Acquittal (enforcement action 740-749) • All CM&E Note Fields • Look-up table information with a usage code of 2, 4, 6, or 8

25. HEADQUARTERS MANAGEMENT REPORTS • New reports for the 2006 Permit and Renewal Baselines • Currently tweaking 2006 Baseline reports to meet the specific needs of each baseline (permit and renewal) • Additional reports will be developed for the 2008 GPRA Permit Baseline • Summary of Progress • Detailed Baseline • Units Eligible for Verification of non-Permit Controls • Units Meeting the Goal • Facilities Meeting the Goal • Facilities Not-Meeting the Goal • Units on the Baseline

26. REPORT SECURITY Users must have at least Read Access to ALL of the modules referenced by the report to execute the report Continued…

27. REPORT SECURITY (Cont’d)

28. BR REPORTING TABLE • Designed to make BR reporting easier across BR cycles, respecting the reporting definitions (select logic) of each cycle • Currently has data for 2001 and 2003 BR cycles • BR cycles prior to 2001 will closely emulate the National Reports but will not produce exact results due to the conversion of data from Version 1 to Version 2 • Will be used for Envirofacts queries

29. BR REPORTING TABLE CONTENTS Handler ID Generator Waste Included in NBR Generation Tons Activity Location Manager Included in NBR  Managed Tons Source Type Manager Waste Included in NBR  Shipped Tons Sequence Number Shipper Included in NBR Received Tons Form Page Number Shipper Waste Included in NBR Shipped to ID Subform Page Number Receiver Included in NBR Shipped to State Form Type (GM or WR) Receiver Waste Included in NBR Shipped to State Name Management Location Waste Description Shipped to Region Report Cycle Source Code Received from ID State Form Code Received from State State Name Management Method Received from State Name Region Federal Waste Code Flag (Y/N) Received from Region Generator Included in NBR Wastewater Flag (Y/N) Federal Waste Codes

30. BARRT QUERY TOOL • Build custom queries using point-and-click technology • Create output as Screen Display or a Text File • Execute saved (pre-built) queries • Query from any combination of Handler, CM&E, Corrective Action, Permitting, and NCAPS Ranking information

31. SELECT A MODULE(S)

32. SELECT DATA FIELDS

33. ADD DATA CONSTRAINTS

34. SELECT SORT ORDER

35. REVIEW OUTPUT