Law_Section_Code Law_Section_Code Rank_Order Rank_Order Law_Section_Desc Law_Section_Desc REF_LAW_SECTION 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 AIR_CASE_FILE_DIM State_EPA_Flag State_EPA_Flag in this table matching on AIR_CASE_FILE_DIM Sensitive_Data_Flag Sensitive_Data_Flag Air_Case_File_Key. Region_Code Region_Code AIR_CASE_FILE_DIM 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
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
ICIS-Air_Data_Warehouse_Detailed_Design_Document_v1_4.docx