Facility Name Current or historical facility name FACILITY AIR_FACILITY_DIM Facility_Name_FI Facility Program System Acronym Acronym for the system of record for the facility FACILITY AIR_FACILITY_DIM Facility Program System Identifier Programmatic Facility unique identifier FACILITY AIR_FACILITY_DIM FRS Identifier FRS unique facility site identifier FACILITY AIR_FACILITY_DIM Facility_UIN_FRS Facility Current Default Classification Default facility classification FACILITY AIR_CLASS_DIM Where .Current_Flag=Y Facility Current EPA Classification EPA facility classification FACILITY AIR_CLASS_DIM Where .Current_Flag=Y Facility Current Delegated Agency Classification Delegated Agency facility classification FACILITY AIR_CLASS_DIM Where .Current_Flag=Y Facility Current Pollutants Pollutant(s) associated with the facility FACILITY Pollutant_Desc Where Facility Current Air Programs Program(s) associated with the facility FACILITY Program_Desc Where Facility Current Subparts Subparts associated with the facility FACILITY Where Facility Current Operating Status Most “active” current operating status of the facility’s programs FACILITY Where Facility Universe Reporting universe(s) associated with the facility FACILITY Activity Input Prompts Activity Performed By Region Region performing the activity (if an EPA activity) FACILITY Region_Code Includes HQ, 01-10 Activity Performed By State State performing the activity (if a State activity) FACILITY State_Code Activity Performed By LCON LCON performing the activity (if an LCON activity) FACILITY Air_LCON_Desc
Pathway Activity Type Description Activity Type Description of the pathway activity Copy from REF_ACTIVITY_TYPE Warehouse Pathway Activity Name Activity Name for the pathway activity Copy ACTIVITY_NAME from ICIS_ACTIVITY Warehouse Pathway Activity UID Activity unique identifier for the pathway activity Warehouse Pathway Activity Source Warehouse For violations with multiple HPV-Day-Zero dates, this holds the earliest date. Get the minumun HPV_Day_Zero_Date from the table for every Case File. Warehouse Other Air_LCON_Code State_Code Region_Code Geo data is added to the table from the ICIS_ACTIVITY table to be used for filtering sensitive data based on the Sensitive_Data_Flag Copy data from ICIS_ACTIVITY for each Case File Violation where the Facility was advised. Warehouse Air_LCON_Code State_Code Region_Code Geo data is added to the AIR_CASE_FILE_VIOLATION table from the ICIS_ACTIVITY table to be used for filtering sensitive data based on the Sensitive_Data_Flag Copy data from ICIS_ACTIVITY for each Case File Violation where the Facility was advised. Warehouse Air_LCON_Code State_Code Region_Code Geo data is added to the table from the ICIS_ACTIVITY table to be used for filtering sensitive data based on the Sensitive_Data_Flag Copy data from ICIS_ACTIVITY for each Case File Violation where the Facility was advised. Warehouse Determination_Date This will be either Comp_Determination_Date, or if that’s null, the earliest FRV determination date from the violations table. Warehouse This is the Pathway_Activity_Date from AIR_CASE_FILE_PATHWAY where Pathway_Category_Code = DSCV Copy Pathway_Activity_Date from where Pathway_Category_Code = DSCV Warehouse This is the Pathway_Activity_Date from AIR_CASE_FILE_PATHWAY where Pathway_Category_Code =NTFC Copy Pathway_Activity_Date from where Pathway_Category_Code = NTFC Warehouse
Facility Updated Date Options Updated Parent FRS Record Facility Common Report Objects FRS Facility Created/Updated Parent FRS Record FRS Created FRS Facility Created/Updated FRS Created Date Options FRS Created FRS Updated FRS Facility Created/Updated FRS Updated Date Options FRS Updated SICs Facility Common Report Objects All SICs associated with the facility, including the primary SIC. NAICSs Facility Common Report Objects All NAICS associated with the facility, including the primary NAICS. Facility Name History Facility Common Report Objects History of facility name changes. Portable Sources Facility Common Report Objects Portable source history for the facility. Portable Sources Begin Date Options Portable Sources Portable Sources End Date Options Portable Sources Universes Facility Common Report Objects Nonattainment Areas Facility Common Report Objects Designation Date Options Nonattainment Areas Programs and Subparts Facility Common Report Objects Programs and sub parts associated with the facility, including the full history of operating status for each program. Program Begin Date Options Programs and Subparts Program End Date Options Programs and Subparts Programs and Subparts Current Only Facility Common Report Objects Objects from this folder displays the current value, or, if only a historic value is present or no records are present, it is null. Facility Operating Status History Facility Common Report Objects Calculated operating status history of the facility based on the operating status for each program. Operating Status Begin Date Options Facility Operating Status History Operating Status End Date Options Facility Operating Status History Facility Operating Status History Current Only Facility Common Report Objects Objects from this folder displays the current value, or, if only a historic value is present or no records are present, it is null. Pollutant History Facility Common Report Objects Pollutants associated with the facility, including the full history of classification statuses for EPA, DA, and Default for each pollutant. Pollutant/Class Begin Date Options Pollutant History Pollutant/Class End Date Options Pollutant History Pollutant History Current Only Facility Common Report Objects Objects from this folder displays the current value, or, if only a historic value is present or no records are present, it is null. Facility Classification History Facility Common Report Objects Calculated classification history of the facility based on the classification statuses for EPA, DA, and Default for each pollutant. Classification Begin Date Options Facility Classification History Classification End Date Options Facility Classification History Facility Classification History Current Only Facility Common Report Objects Objects from this folder displays the current value, or, if only a historic
Xref_Activity_Agency_Type_Id AIR_EA_AGENCY_TYPE Activity_ID AIR_EA_AGENCY_TYPE Activity_ID Agency_Type_Code AIR_EA_AGENCY_TYPE Agency_Type_Code Agency_Lead_Flag AIR_EA_AGENCY_TYPE Agency_Lead_Flag Created_By AIR_EA_AGENCY_TYPE Created_By Created_Date AIR_EA_AGENCY_TYPE Created_Date Updated_By AIR_EA_AGENCY_TYPE Updated_By Updated_Date AIR_EA_AGENCY_TYPE Updated_Date REF_AGENCY_TYPE Agency_Type_Desc AIR_EA_AGENCY_TYPE Agency_Type_Desc REF_AGENCY_TYPE Activity_Group_Code AIR_EA_AGENCY_TYPE Activity_Group_Code BCP_ID BCP_ID Activity_ID Activity_ID Superfund_ID_Nmbr Superfund_ID_Number BCP_Civil_Penalty BCP_Civil_Penalty BCP_Comp_SEP BCP_Comp_SEP BCP_Pollutant_Reduction BCP_Pollutant_Reduction BCP_Cost_Recovery BCP_Cost_Recovery BCP_Contaminated_Soil BCP_Contaminated_Soil BCP_Contaminated_Water BCP_Contaminated_Water Fiscal_Year Fiscal_Year BCP_Comment BCP_Comment Sensitivity_Level Sensitivity_Level Created_By Created_By Created_Date Created_Date Updated_By Updated_By Updated_Date Updated_Date ICIS_ACTIVITY Air_LCON_Code Air_LCON_Code ICIS_ACTIVITY State_Code State_Code ICIS_ACTIVITY Region_Code Region_Code Activity_Cross_Media_ID AIR_EA_CROSS_MEDIA Activity_Cross_Media_ID Activity_ID AIR_EA_CROSS_MEDIA Activity_ID Fed_Facility_Indicator_Code AIR_EA_CROSS_MEDIA Fed_Facility_Indicator_Code Fed_Facility_Comment AIR_EA_CROSS_MEDIA Fed_Facility_Comment Created_By AIR_EA_CROSS_MEDIA Created_By Created_Date AIR_EA_CROSS_MEDIA Created_Date Updated_By AIR_EA_CROSS_MEDIA Updated_By Updated_Date AIR_EA_CROSS_MEDIA Updated_Date N N N N N N N N N N N N N N
AIR_CASE_FILE_DIM Owned_By If State_EPA_Flag=E and Region_Code IS HQ, then set this to “HQ”. Else if State_EPA_Flag=E and Region_Code IS NOT HQ, then set this to “REGION”. Else if State_EPA_Flag=S then set this to “STATE” else if State_EPA_Flag=L then set this to “LCON”. AIR_CASE_FILE_DIM Geographic_Access If State_EPA_Flag = then copy the Region_Code here, else if State_EPA_Flag = then copy the State_Code here, else if State_EPA_Flag = then copy the LCON_code here. AIR_CASE_FILE_PROGRAM Air_Case_File_Program_Key Uniquely created with row AIR_CASE_FILE_PROGRAM Air_Case_File_Key Copy from when row is created. Program_Code AIR_CASE_FILE_PROGRAM Program_Code REF_PROGRAM Program_Desc AIR_CASE_FILE_PROGRAM Program_Desc Copy after looking-up Program_Code in the REF_PROGRAM table REF_PROGRAM Program_Category_Code AIR_CASE_FILE_PROGRAM Program_Category_Code Program_Category_Desc AIR_CASE_FILE_PROGRAM Program_Category_Desc Copy after looking-up in AIR_CASE_FILE_PROGRAM Activity_Prog_on_Fac_Flag Set to “N” by default, then loop through all of the programs associated with this facility and this activity and set each one to “Y” Air_Case_File_Pollutant_Key Uniquely created with row Air_Case_File_Key Copy from when row is created. Pollutant_Code Pollutant_Code Created_By Created_By Created_Date Created_Date Updated_By Updated_By Updated_Date Updated_Date REF_POLLUTANT Pollutant_Desc Pollutant_Desc Copy after looking-up Pollutant_Code in the REF_POLLUTANT table REF_POLLUTANT Pollutant_Category_Code Pollutant_Category_Code REF_POLLUTANT Chemical_Fomula Chemical_Fomula REF_POLLUTANT REF_POLLUTANT User_Flag User_Flag
Law_Section_Code Law_Section_Code Rank_Order Rank_Order REF_LAW_SECTION Law_Section_Desc Law_Section_Desc REF_LAW_SECTION Ref_Law_Section_Id Ref_Law_Section_ID REF_STATUTE Statute_Desc Statute_Desc Uniquely created with row. Air_Case_File_Key Copied from when row is created. Activity_ID Activity_ID Agency_Type_Code Agency_Type_Code Agency_Lead_Flag Agency_Lead_Flag REF_AGENCY_TYPE Agency_Type_Desc Agency_Type_Desc REF_AGENCY_TYPE Activity_Group_Code Activity_Group_Code Air_Case_File_Key Copy from when row is created. Fac_Advised_Violation_Code Fac_Advised_Violation_Code Fac_Advised_Violation_Date Fac_Advised_Violation_Date Created_By Created_By Created_Date Created_Date Updated_By Updated_By Updated_Date Updated_Date Fac_Advised_Violation_Desc Fac_Advised_Violation_Desc Copy after looking up in table AIR_CASE_FILE_DIM Owned_By Owned_By Copy from for every new row in this table matching on Air_Case_File_Key. AIR_CASE_FILE_DIM State_EPA_Flag State_EPA_Flag AIR_CASE_FILE_DIM Sensitive_Data_Flag Sensitive_Data_Flag AIR_CASE_FILE_DIM Region_Code Region_Code AIR_CASE_FILE_DIM State_Code State_Code AIR_CASE_FILE_DIM Air_LCON_Code Air_LCON_Code AIR_CASE_FILE_DIM Geographic_Access Geographic_Access Air_Case_File_Violation_Key Uniquely created with row Air_Case_File_Key Copy from when row is created. ICIS_Air_Comp_Det_Viol_ID ICIS_Air_Comp_Det_Viol_ID Activity_ID Activity_ID Air_Violation_Type_Code Air_Violation_Type_Code
PERFORMED BY STATE: <State> PERFORMED BY LCON: <LCON> ACTIVITY PROGRAM: <Program> ACTIVITY SUBPART: <Subpart> ACTIVITY POLLUTANT: <Pollutant> Added Facilities Facility Name: Facility 1 Facility ID: 1234567890 FRS ID: 1234567890 Default Classification: 123ABC, Non-Critical Primary SIC: ABC, SIC Name Primary NAICS: XYZ, NAICS Name Government Ownership: 987, EPA XYZ Current Default Classification: 123ABC, Non-Critical Current Programs Air Program Current Operating Status Current Start Date Current Shutdown Date Program 1 Active 02/01/2002 12/31/2015 Program 2 Active 02/02/2002 12/31/2015 Program 3 Active 02/03/2002 12/31/2015 Facility Name: Facility 2 Facility ID: 0987654321 FRS ID: 0987654321 Default Classification: 123ABC, Non-Critical Primary SIC: ABC, SIC Name Primary NAICS: XYZ, NAICS Name Government Ownership: 987, EPA XYZ Current Default Classification: 123ABC, Non-Critical Current Air Programs Program Name Current Operating Status Current Start Date Current Shutdown Date Program 1 Active 03/01/2002 12/31/2015 Program 2 Active 03/02/2002 12/31/2015 Program 3 Active 03/03/2002 12/31/2015 The Environmental Protection Agency Sensitive Data? No Integrated Compliance Information System Critical Data Element Report
The Environmental Protection Agency Sensitive Data? No Integrated Compliance Information System Critical Data Element Report PERFORMED BY REGION: <Region> PERFORMED BY STATE: <State> PERFORMED BY LCON: <LCON> ACTIVITY PROGRAM: <Program> ACTIVITY SUBPART: <Subpart> ACTIVITY POLLUTANT: <Pollutant> Updated CMS CMS Source Category Reason for Changing CMS CMS Minimum Frequency CMS Effective Frequency Active on Agency CMS Plan Date Removed from Agency CMS Plan CMS Origination Date CMS Start Date Next FCE Due Date CMS Start Date Current CMS Status Reason for Changing CMS Historical CMS values Historical CMS FY Historical CMS Category Historical CMS Frequency Historical CMS Effective Frequency Historical Active on Agency CMS Plan Historical Date Removed from Agency CMS Plan Historical CMS Start Date Historical CMS Status Historical Reason for Changing CMS Category Activities: FCE, PCE, Investigations
ACTIVITY PROGRAM: <Program> ACTIVITY SUBPART: <Subpart> ACTIVITY POLLUTANT: <Pollutant> New Case File Case File Identifier Case File Name Enforcement Response Policy Earliest FRV Determination Date Earliest HPV Day Zero Date Status Status Date Sensitive Activity? The Environmental Protection Agency Sensitive Data? No Integrated Compliance Information System Critical Data Element Report PERFORMED BY REGION: <Region> PERFORMED BY STATE: <State> PERFORMED BY LCON: <LCON> ACTIVITY PROGRAM: <Program> ACTIVITY SUBPART: <Subpart> ACTIVITY POLLUTANT: <Pollutant> New Enforcement Actions Enforcement Action Identifier Enforcement Action Name Enforcement Action Type Sensitive Activity? Milestones Enforcement Action Milestone Milestone Actual Date
Comprehensive Compliance Monitoring Strategy (CMS) Report Sources Not Evaluated within Negotiated CMS Frequency Facility ID Facility Name Default Classification CMS Category Date Last FCE CMS Identifier CMS Category CMS Status Reason for Changing CMS CMS Frequency CMS Effective Frequency 1234567890 Facility 4 123ABC, S 80% Synthetic Minor 06/01/2013 CMS ID123 M, Active Added New Info 2 years 2 years CMS Origination Date CMS Start Date CMS Effective Date Next FCE Due Date Active on Agency CMS Plan Date Removed from Agency CMS Plan Current Reason for Changing CMS Category 02/01/2013 03/01/2013 03/01/2013 02/01/2014 Active 07/01/2013 Added New Info Figure B- 3 Sources with No CMS Flag Report The Environmental Protection Agency Sensitive Data? No
FCE, PCE, Investigations Unique Identifier Compliance Monitoring Activity Name Compliance Monitoring Type PCE Type Compliance Monitoring Actual Start Date Compliance Monitoring Actual End Date Compliance Monitoring Action Reason Compliance Monitoring Agency Type Compliance Monitoring Agency Name Air Programs Program Program not on Facility Indicator Program 1 Program 2 Program 3 Program 4 Pollutants Pollutant Pollutant not on Facility Indicator Pollutant 1 Pollutant 2 Pollutant 3 The Environmental Protection Agency Sensitive Data? No Activities Report Stack Tests
ST09987676 08/01/2013 Air Programs Program Program not on Facility Indicator Program 1 Program 2 Program 3 Program 4 Pollutants Pollutant Pollutant not on Facility Indicator Pollutant 1 Pollutant 2 Pollutant 3 Figure B- 7 Facilities Reporting Violations The Environmental Protection Agency Sensitive Data? No Facilities Reporting Violations Facilities Reporting Violations Facility ID FRS ID Facility Name Case File Identifier Case File Name Case File Enforcement Response Policy Case File Earliest FRV Determination Date Date Case File Earliest HPV Day Zero Date Case File Status Case File Status Date 1234567890 1234567890 Facility 4 AVF 987XYZ AVF 3 03/15/2013 Stat 1 08/15/2013
Violation Types Violation Type Violation Enforcement Response Policy Start Date End Date AVF Type 1 AVF TPI 1 02/01/2013 05/30/2013 AVF Type 2 AVF TPI 2 03/15/2013 06/16/2013 AVF Type 3 AVF TPI 3 04/30/2013 08/05/2013 Figure B- 8 List of Active HPVs-FRVs-Non FRVs The Environmental Protection Agency Sensitive Data? No List of Active HPVs-FRVs-Non FRVs List of Active HPVs/FRVs/Non-FRVs Facility ID FRS ID Facility Name Case File Identifier Case File Name Case File Enforcement Response Policy Case File Earliest FRV Determination Date Case File Earliest HPV Day Zero Date 1234567890 1234567890 Facility 4 AVF 987XYZ AVF 3 03/15/2013 03/15/2013 Case File Status Case File Status Date Enforcement Sensitive Indicator Stat 1 08/15/2013 No Violations Violation Type Enforcement Response Policy Program Other Program Text Program not on Facility Indicator Pollutant Pollutant not on Facility Indicator Start Date End Date AVF Type 1 AVF TPI 1 Program 1 Pollutant 1 02/01/2013 05/30/2013 AVF Type 2 AVF TPI 2 Program 2 Pollutant 2 03/15/2013 06/16/2013 AVF Type 3 AVF TPI 3 Program 3 Pollutant 3 04/30/2013 08/05/2013
National Initiatives National Initiatives Nat Init 1 Nat Init 2 Nat Init 3 Pathway Data Discovery Action Type Discovery Action Date Notification Action Type Notification Action Date Addressing Action Type Addressing Action Date Resolving Action Type Resolving Action Date Disc Act Type 1 01/01/2013 Not Act Type 1 01/15/2013 Addr Act Type 1 02/01/2013 Res Act Type 1 02/15/2013 Disc Act Type 2 05/01/2013 Not Act Type 2 06/01/2013 Addr Act Type 2 07/15/2013 Res Act Type 2 08/15/2013 Additional Data Comments User Defined Field 1 User Defined Field 2 User Defined Field 3 User Defined Field 4 User Defined Field 5 User Defined Field 6 Comment 1 Comment 2 Figure B- 9 Notice of Violation Report The Environmental Protection Agency Sensitive Data? No Notice of Violation Report Facilities Reporting Violations Facility ID FRS ID Facility Name Case File Identifier Case File Name Case File Status Case File Enforcement Response Policy Enforcement Sensitive Indicator 1234567890 1234567890 Facility 4 987XYZ AVF 3 Status 1 AVF Policy 1 No