1. Liquidity Risk Regulatory Calculations for Hong Kong Monetary Authority User Guide
  2. Appendix A: Data Transformations/Functions used in LRRCHKMA

10 Appendix A: Data Transformations/Functions used in LRRCHKMA

This section provides information about the Data Transformations (DTs) or functions used in the LRRCHKMAApplication.

  • TB_DATE_ASSIGNMENT

    This function performs the following actions:

    1. Identifies the dates between the bucket start day and bucket end day.
    2. Populates the intermediate dates based on the chosen FIC-MIS date, in the FSI_LRM_TIME_BUCKET_DAYS table.
    3. The business day convention (prior, conditional prior, following, no-Adjustment) is applied, taking into account the holiday calendar applicable for a Legal Entity, and is populated in the FSI_LRM_TIME_BUCKET_DETAILS table for each Legal Entity.
  • UPD_PROCESS_SCENARIO_KEY

    This function updates the process scenario Skey in the DIM_FCST_RATES_SCENARIO tables. It performs the following actions:

    1. Reads the current Run information from the FCT_LRM_RUN_PARAM and DIM_RUN tables.
    2. Populates the Contractual/Business As Usual, Run name, Run type, Run description into the DIM_FCST_RATES_SCENARIO table from DIM_RUN.
    3. Updates the process key for the current Run in the FCT_AGG_BASE_CCY_LR_GAP table storing liquidity risk gap measures in base currency.
    4. Updates the process key for the current Run in the FCT_AGG_BASE_CCY_LR_GAP table storing liquidity risk gap measures in consolidated currency.
    5. Updates both local and natural, inflow, and outflow amount columns in the FCT_AGG_CASH_FLOWS table using exchange rate conversion.
    6. Updates both inflow and outflow local currency amount columns in the FCT_ACCOUNT_CASH_FLOWS table using exchange rate conversion.
    7. Updates both local and natural currency amount columns in the FCT_LRM_LE_SUMMARY table using exchange rate conversion.
  • UPDATE_UNDERLYING_ASSETS

    This function updates all the attributes of the underlying assets, mitigants or placed collateral of an account such as asset level, fair value, market value, and so on, in the FSI_LRM_INSTRUMENT table. For example, consider a loan contract for which a mitigant is received. This loan account is captured in the STG_LOAN_CONTRACTS table and the mitigant information is captured in the STG_MITIGANTS table. The link between the loan account and the mitigant is captured in the STG_ACCOUNT_MITIGANT_MAP table. From the STG_ACCOUNT_MITIGANT_MAP table, data moves to the FCT_ACCOUNT_MITIGANT_MAP table.

    The function identifies the account mitigant mapping from the FCT_ACCOUNT_MITIGANT_MAP table and updates the attributes of the mitigant against the loan account in the FSI_LRM_INSTRUMENT table. For example, if the market value of the mitigant is $500, then the function updates the column FSI_LRM_INSTRUMENT.N_UNDERLYING_RECV_LEG_MKT_RCY as $500 for the loan contract account.

    Similarly, consider another example of a repo contract where the bank has placed collateral. The repo contract is captured in the STG_REPO_CONTRACTS table and moved to the FSI_LRM_INSTRUMENT table. The collateral placed against the repo contract is captured in the STG_PLACED_COLLATERAL table. The relationship between placed collateral and the REPO contract is captured in the STG_ACCT_PLACED_COLL_MAP table and is moved to the FCT_ACCT_PLACED_COLL_MAP table.

    The function updates the asset level of the placed collateral against the repo contract in the FSI_LRM_ISNTRUMENT table, which indicates that the FSI_LRM_INSTRUMENT.N_UNDERLYING_ASSET_LEVEL_SKEY column is updated.

    Similarly, the function updates the following attributes of the underlying asset (Mitigant/Placed Collateral) in the FSI_LRM_ISNTURMENT table:

  • N_UNDERLYING_ASSET_LEVEL_SKEY
  • N_UNDERLYING_MKT_RCY
  • N_UNDERLYING_FAIR_RCY
  • F_UNDERLY_QUALIF_UNENCUMB
  • N_UNDERLY_RISK_WEIGHT_SKEY
  • N_UNDERLY_STD_ISSUER_TYPE_SKEY
  • N_UNDERLY_STD_PROD_TYPE_SKEY
  • N_UNDERLYING_INST_BASEL_RATING
  • F_UNDERLY_COLL_COVER_SHORT_POS
  • F_UNDRLY_COVER_BANK_SHORT_POS
  • F_UNDRLY_COVER_CUST_SHORT_POS
  • F_UNDERLY_ISSUER_FINAN_ENTITY
  • F_UNDERLY_REHYPOTHECATED_FLAG
  • F_UNDERLYING_ISSUER_US_FLAG
  • F_UNDERLYING_GUARANTOR_US_FLAG
  • F_UNDRLYNG_PLACED_HQLA_FLAG
  • F_UNDERLYING_HELD_BY_CLIENT
  • F_UNDRLYNG_ASST_SEGREGATED_IND
  • N_HQLA_MIT_VAL_RCY
  • N_NON_HQLA_MIT_VAL_RCY
  • N_EXP_NOT_COV_BY_HQLA_MIT_RCY

These columns are used for calculating the adjustments to be performed in the stock of HQLA process and also in business as usual assumptions.

This data transformation identifies the underlying asset of an account from the mapping tables (FCT_ACCOUNT_MITIGANT_MAP and FCT_ACCT_PLACED_COLL_MAP), reads the attributes of the underlying asset (mitigant from FCT_MITIGANTS and placed collateral from FSI_LRM_INSTRUMENT tables) and updates it against the account in the FSI_LRM_INSTURMENT table using the following steps:

  1. Assigns the used portion of a placed collateral in FCT_ACCT_PLACED_COLL_MAP table, that is, updates the FCT_ACCT_PLACED_COLL_MAP.N_DRWN_PORTION_COLL_AMT column.
  2. Assigns the underlying asset level.
  3. Assigns the underlying asset level Skey of SUBSTITUTABLE COLLATERAL to:
    • Derivative Products
    • Non-Derivative Products

    Updates the N_COLL_SUBSTITU_ASSET_LVL_SKEY and N_SBSTBL_ASST_LVL_ENT_SKEY columns of the FSI_LRM_INSTRUMENT table.

  4. Assigns revised maturity date Skey for (CS, REVREPO, DRB, SECBORR) product, that is FLI.N_REVISED_MATURITY_DATE_SKEY. Updates the encumbrance percent in the FSI_LRM_INSTRUMENT table against the placed collateral records, that is, FLI.N_PERCENT_ENCUMBERED.