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 else if “STATE” 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 Program_Category_Code AIR_CASE_FILE_PROGRAM Program_Category_Code REF_PROGRAM table 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 REF_POLLUTANT Pollutant_Category_Code Pollutant_Category_Code table Chemical_Fomula Chemical_Fomula REF_POLLUTANT REF_POLLUTANT REF_POLLUTANT User_Flag User_Flag
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
ICIS-Air_Data_Warehouse_Detailed_Design_Document_v1_4.docx