ICIS_COMP_DET_PATHWAY Updated_Date AIR_CASE_FILE_PATHWAY Updated_Date Pathway_Category_Desc AIR_CASE_FILE_PATHWAY Pathway_Category_Desc Copy after looking up in Sort_Order AIR_CASE_FILE_PATHWAY Sort_Order Pathway_Type_Code AIR_CASE_FILE_PATHWAY Pathway_Type_Code Create a new row in for each row in that has this Pathway_Type_Code. REF_PATHWAY_TYPE Pathway_Type_Desc AIR_CASE_FILE_PATHWAY Pathway_Type_Desc Copy after looking up Pathway_Type_Code in table For the next several columns, ETL must determine if this is a or If “linked” “manual” pathway. the Manual_Pathway_Type_Code from ICIS_COMP_DET_PATHWAY IS NULL, then this must be a pathway, otherwise, it is “linked” “manual”. ICIS_COMP_DET_PATHWAY Activity_ID AIR_CASE_FILE_PATHWAY Pathway_Activity_ID Copy the Activity_ID if from IS NULL, else leave this as NULL. ICIS_COMP_DET_PATHWAY Linked_Pathway_Date AIR_CASE_FILE_PATHWAY Pathway_Activity_Date Copy the or Manual_Pathway_Date if from IS NULL, else copy the Activity_Type_Code Pathway_Activity_Type_Code Copy the ICIS_ACTIVITY AIR_CASE_FILE_PATHWAY or or ICIS_COMP_DET_PATHWAY Manual_Pathway_Type_Code if from IS NULL, else copy the Activity_Type_Code from ICIS_ACTIVITY (use Activity_ID for Activity_Type_Desc Pathway_Activity_Type_Desc If the REF_ACTIVITY_TYPE AIR_CASE_FILE_PATHWAY or or REF_PATHWAY_TYPE Pathway_Type_Desc from IS NULL, then copy the Pathway_Type_Desc from after looking up the (i.e. Pathway_Type_Code), else copy the Activity_Type_Desc from after looking up
ICIS_COMP_DET_PATHWAY Updated_Date AIR_CASE_FILE_PATHWAY Updated_Date Pathway_Category_Desc AIR_CASE_FILE_PATHWAY Pathway_Category_Desc Copy after looking up in Sort_Order AIR_CASE_FILE_PATHWAY Sort_Order Pathway_Type_Code AIR_CASE_FILE_PATHWAY Pathway_Type_Code Create a new row in for each row in that has this Pathway_Type_Code. REF_PATHWAY_TYPE Pathway_Type_Desc AIR_CASE_FILE_PATHWAY Pathway_Type_Desc Copy after looking up Pathway_Type_Code in table For the next several columns, ETL must determine if this is a “linked” or “manual” pathway. If the Manual_Pathway_Type_Code from ICIS_COMP_DET_PATHWAY IS NULL, then this must be a “linked” pathway, otherwise, it is “manual”. ICIS_COMP_DET_PATHWAY Activity_ID AIR_CASE_FILE_PATHWAY Pathway_Activity_ID Copy the Activity_ID if from IS NULL, else leave this as NULL. ICIS_COMP_DET_PATHWAY Linked_Pathway_Date or Manual_Pathway_Date AIR_CASE_FILE_PATHWAY Pathway_Activity_Date Copy the if from IS NULL, else copy the ICIS_ACTIVITY or ICIS_COMP_DET_PATHWAY Activity_Type_Code or Manual_Pathway_Type_Code AIR_CASE_FILE_PATHWAY Pathway_Activity_Type_Code Copy the if from IS NULL, else copy the Activity_Type_Code from ICIS_ACTIVITY (use Activity_ID for REF_ACTIVITY_TYPE or REF_PATHWAY_TYPE Activity_Type_Desc or Pathway_Type_Desc AIR_CASE_FILE_PATHWAY Pathway_Activity_Type_Desc If the from IS NULL, then copy the Pathway_Type_Desc from after looking up the (i.e. Pathway_Type_Code), else copy the Activity_Type_Desc from after looking up