Facility Name Current or FACILITY AIR_FACILITY_DIM Facility_Name_FI historical facility name Facility Acronym for the FACILITY AIR_FACILITY_DIM Program system of record System for the facility Acronym Facility Programmatic FACILITY AIR_FACILITY_DIM Program Facility unique System identifier Identifier FRS Identifier FRS unique FACILITY AIR_FACILITY_DIM Facility_UIN_FRS facility site identifier Facility Current Default facility FACILITY AIR_CLASS_DIM Where Default classification Classification .Current_Flag=Y Facility Current EPA facility Where FACILITY AIR_CLASS_DIM EPA classification Classification .Current_Flag=Y Facility Current Delegated Agency FACILITY AIR_CLASS_DIM Where Delegated facility Agency classification Classification .Current_Flag=Y Facility Current Pollutant(s) FACILITY Pollutant_Desc Where Pollutants associated with the facility Facility Current Program(s) FACILITY Program_Desc Where Air Programs associated with the facility Facility Current Subparts FACILITY Where Subparts associated with the facility Facility Current FACILITY Where Most “active” Operating current operating Status status of the programs facility’s Facility Reporting FACILITY Universe universe(s) associated with the facility Activity Input Prompts Activity Region performing FACILITY Region_Code Includes HQ, 01-10 Performed By the activity (if an Region EPA activity) Activity State performing FACILITY State_Code Performed By the activity (if a State State activity) Activity LCON performing FACILITY Air_LCON_Desc Performed By the activity (if an LCON LCON activity)
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
ICIS-Air_Data_Warehouse_Detailed_Design_Document_v1_4.docx