Target Column,Source Table,,,
stage,Derived in query (no direct source),,,
staging_reason,Derived in query (no direct source),,,
lgd,Derived in query (no direct source),,,
effective_stage,Derived in query (no direct source),,,
effective_staging_date,Derived in query (no direct source),,,
effective_staging_reason,Derived in query (no direct source),,,
ecl_1y,Derived in query (no direct source),,,
ecl_maturity,Derived in query (no direct source),,,
lossallowance,Derived in query (no direct source),,,
ead,Derived in query (no direct source),,,
limit_in_base_currency,Hardcoded ,,,
facility_rating_at_origination,ifrs9.ab_ratings_all_countries_temp.rating_at_origin,"ifrs9.ab_ratings_all_countries_temp.gfpf_ab_rating ",ifrs9.customers_rating_eom.default_risk_rating,"RDV_EOM.CUSTOMERS_EOM.GFPF_P3_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_P1_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_C1_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_C5_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_C4_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_C5_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_C5_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_C3_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_P4_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_C5_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_P4_RTNG
RDV_EOM.CUSTOMERS_EOM.GFPF_P4_RTNG"
collateral_cover,ifrs9.collaterals_final.facility_collateral_cover,ifrs9.collaterals_final_v.facility_collateral_cover,"IFRS9.COLLATERALS_HAIRCUT.HAIRCUT
IFRS9.DIM_COLLATERAL_ITEMS.COLLATERAL_VALUE_USD
IFRS9.DEALS_V.BALANCE_AMNT_USD
IFRS9.DEALS_V.DUE_BALANCE_AMNT_USD
IFRS9.DEALS_V.DUE_INTEREST_AMNT_USD
IFRS9.DEALS_V.LATE_PMT_INTEREST_AMNT_USD
IFRS9.DEALS_V.PENALTY_INTEREST_AMNT_USD
RAW_DATA_VAULT.EXIMBILLS_IMISPME_DAILY.IMIS000057
RAW_DATA_VAULT.EXIMBILLS_IMISPME_DAILY.IMIS000683
RAW_DATA_VAULT.EXIMBILLS_IMISPME_DAILY.IMIS000711
RAW_DATA_VAULT.EXIMBILLS_GTSPPME_DAILY.GTSP000071
RAW_DATA_VAULT.EXIMBILLS_GTAMPME_DAILY.GTAM000071
RAW_DATA_VAULT.CURRENCY_HIST.C8PF_SPT_RAT_BS_CCY",
total_collateral_cover__usd_,ifrs9.collaterals_final.total_collateral,ifrs9.collaterals_final_v.facility_collateral_cover,"ifrs9.collaterals_final_v.failability_balance_usd IFRS9.DIM_COLLATERAL_ITEMS.COLLATERAL_VALUE_USD, IFRS9.COLLATERALS_HAIRCUT.HAIRCUT • IFRS9.DEALS_V.BALANCE_AMNT_USD
• IFRS9.DEALS_V.DUE_BALANCE_AMNT_USD
• IFRS9.DEALS_V.DUE_INTEREST_AMNT_USD
• IFRS9.DEALS_V.PENALTY_INTEREST_AMNT_USD
• IFRS9.DEALS_V.LATE_PMT_INTEREST_AMNT_USD
• RAW_DATA_VAULT.EXIMBILLS_*.MRGN_BAL_USD",
cash_collaterals,ifrs9.collaterals_final.cash_collateral,,,
other_collaterals,ifrs9.collaterals_final.other_collateral,,,
moody_s_rating,ifrs9.current_external_rating.moodys,raw_data_vault.historical_bank_ratings.moody,,
s_p_s_rating,ifrs9.current_external_rating.SP,raw_data_vault.historical_bank_ratings.sp,,
fitch_s_rating,ifrs9.current_external_rating.fitch,raw_data_vault.historical_bank_ratings.fitch,,
source_system,ifrs9.deals_funded_unfunded_report_all_lg.ab_sourcesystem,,,
facility_id,ifrs9.deals_funded_unfunded_report_all_lg.facility_id,,,
customer_id,ifrs9.deals_funded_unfunded_report_all_lg.customer_id,,,
branch,ifrs9.deals_funded_unfunded_report_all_lg.branch,,,
basic,ifrs9.deals_funded_unfunded_report_all_lg.basic,,,
suffix,ifrs9.deals_funded_unfunded_report_all_lg.sfx,,,
customer_group_name,ifrs9.deals_funded_unfunded_report_all_lg.customer_group_name,,,
customer_name_arabic,ifrs9.deals_funded_unfunded_report_all_lg.customer_name_arabic,,,
customer_name_english,ifrs9.deals_funded_unfunded_report_all_lg.full_name_in_english,,,
customer_segment,ifrs9.deals_funded_unfunded_report_all_lg.customer_segment,,,
industry_code,ifrs9.deals_funded_unfunded_report_all_lg.industry_code,,,
industry_description,ifrs9.deals_funded_unfunded_report_all_lg.industry_description,,,
ab_default_rating,ifrs9.deals_funded_unfunded_report_all_lg.AB_default_rating,,,
customer_delinquency_status,ifrs9.deals_funded_unfunded_report_all_lg.customer_delinquency_status,,,
classification,ifrs9.deals_funded_unfunded_report_all_lg.customer_classification,,,
classification_desc,ifrs9.deals_funded_unfunded_report_all_lg.classification_desc,,,
facility_reference,ifrs9.deals_funded_unfunded_report_all_lg.facility_ref,,,
product_segment,ifrs9.deals_funded_unfunded_report_all_lg.product_segment,,,
facility_product_type,ifrs9.deals_funded_unfunded_report_all_lg.product_type,,,
facility_start_date,ifrs9.deals_funded_unfunded_report_all_lg.facility_start_date,,,
facility_maturity_date,ifrs9.deals_funded_unfunded_report_all_lg.facility_maturity_date,,,
facility_currency,ifrs9.deals_funded_unfunded_report_all_lg.currency_code,,,
outstanding_balance_usd,ifrs9.deals_funded_unfunded_report_all_lg.outstanding_balance_usd,,,
outstanding_balance_original_curreny,ifrs9.deals_funded_unfunded_report_all_lg.outstanding_balance_original_ccy,,,
outstanding_balance_base_currency,ifrs9.deals_funded_unfunded_report_all_lg.outstanding_balance_base_ccy,,,
principal_repayment_frequency,ifrs9.deals_funded_unfunded_report_all_lg.principal_repayment_frequency,,,
amortization_type,ifrs9.deals_funded_unfunded_report_all_lg.amortization_type,,,
interest_frequency,ifrs9.deals_funded_unfunded_report_all_lg.interest_frequency,,,
facility_rating_at_reporting_date,ifrs9.deals_funded_unfunded_report_all_lg.rating_at_reporting_date,,,
facility_dpd,ifrs9.deals_funded_unfunded_report_all_lg.facility_dpd,,,
limit_category,ifrs9.deals_funded_unfunded_report_all_lg.limit_category,,,
cash_margin,ifrs9.deals_funded_unfunded_report_all_lg.cash_margin,,,
coa_item,ifrs9.deals_funded_unfunded_report_all_lg.coa_item,,,
funded_unfunded_flag,ifrs9.deals_funded_unfunded_report_all_lg.funded_unfunded,,,
bank,ifrs9.deals_funded_unfunded_report_all_lg.bank_swift_code,,,
load_date,ifrs9.deals_funded_unfunded_report_all_lg.load_date,,,
load_country,ifrs9.deals_funded_unfunded_report_all_lg.Load_Country,,,
country_of_risk,ifrs9.ifrs9_customer_info.country_of_risk,,,
interest_rate_type,IFRS9.interest_rate_v.interestratetype,,,
interest_rate_spread,IFRS9.interest_rate_v.INTEREST_RATE_SPREAD,,,
base_rate,IFRS9.interest_rate_v.BASE_RATE,,,
applied_interest_rate,IFRS9.interest_rate_v.applied_interest_rate,,,
interest_rate_for_discounted_bills,IFRS9.interestreceivedinadvanced_v.int_rate_discounted_bills,,,
mra_rating,ifrs9.mra_data.mra_rating,,,
mra_pd,ifrs9.mra_data.mra_pd,,,
ttc_pd,ifrs9.mra_data.mra_pd,,,
previous_effective_stage_reason,ifrs9.previous_stage_details.previous_stage_reason,,,
previous_effective_stage_date,ifrs9.previous_stage_details.previous_stage_date,,,
previous_effective_stage,ifrs9.previous_stage_details.prev_effective_stage,,,
restructured_flag,ifrs9.rescheduling_restructuring_v.restructured_flag,,,
rescheduled_flag,ifrs9.rescheduling_restructuring_v.Rescheduled_flag,,,
,,,,
m_IFRS9_OLD_RATE_FUNDED_UNFUNDED_new,,,,
,,,,
Target Column,Source Columns (schema.table.column),,,
amortization_type,"derived from Amortization_Type_NEW, deal_type, and interest_rate_v.amortizationtype",,,
total_collateral_cover__usd_,derived from cash_collateral + other_collateral,,,
facility_rating_at_reporting_date,derived from external_rating.external_rating,,,
facility_rating_at_origination,derived from external_rating_origin.EXTERNAL_RATINGS_ORIGIN,,,
product_segment,derived from ifrs9.deals_funded_unfunded_report.product_name and customer_segment,,,
facility_product_type,derived from ifrs9.deals_funded_unfunded_report.product_name and ifrs9.deal_types_desc_v.field_value_description,,,
interest_frequency,derived from interest_rate_v.interestperiodicity_desc,,,
principal_repayment_frequency,"derived from multiple columns including payment_frequency_description, Amortization_Type, and interest_rate_v.interestperiodicity_desc",,,
staging_reason,derived from multiple conditions,,,
effective_stage,derived from multiple conditions,,,
effective_staging_date,derived from multiple conditions,,,
effective_staging_reason,derived from multiple conditions,,,
stage,"derived from multiple conditions on AB_default_rating, customer_delinquency_status, etc.",,,
applied_interest_rate,derived from multiple interest rate sources,,,
ead,derived from outstanding_balance_usd,,,
outstanding_balance_base_currency,derived from outstanding_balance_usd or outstanding_balance_lcl,,,
funded_unfunded_flag,derived from type column in deals_funded_unfunded_report,,,
ecl_1y,derived or hardcoded,,,
ecl_maturity,derived or hardcoded,,,
lossallowance,derived or hardcoded,,,
limit_in_base_currency,hardcoded 'TBD',,,
lgd,hardcoded 'TBD',,,
cash_collaterals,ifrs9.collaterals_final.cash_collateral,,,
collateral_cover,ifrs9.collaterals_final.FACILITY_COLLATERAL_COVER,,,
other_collaterals,ifrs9.collaterals_final.other_collateral,,,
ab_default_rating,ifrs9.deals_funded_unfunded_report.AB_default_rating,,,
branch,ifrs9.deals_funded_unfunded_report.account_branch_number_new,,,
suffix,ifrs9.deals_funded_unfunded_report.account_suffix_new,,,
facility_reference,ifrs9.deals_funded_unfunded_report.agreement_reference_id,,,
bank,ifrs9.deals_funded_unfunded_report.bank_new_code,,,
coa_item,ifrs9.deals_funded_unfunded_report.chart_of_account_key,,,
classification_desc,ifrs9.deals_funded_unfunded_report.classification_desc_new,,,
country_of_risk,ifrs9.deals_funded_unfunded_report.country_of_risk,,,
facility_currency,ifrs9.deals_funded_unfunded_report.currency_code,,,
classification,ifrs9.deals_funded_unfunded_report.customer_classification_new,,,
customer_delinquency_status,ifrs9.deals_funded_unfunded_report.customer_delinquency_status_new,,,
customer_group_name,ifrs9.deals_funded_unfunded_report.customer_group_name,,,
customer_id,ifrs9.deals_funded_unfunded_report.customer_id_new,,,
customer_segment,ifrs9.deals_funded_unfunded_report.customer_segment,,,
source_system,ifrs9.deals_funded_unfunded_report.deal_type,,,
industry_code,ifrs9.deals_funded_unfunded_report.economic_sector,,,
industry_description,ifrs9.deals_funded_unfunded_report.economic_sector_description,,,
basic,ifrs9.deals_funded_unfunded_report.external_account_number_new,,,
facility_dpd,ifrs9.deals_funded_unfunded_report.facility_dpd,,,
facility_id,ifrs9.deals_funded_unfunded_report.facility_ref,,,
customer_name_arabic,ifrs9.deals_funded_unfunded_report.full_name_in_arabic,,,
customer_name_english,ifrs9.deals_funded_unfunded_report.full_name_in_english,,,
limit_category,ifrs9.deals_funded_unfunded_report.limit_category_new,,,
load_country,ifrs9.deals_funded_unfunded_report.load_country,,,
load_date,ifrs9.deals_funded_unfunded_report.load_date,,,
facility_maturity_date,ifrs9.deals_funded_unfunded_report.maturity_full_date,,,
outstanding_balance_original_curreny,ifrs9.deals_funded_unfunded_report.outstanding_balance,,,
outstanding_balance_usd,ifrs9.deals_funded_unfunded_report.outstanding_balance_usd,,,
facility_start_date,ifrs9.deals_funded_unfunded_report.start_full_date,,,
fitch_s_rating,ifrs9.external_ratings.fitch or ifrs9.current_external_rating.fitch,,,
moody_s_rating,ifrs9.external_ratings.moody or ifrs9.current_external_rating.moody,,,
s_p_s_rating,ifrs9.external_ratings.sp or ifrs9.current_external_rating.sp,,,
interest_rate_spread,ifrs9.interest_rate_v.clientratespread or MAX_FIXEDRATE,,,
base_rate,ifrs9.interest_rate_v.FIXINGATBSD,,,
interest_rate_type,ifrs9.interest_rate_v.interestratetype,,,
interest_rate_for_discounted_bills,ifrs9.interestreceivedinadvanced_v.interest_rate,,,
mra_rating,ifrs9.mra_data.mra,,,
mra_pd,ifrs9.mra_data.system_pd,,,
ttc_pd,ifrs9.mra_data.system_pd,,,
previous_effective_stage,ifrs9.previous_stage_details.effective_stage,,,
previous_effective_stage_date,ifrs9.previous_stage_details.previous_stage_2_date,,,
previous_effective_stage_reason,ifrs9.previous_stage_details.previous_stage_2_reason,,,
restructured_flag,ifrs9.rescheduling_restructuring_v.FLAG,,,
rescheduled_flag,ifrs9.rescheduling_restructuring_v.FLAG,,,
cash_margin,ifrs9.UNFUNDED_CASH_MARGIN.mrgn_bal_usd,,,
,,,,
m_Unused_Limit_unfunded,,,,
Target Column,Source Columns (schema.table.column),,,
load_date,derived from ${PRCESS_DTE},,,
classification_desc,derived from classification using CASE logic,,,
facility_start_date,"derived from FACILITY_START_DATE or calculated using ADD_MONTHS(LAST_DAY(${PRCESS_DTE}), -12)",,,
limit_in_base_currency,derived from FCLTY_LMT_USD or FCLTY_LMT_LCL,,,
stage,"derived from multiple conditions on default_risk_rating, customer_delinquency_status, FLAG, gfpf_ab_rating, etc.",,,
ead,derived from OUTSNDING_BLNC_USD,,,
effective_staging_date,"derived from PARTITION_LOAD_DATE, PREVIOUS_STAGE_2_DATE_, etc.",,,
staging_reason,"derived from stage, coa_item, default_risk_rating, etc.",,,
effective_stage,"derived from stage, staging_reason, PREVIOUS_STAGE_2_, etc.",,,
effective_staging_reason,"derived from staging_reason, PREVIOUS_STAGE_2_REASON_, etc.",,,
interest_rate_spread,hardcoded '',,,
base_rate,hardcoded '',,,
interest_rate_for_discounted_bills,hardcoded '',,,
interest_frequency,hardcoded 0,,,
collateral_cover,hardcoded 0,,,
total_collateral_cover__usd_,hardcoded 0,,,
cash_collaterals,hardcoded 0,,,
other_collaterals,hardcoded 0,,,
principal_repayment_frequency,hardcoded '0',,,
amortization_type,hardcoded 'Bullet',,,
product_segment,hardcoded 'Corporate',,,
interest_rate_type,hardcoded 'Fixed',,,
funded_unfunded_flag,hardcoded 'Unfunded',,,
source_system,hardcoded 'Unused Limits',,,
cash_margin,ifrs9.committed_unutilized_v.CASH_MARGIN_USD,,,
classification,ifrs9.committed_unutilized_v.CLASSIFICATION,,,
coa_item,ifrs9.committed_unutilized_v.COA_ITEM,,,
applied_interest_rate,ifrs9.committed_unutilized_v.EFFECTIVE_INTEREST_RATE,,,
facility_currency,ifrs9.committed_unutilized_v.FACILITY_CURRENCY,,,
facility_dpd,ifrs9.committed_unutilized_v.FACILITY_DPD,,,
facility_maturity_date,ifrs9.committed_unutilized_v.FACILITY_MATURITY_DATE,,,
facility_product_type,ifrs9.committed_unutilized_v.FACILITY_TYPE,,,
limit_category,ifrs9.committed_unutilized_v.IMIT_CATEGORY,,,
facility_id,ifrs9.committed_unutilized_v.LCPF_CMTMNT_REF,,,
facility_reference,ifrs9.committed_unutilized_v.LCPF_CMTMNT_REF,,,
customer_id,ifrs9.committed_unutilized_v.LCPF_CSTMR_MNMNC,,,
basic,ifrs9.committed_unutilized_v.LCPF_CSTMR_MNMNC,,,
load_country,ifrs9.committed_unutilized_v.LCPF_LOAD_COUNTRY,,,
outstanding_balance_base_currency,ifrs9.committed_unutilized_v.OUTSNDING_BLNC_LCL_CCY,,,
outstanding_balance_original_curreny,ifrs9.committed_unutilized_v.OUTSNDING_BLNC_ORG_CCY,,,
outstanding_balance_usd,ifrs9.committed_unutilized_v.OUTSNDING_BLNC_USD,,,
suffix,ifrs9.committed_unutilized_v.SUFFIX,,,
customer_group_name,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.customer_group_name,,,
customer_segment,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.customer_segmant,,,
facility_rating_at_reporting_date,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.default_risk_rating,,,
industry_code,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.ECONOMIC_SECTOR,,,
customer_name_arabic,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.full_name,,,
customer_name_english,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.full_name_en,,,
industry_description,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.industry_sector,,,
country_of_risk,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.risk_country,,,
customer_delinquency_status,ifrs9.ifrs9_monthly_run_data.customer_delinquency_status,,,
mra_rating,IFRS9.MRA_DATA.mra,,,
mra_pd,IFRS9.MRA_DATA.system_pd,,,
ttc_pd,IFRS9.MRA_DATA.system_pd,,,
previous_effective_stage,ifrs9.previous_stage_details.effective_stage,,,
previous_effective_stage_date,ifrs9.previous_stage_details.previous_stage_2_date,,,
previous_effective_stage_reason,ifrs9.previous_stage_details.previous_stage_2_reason,,,
restructured_flag,IFRS9.rescheduling_restructuring_v.FLAG,,,
rescheduled_flag,IFRS9.rescheduling_restructuring_v.FLAG,,,
ab_default_rating,ifrs9.rtng_orign_cmtd_unutlzd_temp.gfpf_ab_rating,,,
facility_rating_at_origination,ifrs9.rtng_orign_cmtd_unutlzd_temp.gfpf_ab_rating,,,
ecl_1y,not defined (likely derived or hardcoded),,,
ecl_maturity,not defined (likely derived or hardcoded),,,
lossallowance,not defined (likely derived or hardcoded),,,
lgd,not defined (likely hardcoded or derived elsewhere),,,
moody_s_rating,not defined in this logic,,,
s_p_s_rating,not defined in this logic,,,
fitch_s_rating,not defined in this logic,,,
branch,RAW_DATA_VAULT.BRANCHES.CAPF_BRNCH_NUMBER,,,
bank,RAW_DATA_VAULT.BRANCHES.CAPF_BRNCH_NUMBER,,,
,,,,
,,,,
IFRS9_OLD_RATE_FUNDED_UNFUNDED_EG_NEW,,,,
,,,,
Target Column,Source Columns (schema.table.column),,,
source_system,derived from ifrs9.deals_funded_unfunded_report.deal_type,,,
facility_id,ifrs9.deals_funded_unfunded_report.facility_ref,,,
customer_id,ifrs9.deals_funded_unfunded_report.customer_id_new,,,
branch,ifrs9.deals_funded_unfunded_report.account_branch_number_new,,,
basic,ifrs9.deals_funded_unfunded_report.external_account_number_new,,,
suffix,ifrs9.deals_funded_unfunded_report.account_suffix_new,,,
customer_group_name,ifrs9.deals_funded_unfunded_report.customer_group_name,,,
customer_name_arabic,ifrs9.deals_funded_unfunded_report.full_name_in_arabic,,,
customer_name_english,ifrs9.deals_funded_unfunded_report.full_name_in_english,,,
customer_segment,ifrs9.deals_funded_unfunded_report.customer_segment,,,
industry_code,ifrs9.deals_funded_unfunded_report.economic_sector,,,
industry_description,ifrs9.deals_funded_unfunded_report.economic_sector_description,,,
country_of_risk,ifrs9.ifrs9_customer_info.risk_country,,,
ab_default_rating,derived from ifrs9.external_ratings.external_rating or ifrs9.current_external_rating.abre,,,
mra_rating,ifrs9.mra_data.mra,,,
mra_pd,ifrs9.mra_data.system_pd,,,
restructured_flag,ifrs9.rescheduling_restructuring_v.FLAG,,,
rescheduled_flag,ifrs9.rescheduling_restructuring_v.FLAG,,,
customer_delinquency_status,derived from ifrs9.deals_funded_unfunded_report.customer_delinquency_status,,,
classification,ifrs9.deals_funded_unfunded_report.customer_classification,,,
classification_desc,derived from classification using CASE logic,,,
facility_reference,ifrs9.deals_funded_unfunded_report.agreement_reference_id,,,
product_segment,derived from product_name and customer_segment,,,
facility_product_type,derived from product_name and ifrs9.deal_types_desc_v.field_value_description,,,
facility_start_date,ifrs9.deals_funded_unfunded_report.start_full_date,,,
facility_maturity_date,ifrs9.deals_funded_unfunded_report.maturity_full_date,,,
facility_currency,ifrs9.deals_funded_unfunded_report.currency_code,,,
outstanding_balance_usd,ifrs9.deals_funded_unfunded_report.outstanding_balance_usd,,,
outstanding_balance_original_curreny,ifrs9.deals_funded_unfunded_report.outstanding_balance,,,
outstanding_balance_base_currency,derived from outstanding_balance_usd or outstanding_balance_lcl,,,
limit_in_base_currency,hardcoded 'TBD',,,
principal_repayment_frequency,"derived from payment_frequency_description, Amortization_Type, and interest_rate_v.interestperiodicity_desc",,,
amortization_type,"derived from Amortization_Type_NEW, deal_type, and interest_rate_v.amortizationtype",,,
interest_rate_type,ifrs9.interest_rate_v.interestratetype,,,
interest_rate_spread,ifrs9.interest_rate_v.clientratespread or MAX_FIXEDRATE,,,
base_rate,ifrs9.interest_rate_v.FIXINGATBSD,,,
interest_rate_for_discounted_bills,ifrs9.interestreceivedinadvanced_v.interest_rate,,,
applied_interest_rate,derived from multiple interest rate sources,,,
interest_frequency,derived from interest_rate_v.interestperiodicity_desc,,,
facility_rating_at_origination,ifrs9.external_ratings.EXTERNAL_RATINGS_ORIGIN,,,
facility_rating_at_reporting_date,ifrs9.external_ratings.external_rating,,,
facility_dpd,ifrs9.deals_funded_unfunded_report.facility_dpd,,,
limit_category,ifrs9.deals_funded_unfunded_report.limit_category_new,,,
collateral_cover,ifrs9.collaterals_final.FACILITY_COLLATERAL_COVER,,,
cash_margin,ifrs9.UNFUNDED_CASH_MARGIN.mrgn_bal_usd,,,
total_collateral_cover__usd_,derived from cash_collateral + other_collateral,,,
coa_item,ifrs9.deals_funded_unfunded_report.chart_of_account_key,,,
stage,"derived from multiple conditions on AB_default_rating, customer_delinquency_status, etc.",,,
staging_reason,derived from multiple conditions,,,
lgd,hardcoded 'TBD',,,
moody_s_rating,ifrs9.external_ratings.moody or ifrs9.current_external_rating.moody,,,
s_p_s_rating,ifrs9.external_ratings.sp or ifrs9.current_external_rating.sp,,,
fitch_s_rating,ifrs9.external_ratings.fitch or ifrs9.current_external_rating.fitch,,,
previous_effective_stage_reason,ifrs9.previous_stage_details.previous_stage_2_reason,,,
previous_effective_stage_date,ifrs9.previous_stage_details.previous_stage_2_date,,,
previous_effective_stage,ifrs9.previous_stage_details.effective_stage,,,
effective_stage,"derived from stage, staging_reason, PREVIOUS_STAGE_2_, etc.",,,
effective_staging_date,"derived from load_date, PREVIOUS_STAGE_2_DATE_, etc.",,,
effective_staging_reason,"derived from staging_reason, PREVIOUS_STAGE_2_REASON_, etc.",,,
funded_unfunded_flag,derived from type column in deals_funded_unfunded_report,,,
ttc_pd,ifrs9.mra_data.system_pd,,,
ecl_1y,not defined (likely derived or hardcoded),,,
ecl_maturity,not defined (likely derived or hardcoded),,,
lossallowance,not defined (likely derived or hardcoded),,,
cash_collaterals,ifrs9.collaterals_final.cash_collateral,,,
other_collaterals,ifrs9.collaterals_final.other_collateral,,,
ead,derived from outstanding_balance_usd,,,
bank,ifrs9.deals_funded_unfunded_report.bank_new_code,,,
load_date,ifrs9.deals_funded_unfunded_report.load_date,,,
load_country,ifrs9.deals_funded_unfunded_report.load_country,,,
,,,,
m_Unused_Limit_unfunded_EG,,,,
,,,,
Target Column,Source Columns (schema.table.column),,,
source_system,hardcoded 'Unused Limits',,,
facility_id,ifrs9.committed_unutilized_v.LCPF_CMTMNT_REF,,,
customer_id,ifrs9.committed_unutilized_v.LCPF_CSTMR_MNMNC,,,
branch,RAW_DATA_VAULT.BRANCHES.CAPF_BRNCH_NUMBER,,,
basic,ifrs9.committed_unutilized_v.LCPF_CSTMR_MNMNC,,,
suffix,ifrs9.committed_unutilized_v.SUFFIX,,,
customer_group_name,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.customer_group_name,,,
customer_name_arabic,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.full_name,,,
customer_name_english,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.full_name_en,,,
customer_segment,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.customer_segmant,,,
industry_code,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.ECONOMIC_SECTOR,,,
industry_description,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.industry_sector,,,
country_of_risk,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.risk_country,,,
ab_default_rating,ifrs9.rtng_orign_cmtd_unutlzd_temp.gfpf_ab_rating,,,
mra_rating,IFRS9.MRA_DATA.mra,,,
mra_pd,IFRS9.MRA_DATA.system_pd,,,
restructured_flag,IFRS9.rescheduling_restructuring_v.FLAG,,,
rescheduled_flag,IFRS9.rescheduling_restructuring_v.FLAG,,,
customer_delinquency_status,ifrs9.ifrs9_monthly_run_data.customer_delinquency_status,,,
classification,ifrs9.committed_unutilized_v.CLASSIFICATION,,,
classification_desc,derived from classification using CASE logic,,,
facility_reference,ifrs9.committed_unutilized_v.LCPF_CMTMNT_REF,,,
product_segment,hardcoded 'Corporate',,,
facility_product_type,derived from RAW_DATA_VAULT.additional_account_info.b0pf_bsc,,,
facility_start_date,"derived from FACILITY_START_DATE or calculated using ADD_MONTHS(LAST_DAY(${PRCESS_DTE}), -12)",,,
facility_maturity_date,ifrs9.committed_unutilized_v.FACILITY_MATURITY_DATE,,,
facility_currency,ifrs9.committed_unutilized_v.FACILITY_CURRENCY,,,
outstanding_balance_usd,ifrs9.committed_unutilized_v.OUTSNDING_BLNC_USD,,,
outstanding_balance_original_curreny,ifrs9.committed_unutilized_v.OUTSNDING_BLNC_ORG_CCY,,,
outstanding_balance_base_currency,ifrs9.committed_unutilized_v.OUTSNDING_BLNC_LCL_CCY,,,
limit_in_base_currency,derived from FCLTY_LMT_USD or FCLTY_LMT_LCL,,,
principal_repayment_frequency,hardcoded '0',,,
amortization_type,hardcoded 'Bullet',,,
interest_rate_type,hardcoded 'Fixed',,,
interest_rate_spread,hardcoded '',,,
base_rate,hardcoded '',,,
interest_rate_for_discounted_bills,hardcoded '',,,
applied_interest_rate,ifrs9.committed_unutilized_v.EFFECTIVE_INTEREST_RATE,,,
interest_frequency,hardcoded 0,,,
facility_rating_at_origination,ifrs9.rtng_orign_cmtd_unutlzd_temp.gfpf_ab_rating,,,
facility_rating_at_reporting_date,IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.default_risk_rating,,,
facility_dpd,ifrs9.committed_unutilized_v.FACILITY_DPD,,,
limit_category,ifrs9.committed_unutilized_v.IMIT_CATEGORY,,,
collateral_cover,hardcoded 0,,,
cash_margin,ifrs9.committed_unutilized_v.CASH_MARGIN_USD,,,
total_collateral_cover__usd_,hardcoded 0,,,
coa_item,ifrs9.committed_unutilized_v.COA_ITEM,,,
stage,"derived from multiple conditions on default_risk_rating, customer_delinquency_status, FLAG, gfpf_ab_rating, etc.",,,
staging_reason,"derived from stage, coa_item, default_risk_rating, etc.",,,
lgd,not defined (likely hardcoded or derived elsewhere),,,
moody_s_rating,not defined in this logic,,,
s_p_s_rating,not defined in this logic,,,
fitch_s_rating,not defined in this logic,,,
previous_effective_stage_reason,ifrs9.previous_stage_details.previous_stage_2_reason,,,
previous_effective_stage_date,ifrs9.previous_stage_details.previous_stage_2_date,,,
previous_effective_stage,ifrs9.previous_stage_details.effective_stage,,,
effective_stage,"derived from stage, staging_reason, PREVIOUS_STAGE_2_, new_MAX_STAGE, etc.",,,
effective_staging_date,"derived from PARTITION_LOAD_DATE, PREVIOUS_STAGE_2_DATE_, etc.",,,
effective_staging_reason,"derived from new_MAX_STAGE_REASON, staging_reason, PREVIOUS_STAGE_2_REASON_, etc.",,,
funded_unfunded_flag,hardcoded 'Unfunded',,,
ttc_pd,IFRS9.MRA_DATA.system_pd,,,
ecl_1y,not defined (likely derived or hardcoded),,,
ecl_maturity,not defined (likely derived or hardcoded),,,
lossallowance,not defined (likely derived or hardcoded),,,
cash_collaterals,hardcoded 0,,,
other_collaterals,hardcoded 0,,,
ead,derived from OUTSNDING_BLNC_USD,,,
bank,RAW_DATA_VAULT.BRANCHES.CAPF_BRNCH_NUMBER,,,
load_date,derived from ${PRCESS_DTE},,,
load_country,ifrs9.committed_unutilized_v.LCPF_LOAD_COUNTRY,,,
,,,,
IFRS9_OLD_RATE_FUNDED_UNFUNDED_ALL_LG,,,,
,,,,
Target Column,Source Columns (schema.table.column),,,
amortization_type,"derived from Amortization_Type_NEW, deal_type, and interest_rate_v.amortizationtype",,,
total_collateral_cover__usd_,derived from cash_collateral + other_collateral,,,
classification_desc,derived from classification using CASE logic,,,
ab_default_rating,derived from external_rating.external_rating or current_external_rating.abre,,,
source_system,derived from ifrs9.deals_funded_unfunded_report_all_lg.deal_type,,,
interest_frequency,derived from interest_rate_v.interestperiodicity_desc,,,
effective_staging_date,"derived from load_date, PREVIOUS_STAGE_2_DATE_, etc.",,,
staging_reason,derived from multiple conditions,,,
stage,"derived from multiple conditions on AB_default_rating, customer_delinquency_status, etc.",,,
applied_interest_rate,derived from multiple interest rate sources,,,
ead,derived from outstanding_balance_usd,,,
outstanding_balance_base_currency,derived from outstanding_balance_usd or outstanding_balance_lcl,,,
principal_repayment_frequency,"derived from payment_frequency_description, Amortization_Type, and interest_rate_v.interestperiodicity_desc",,,
product_segment,derived from product_name and customer_segment,,,
facility_product_type,derived from product_name and ifrs9.deal_types_desc_v.field_value_description,,,
effective_stage,"derived from stage, staging_reason, PREVIOUS_STAGE_2_, etc.",,,
effective_staging_reason,"derived from staging_reason, PREVIOUS_STAGE_2_REASON_, etc.",,,
funded_unfunded_flag,derived from type column in deals_funded_unfunded_report_all_lg,,,
limit_in_base_currency,hardcoded 'TBD',,,
lgd,hardcoded 'TBD',,,
cash_collaterals,ifrs9.collaterals_final.cash_collateral,,,
collateral_cover,ifrs9.collaterals_final.FACILITY_COLLATERAL_COVER,,,
other_collaterals,ifrs9.collaterals_final.other_collateral,,,
branch,ifrs9.deals_funded_unfunded_report_all_lg.account_branch_number_new,,,
suffix,ifrs9.deals_funded_unfunded_report_all_lg.account_suffix_new,,,
facility_reference,ifrs9.deals_funded_unfunded_report_all_lg.agreement_reference_id,,,
bank,ifrs9.deals_funded_unfunded_report_all_lg.bank_new_code,,,
coa_item,ifrs9.deals_funded_unfunded_report_all_lg.chart_of_account_key,,,
facility_currency,ifrs9.deals_funded_unfunded_report_all_lg.currency_code,,,
classification,ifrs9.deals_funded_unfunded_report_all_lg.customer_classification,,,
customer_delinquency_status,ifrs9.deals_funded_unfunded_report_all_lg.customer_delinquency_status,,,
customer_group_name,ifrs9.deals_funded_unfunded_report_all_lg.customer_group_name,,,
customer_id,ifrs9.deals_funded_unfunded_report_all_lg.customer_id_new,,,
customer_segment,ifrs9.deals_funded_unfunded_report_all_lg.customer_segment,,,
industry_code,ifrs9.deals_funded_unfunded_report_all_lg.economic_sector,,,
industry_description,ifrs9.deals_funded_unfunded_report_all_lg.economic_sector_description,,,
basic,ifrs9.deals_funded_unfunded_report_all_lg.external_account_number_new,,,
facility_dpd,ifrs9.deals_funded_unfunded_report_all_lg.facility_dpd,,,
facility_id,ifrs9.deals_funded_unfunded_report_all_lg.facility_ref,,,
customer_name_arabic,ifrs9.deals_funded_unfunded_report_all_lg.full_name_in_arabic,,,
customer_name_english,ifrs9.deals_funded_unfunded_report_all_lg.full_name_in_english,,,
limit_category,ifrs9.deals_funded_unfunded_report_all_lg.limit_category_new,,,
load_country,ifrs9.deals_funded_unfunded_report_all_lg.load_country,,,
load_date,ifrs9.deals_funded_unfunded_report_all_lg.load_date,,,
facility_maturity_date,ifrs9.deals_funded_unfunded_report_all_lg.maturity_full_date,,,
outstanding_balance_original_curreny,ifrs9.deals_funded_unfunded_report_all_lg.outstanding_balance,,,
outstanding_balance_usd,ifrs9.deals_funded_unfunded_report_all_lg.outstanding_balance_usd,,,
facility_start_date,ifrs9.deals_funded_unfunded_report_all_lg.start_full_date,,,
facility_rating_at_reporting_date,ifrs9.external_ratings.external_rating,,,
facility_rating_at_origination,ifrs9.external_ratings.EXTERNAL_RATINGS_ORIGIN,,,
fitch_s_rating,ifrs9.external_ratings.fitch or ifrs9.current_external_rating.fitch,,,
moody_s_rating,ifrs9.external_ratings.moody or ifrs9.current_external_rating.moody,,,
s_p_s_rating,ifrs9.external_ratings.sp or ifrs9.current_external_rating.sp,,,
country_of_risk,ifrs9.ifrs9_customer_info.risk_country,,,
interest_rate_spread,ifrs9.interest_rate_v.clientratespread or MAX_FIXEDRATE,,,
base_rate,ifrs9.interest_rate_v.FIXINGATBSD,,,
interest_rate_type,ifrs9.interest_rate_v.interestratetype,,,
interest_rate_for_discounted_bills,ifrs9.interestreceivedinadvanced_v.interest_rate,,,
mra_rating,ifrs9.mra_data.mra,,,
mra_pd,ifrs9.mra_data.system_pd,,,
ttc_pd,ifrs9.mra_data.system_pd,,,
previous_effective_stage,ifrs9.previous_stage_details.effective_stage,,,
previous_effective_stage_date,ifrs9.previous_stage_details.previous_stage_2_date,,,
previous_effective_stage_reason,ifrs9.previous_stage_details.previous_stage_2_reason,,,
restructured_flag,ifrs9.rescheduling_restructuring_v.FLAG,,,
rescheduled_flag,ifrs9.rescheduling_restructuring_v.FLAG,,,
cash_margin,ifrs9.UNFUNDED_CASH_MARGIN.mrgn_bal_usd,,,
ecl_1y,not defined (likely derived or hardcoded),,,
ecl_maturity,not defined (likely derived or hardcoded),,,
lossallowance,not defined (likely derived or hardcoded),,,