Calculated records FRV_Status Flags the facility based on the Unaddressed HPV are Warehouse status of its non-resolved those with blank “worst” HPV case files: Addressing and Unaddressed HPV Resolving milestones Addressed HPV Blank Addressed HPV are those with populated The worst compliance Addressing milestones determination is: but blank Resolving Highest on the status milestones hierarchy: Addressed Blank is all CSs are Unaddressed resolved or no CFs exist If more than one with the for facility same status, the CF with the HPV Day latest ”Earliest date Zero” If more than one with the same Earliest HPV Day Zero date, the one with the largest activity ID Facility classification History of the Includes Begin and End Warehouse facility’s history classification as derived from its Date; EPA, DA, Default pollutant records status codes and descriptions Facility operating History of the operating Includes Begin and End Warehouse facility’s status history status as derived from its Date; Program codes and program records descriptions, Sub Part Codes and descriptions Other Air facility flag Indicates whether the facility is AIR_FACILITY_DIM If facility interest pgm Universe an air facility or not (Y/N) sys acrnm = AIR, set to Yes, else No Facility on a CMS Indicates whether the facility AIR_FACILITY_DIM If any records in Warehouse plan currently has an active CMS air_cms_dim have plan record. Needed because the CMS removal date null or in record itself is sensitive, but the the future, set to Yes, fact that a record is on a CMS else No plan is not sensitive. Primary NAICS Indicates the primary NAICS AIR_FACILITY_DIM Warehouse Code code Primary NAICS Desc Indicates the primary NAICS AIR_FACILITY_DIM Warehouse description Primary SIC Code Indicates the primary SIC code AIR_FACILITY_DIM Primary_SIC_Code_FI Warehouse Primary SIC Desc Indicates the primary SIC AIR_FACILITY_DIM Primary_SIC_Desc_FI Warehouse description Facility Ownership Indicates whether the Air facility AIR_FACILITY_DIM Warehouse is by a State or an “owned” LCON If the pgm_sys_acrnm = AIR: If lcon_code is not null, then LCON ELSE State
Calculated records FRV_Status Flags the facility based on the “worst” status of its non-resolved HPV case files: Unaddressed HPV Addressed HPV Blank The worst compliance determination is: Highest on the status hierarchy: Addressed Unaddressed If more than one with the same status, the CF with the latest ”Earliest HPV Day Zero” date If more than one with the same Earliest HPV Day Zero date, the one with the largest activity ID Unaddressed HPV are those with blank Addressing and Resolving milestones Addressed HPV are those with populated Addressing milestones but blank Resolving milestones Blank is all CSs are resolved or no CFs exist for facility Warehouse Facility classification history History of the facility’s classification as derived from its pollutant records Includes Begin and End Date; EPA, DA, Default status codes and descriptions Warehouse Facility operating status history History of the facility’s operating status as derived from its program records Includes Begin and End Date; Program codes and descriptions, Sub Part Codes and descriptions Warehouse Other Air facility flag Indicates whether the facility is an air facility or not (Y/N) AIR_FACILITY_DIM If facility interest pgm sys acrnm = AIR, set to Yes, else No Universe Facility on a CMS plan Indicates whether the facility currently has an active CMS record. Needed because the CMS record itself is sensitive, but the fact that a record is on a CMS plan is not sensitive. AIR_FACILITY_DIM If any records in air_cms_dim have plan removal date null or in the future, set to Yes, else No Warehouse Primary NAICS Code Indicates the primary NAICS code AIR_FACILITY_DIM Warehouse Primary NAICS Desc Indicates the primary NAICS description AIR_FACILITY_DIM Warehouse Primary SIC Code Indicates the primary SIC code AIR_FACILITY_DIM Primary_SIC_Code_FI Warehouse Primary SIC Desc Indicates the primary SIC description AIR_FACILITY_DIM Primary_SIC_Desc_FI Warehouse Facility Ownership Indicates whether the Air facility is “owned” by a State or an LCON AIR_FACILITY_DIM If the pgm_sys_acrnm = AIR: If lcon_code is not null, then LCON ELSE State Warehouse