1. Credit Risk Analytics User Guide
  2. Metadata Information
  3. Rules

8.1 Rules

List of rules that are added or modified as part of this release are:

  • CRARULE0014 - Delinquent Account Classification

    This Rule will update the BPCRA009 (F_ACCT_DELQ_FLAG) in FCT_CREDITRISK_ACCOUNT_SUMMARY table.

  • CRARULE0015 - Impaired Asset Assignment

    This Rule will update the BPCRA015 (F_IMPAIRED_FLAG) in FCT_CREDITRISK_ACCOUNT_SUMMARY table.

  • CRARULE0045 CRA - Age On Book Band

    This Rule will update the BPCRA044 (N_AGE_ON_BOOK_BAND_SKEY) in FCT_CREDITRISK_ACCOUNT_SUMMARY table.

  • CRARULE0051 CRA - Adjusted EOP Population

    This Rule will update the BPCRA135 (N_ADJUSTED_EOP) and BPCRA136 (n_adjusted_eop_rcy) in FSI_CRA_ACCOUNT_SUMMARY table by default based on standard product type as HELOC. If it is not Home Equity Line of Credit (HELOC), then BPCRA075 and BPCRA076 is updated based on n_eop_bal and n_eop_bal_rcy respectively.

  • CRARULE0052 CRA - High Risk Account Classification

    This Rule will update the BPCRA074 (F_HIGH_RISK_ACCOUNT_FLAG) in FSI_CRA_ACCOUNT_SUMMARY table.

  • CRARULE0053 CRA - Delinquent Amount Computation

    By default, this Rule will update the BPCRA085 (N_DELQ_AMOUNT) and BPCRA087 (N_DELQ_AMOUNT_RCY) in FSI_CRA_ACCOUNT_SUMMARY table. This can be customized to the BPCRA084 (Account Delinquent Amount based on Adjusted EOP) and BPCRA086 (Account Delinquent amount in Reporting Currency based on Adjusted EOP).

  • CRARULE0054 CRA - Delinquent Days above 30, 60 and 90 Flag Population
    This Rule will update the BPCRA081 (F_ABOVE_30_DAYS_DEL_FLAG),BPCRA082 (F_ABOVE_60_DAYS_DEL_FLAG), BPCRA083 (F_ABOVE_90_DAYS_DELQ_FLAG) in FSI_CRA_ACCOUNT_SUMMARY table.

    Note:

    By default, N_DELQ_DAYS for F_ABOVE_30_DAYS_DEL_FLAG is 30 days, for F_ABOVE_60_DAYS_DEL_FLAG is 60 days and for F_ABOVE_90_DAYS_DEL_FLAG is 90 days. This can be updated accordingly in the Rule Parameter screen.
  • CRARULE0055 CRA - Impaired Amount Computation

    By default, this Rule will update the BPCRA089 (N_IMPAIRED_AMOUNT) and BPCRA091 (N_IMPAIRED_AMOUNT_RCY) in FSI_CRA_ACCOUNT_SUMMARY table. This can be customized to the BPCRA088 (Account Impaired Amount based on Adjusted EOP) and BPCRA090 (Account Impaired amount in Reporting Currency based on Adjusted EOP).

  • CRARULE0011 CRA - Charge-Off Account Classification

    This Rule will update the BPCRA012 (F_WRITE_OFF_FLAG) in FCT_CREDITRISK_ACCOUNT_SUMMARY table.

  • CRARULE0058 - CRA - Current Weighted Maximum Bureau Score

    This Rule will update the BPCRA093 (N_ECS_WTD_OUTSTANDING) in FSI_CRA_ACCOUNT_SUMMARY table.

  • CRARULE0059 - CRA - Exposure Amount Population
    By default, in FSI_CRA_ACCOUNT_SUMMARY table:
    • For revolving indicator set to No:
      • This rule will update the BPCRA097 (N_EXPOSURE_AMOUNT). This can be customized to the BPCRA0101 (Sum of Outstanding and Undrawn Amount), BPCRA096 (Current Credit Limit) or BPCRA095 (Maximum of Current Credit Limit And Adjusted EOP).
      • This rule will update the BPCRA098 (N_EXPOSURE_AMOUNT_RCY). This can be customized to the BPCRA101 (Sum of Outstanding and Undrawn Amount RCY), BPCRA099 (Current Credit Limit RCY) or BPCRA100 (Max of CCL and Adjusted EOP Bal RCY)
    • For revolving indicator set to Yes:
      • This rule will update the BPCRA095 (Max of CCL and Adjusted EOP Balance). This can be customized to the BPCRA094 (Sum of Outstanding and Undrawn Amount), BPCRA097 (Adjusted EOP Balance) or BPCRA096 (Current Credit Limit).
      • This rule will update the BPCRA100 (Max of CCL and Adjusted EOP Bal RCY). This can be customized to the BPCRA101 (Sum of Outstanding and Undrawn Amount RCY), BPCRA098 (Adjusted EOP Balance RCY), or BPCRA099 (Current Credit Limit RCY)
  • CRARULE0060 - CRA - Weighted Current and Combined LTV By Exposure Computation

    This rule will update the BPCRA102 (Weighted Current Combined LTV By Exposure) in the N_COM_LTV_WTD_BY_EXP in FSI_CRA_ACCOUNT_SUMMARY table.

  • CRARULE0062- CRA - Account Funded Amount Computation

    By default, this rule will Update the BPCRA108 (Account Funded Amount As Drawn Amount) in the N_FUNDED_AMT and N_FUNDED_AMT_RCY in FSI_CRA_ACCOUNT_SUMMARY table. This can be customized to the BPCRA109 (Account Funded Amount As Line Utilized Amount in Credit Line Details).

  • CRARULE0063- CRA - Application Funded Amount Computation

    This rule will update the BPCRA112 (Application Funded Amount As Drawn Amount) in the n_funded_amt, n_funded_amt_rcy in fsi_cra_application_summary table. This can be customized to the BPCRA115 (Application Level Funded Amount Based On Credit Line).

  • CRARULE0064- CRA - Application Funded Flag Population

    This rule will update the BPCRA114 (Application Funded Flag) in the f_funded_flag in fsi_cra_application_summary table.

  • CRARULE0066 - CRA - Age On Book

    This Rule will update the BPCRA121 (Age on Book) in the N_AGE_ON_BOOK in the FSI_CRA_ACCOUNT_SUMMARY table. This can be customized to BPCRA122 (Age on Book based on Value Date).

  • CRARULE0067- CRA - Application Origination Credit Limit Population
    By default for the n_orig_credit_limit, n_orig_credit_limit_rcy in fsi_cra_application_summary tables are updated:
    • For CRA Standard Product Type:
      • This rule will update the BPCRA125 (Application Origination Credit Limit Based on Funded Amount). This can be customized to BPCRA123 (Application Origination Credit Limit Based on Exp Auth Amount) or BPCRA127 (Application Origination Credit Limit Based on Sanctioned Limit).
      • This rule will update the BPCRA126 (Application Origination Credit Limit Based on Funded Amount in RCY). This can be customized to BPCRA124 (Application Origination Credit Limit Based on Exp Auth Amt in RYC) or BPCRA128 (Application Origination Credit Limit Based on Sanction Limit in RCY).
    • For Home Equity Line of credit:
      • This rule will be update the BPCRA123 (Application Origination Credit Limit Based on Exp Auth Amount). This can be customized to BPCRA125 (Application Origination Credit Limit Based on Funded Amount) or BPCRA127 (Application Origination Credit Limit Based on Sanctioned Limit).
      • This rule will update the BPCRA124 (Application Origination Credit Limit Based on Exp Auth AMt in RYC). This can be customized to BPCRA126 (Application Origination Credit Limit Based on Funded Amt in RYC) or BPCRA128 (Application Origination Credit Limit Based on Sanctioned Limit in RYC).
  • CRARULE0068- CRA - Application Weighted Measures Computation

    This rule will update the BPCRA117 (Application Weighted ECS by Origination Credit Limit) in the n_max_bureau_score_wtd_crlimit, n_rev_gds_wtd_org_crlimit, n_rev_ltv_wtd_org_crlimit, n_rev_tds_wtd_org_crlimit in fsi_cra_application_summary tables.

  • CRARULE0069 - CRA - Application Summary Bands Population

    This rule will update the BPCRA129 (Origination Credit Score Band) in the n_org_credit_score_band_skey, n_rev_credit_score_band_skey, n_orig_ltv_band_skey, n_rev_gds_band_sky, n_rev_tds_band_skey in fsi_cra_application_summary tables.

  • To add Business Process to Derived Entities, see
  • To add Hierarchy to Derived Entities, see