B.1 LRM Processing Tables and Results Tables
Table B-1 LRM Processing Tables and Results Tables
| TABLE_NAME | DISPLAY_NAME | DESCRIPTION |
|---|---|---|
| FSI_HIGH_RUN_OFF_CATEGORY | FSI High Run Off Category | This entity stores the High Run Off Category Criteria specified by Regulators to Legal Entity. Legal Entity and Category Type as granularity |
| FSI_INFLOW_CAPPED_TO_OUTFLOW | Inflow Capped To Outflow | Table captures percentage data to which inflow is capped to outflow as per EBA DA article 33. |
| FSI_INSTRUMENT_DETAILS | FSI Instrument Details | This table stores the regulatory application output at instrument level |
| FSI_INSURANCE_COVERAGE_SEQ | FSI Insurance Coverage Sequence | This entity stores the insurance coverage sequence. It stores the list of product types and sequence in which it should be covered by the insurance scheme. |
| FSI_INTERCOMPANY_CASHFLOW_TXNS | FSI Intercompany Cash flow Transactions | This entity stores the intercompany cash flow transactions at Legal Entity, Legal Entity as Counterparty and Currency granularity |
| FSI_INTRADAY_AGG_TXNS | Intraday Aggregated Transactions table | This table stores the transaction information aggregated at the level of entity, run, date, currency, result bucket. |
| FSI_INTRADAY_ALLOCATION_PCT | FSI Intra day Allocation Percentage | This entity stores intraday allocation percentage |
| FSI_INTRADAY_BUCKET_CASHFLOW | FSI Intra day Time Bucket Cash flow | This entity stores intraday time bucket cash flow |
| FSI_INTRADAY_CASH_FLOW | FSI Intra day Cash flow | This entity stores intraday cash flow at Legal Entity, Currency, Standard Payment Settlement System Type and Time bucket granularity. |
| FSI_INTRADAY_TXNS | Intraday Transaction Processing Table | This table will store the details of all the transactions |
| FSI_LCR_SCHEDULE | Liquidity Coverage Ratio Schedule | This table stores the details of the minimum LCR requirement as per regulatory guidelines. |
| FSI_LEGAL_ENTITY_OPTION_MAP | FSI Legal Entity Option Mapping | This table stores the mapping of legal entity and option. This table stores the information stating which option is valid for which legal entity and sequence in which it is to be applied. |
| FSI_LEGAL_ENTITY_RATING_DETAIL | Fsi Legal Entity Rating Detail | This entity stores all the ratings for legal entity. Ratings for legal entity can be long term or short-term rating, or they can be external or internal rating, external rating can be from various sources. This entity stores all rating for legal entity provided from various sources. |
| FSI_LIQUIDITY_SURVIVAL | FSI Liquidity Survival | This entity stores the liquidity survival indicator at legal entity and currency. Liquidity Survival is the period till which Stock of High-Quality assets will be sufficient to cover net cash outflows. |
| FSI_LRM_ACCT_CUST_DETAILS | FSI LRM Account Customer Details | This entity stores the derived attribute at account and customer granularity (includes joint accounts) |
| FSI_LRM_ASSETS | Fsi Lrm Assets | This table stores the assets that can be classified as high-quality liquid assets. |
| FSI_LRM_ASSUMPTION_PARAM_MAP | FSI LRM Assumption Parameters Mapping | This table stores all the parameters mapping used in business processor which in turn is used in an assumption |
| FSI_LRM_ASSUMPTION_TASKS | FSI LRM Assumption Task | This table stores the list of tasks that are to be stitched for the assumption. This table will be referred when BAU process has been saved, for each of the assumption and assumption sub category list of task that are stitched are provided in this table (includes the sequence in which task are to be stitched). |
| FSI_LRM_ASSUMP_LOV_MAP | FSI LRM Assumption List of Values Mapping | This table stores all the list of values mapping used in business processor which in turn is used in an assumption |
| FSI_LRM_BR_CNTRY_SUMMARY_DTLS | Fsi Lrm Branch Country Summary Details | This table is LRM processing table which captures the detailed summary of the restricted and unrestricted assets and cashflows at Run, Date, Legal Entity and branch level. |
| FSI_LRM_BUSINESS_ASSUMPTIONS | FSI LRM BUSINESS ASSUMPTIONS | This fsi table stores all the assumptions with the latest version |
| FSI_LRM_BUSINESS_DIMENSIONS | FSI LRM Business Dimensions | This entity stores the list of business dimensions applicable for Liquidity Risk Management (LRM) application. Business dimensions are set of hierarchies over which liquidity business assumption can be specified for example Legal Entity dimension, Product Type Dimensions, Customer Type Dimensions, Customer financial entity dimensions and other dimensions as mentioned in the LRM user guide. It also stores the information if dimension is mandatory or if dimension is selected by user for performing analysis in LRM. |
| FSI_LRM_BUSS_ASSUMPT_NAMES | Fsi Lrm Business Assumptions Names | This fsi table stores all the assumptions with the latest version |
| FSI_LRM_CHANGE_RECORD | Lrm Change Record | Table to store details of regulations covered by LRS under different jurisdictions. |
| FSI_LRM_COMPOSITE_KEY_DIMS | FSI LRM Composite Key Dimensions | This table stores the composite key identifiers, Composite key is equal to aggregate cashflow key in aggregate table. Purpose of this table is to uniquely identify and represent unique combination of account attributes with composite key. |
| FSI_LRM_CURRENCY_PRIORITY | Fsi LRM Currency Priority | This Table Stores the Currency Priority. For HKMA there is a requirement where a particular currency needs to be treated prior to another currency. This table is used for HKMA. |
| FSI_LRM_CURRENCY_RESTRICTION | Liquidity Risk Management Currency Restriction Details | This table is used to store the Currency Restriction Details for Liquidity Risk Management. |
| FSI_LRM_FWD_METHOD_RULES | Fsi LRM Balance - Cash Flow and Adjustment Rules | Seeded table which holds the Balance, Cash flow and adjustment Rules |
| FSI_LRM_HIER_MEMBER_DETAILS | FSI LRM Hierarchy Member Details | This table stores the detail mapping of Hierarchy Member code to their corresponding dimensional table primary key values. |
| FSI_LRM_HOME_HOST_CASHFLOWS | Lrm Home Host Cash Flows | The table stores the home and host cash flow data at composite key granularity. |
| FSI_LRM_HOST_ACCT_HQLA_LEVEL | Lrm Host Hqla Level Data | The table stores the host HQLA data at Account granularity. |
| FSI_LRM_HOST_INS_DETAILS | Lrm Host Dic Data Output | The table stores the host insurance data at Account granularity. |
| FSI_LRM_INSTRUMENT | FSI LRM Instrument | This Table Stores the Details of the Account. All the attribute Derived and Downloaded which are used in Liquidity Risk Management Solution. |
| FSI_LRM_INSTRUMENT_DLTS | Fsi Lrm Instrument Details |
"This Table Stores the Details of the Account. All the attribute Derived and Downloaded which are used in Liquidity Risk Management Solution. This Table Stores the Details of the Account. All the attribute Derived and Downloaded which are used in Liquidity Risk Management Solution. The Instrument details table Stores the Details of the Account. All the attribute Derived and Downloaded which are used in Liquidity Risk Management Solution." |
| FSI_LRM_INTRADAY_TB_DETAILS | Intraday Time Bucket Details | This table stores the bucket definition for each run for intraday. Each of the bucket will be assigned a start interval and end interval. This table will be used by all the process which requires the time bucket. |
| FSI_LRM_LE_SUMMARY | FSI LRM Legal Entity Summary | This table processing table is used to compute held to meet NCOF at legal entity and currency granularity. |
| FSI_LRM_LIABILITIES | Fsi Lrm Liabilities | This table stores the liabilities that can be classified as Qualifying Liability. |
| FSI_LRM_NCOF_CCY_DETAILS | Ncof Calculation At Currency Level | This table store the NCOF Calculation at Currency Level. |
| FSI_LRM_NCOF_COUNTRY_DETAILS | Liquidity Risk Management Net Cash Outflows Country Details. | This table store the Liquidity Risk Management Net Cashflows Calculation data output at Country Level granularity. This table will store the computed values like adjusted cashflows, restricted and unrestricted cashflows etc., All attributes in this table are derived by app specific rules. |
| FSI_LRM_NCOF_SUMMARY | Net Liquidity Outflows Amount Details | This table stores the Net Liquidity Outflows amount and SHQLA Details. |
| FSI_LRM_PARTY_DTLS | Fsi Lrm Party Details | This table captures the additional information of the parties which are treated specifically according to each jurisdiction. |
| FSI_LRM_REPORTING | Fsi Reporting Lines | This entity stores the measure to be reported for each of the Liquidity Reporting line. Reporting Measures are the amounts displayed in standard template prescribed by supervisor. For Example, Reporting lines and measures mentioned in QIS Reporting Template reporting lines, reporting lines and measures mentioned in "Instructions for completing and submitting the Liquidity Monitoring Tool (5-G) template". |
| FSI_LRM_REP_LINE_ATTR_DETAILS | Fsi Lrm Reporting Line Attribute Details | This entity stores the additional reporting line attribute required for LRM Regulatory reports |
| FSI_LRM_REP_LINE_DTLS | FSI LRM Reporting Line Details | This table stores the projected values at reporting line granularity. |
| FSI_LRM_RUN_ASSUMPTION_DETAILS | FSI LRM Run Assumption Details | this entity stores the list of assumptions selected for the given run while defining the run in LRM run management UI. |
| FSI_LRM_TIME_BUCKET_DAYS | Fsi Lrm Time Bucket Days | This table stores the bucket definition for each run. Each of the bucket will be assigned a start date and end date corresponding to be date of execution. This table will be used by all the process which requires the time bucket like time bucket assignment and allocation engine. |
| FSI_LRM_UNDERLYING_DETAILS | Fsi LRM Underlying Details | Table to hold the details of any underlying of exposures |
| FSI_MERGED_LE_DTLS | Merged Legal Entity Details Processing Table | This table stores the details of the Merged Entities. |
| FSI_MINORITY_INTEREST | Minority Interest Capital | This table is used as the processing table for minority interest capital calculations |
| FSI_MTM_COLL_VAL_CHANGE | FSI Mark-To-Market Collateral Valuation Change | This fsi table stores the Mark-To-Market Collateral inflows and Outflows Due To Derivative Transaction Valuation Changes. As per US LCR Final Rules, Collateral outflow amount for derivative valuation change is the absolute value of the largest 30-consecutive calendar day cumulative net mark-to-market collateral outflow or inflow realized during the preceding 24 months resulting from derivative transaction valuation change |
| FSI_NETTING_AGREEMENT | FSI Netting Agreement | This entity stores the derived attribute at netting agreement level |
| FSI_PARTY_DETAILS | Party Level Details | This table captures the party level financial measures for the particular execution identifier. Measures like total sales amount, total annual sales etc. Also, party level processed attribute like option code to determine correlation calculation for SME are also stored. |
| FSI_PARTY_ESTABLISHED_RLTNSHP | Party Established Relationship | This table stores all the bank customers who is holding more than one non-transactional account with the bank. |
| FSI_PARTY_REG_APP_OUTPUT | Party Regulatory App Output | This table stores details of parties who are associated with an Internal Rating Based (IRB) subclasses. This table data is expected to be an output from Basel application or a customer download equivalent to an output from a Basel application. Examples o |
| FSI_PARTY_ROLE_MAP | Party Role Map | Staging table for storing different roles that are played by a party. Stores history for the role |
| FSI_PARTY_STD_PARTY_MAP | Party To Standard Party Mapping | This entity will store the mapping of party from dim_party entity to the standard party code like FNMA, FHLMC etc as required for regulatory reporting. |
| FSI_PARTY_TYPE_CLASSIFICATION | Party Type Classification | Stores the party types and their standard party types |
| FSI_PEAK_NET_CASH_OUTFLOW | FSI Peak Net Cash Outflow | This table stores the intermediate processing details of peak net cash outflow calculated as per NPR guidelines. |
| FSI_PLACED_COLL_LOAD_RUN_MAP | Placed Collateral Load Run Map | This table stores the multiple versions of placed collateral record to support incremental processing |
| FSI_REG_APP_COUNTRY_RISK_WGT | Fsi Regulatory Application Country Risk Weight | This table stores the risk weight associated to a specific country |
| FSI_REG_APP_OUTPUT | FSI Regulatory Application Output | This table stores the regulatory application output at account level |
| FSI_REG_PROD_TYPE_RECLASS | Regulatory Product Type Reclassification | |
| FSI_STD_ACCT_HEAD_BAND_MAP | Standard accounting heads and NSFR Residual Mapping | Stores the standard accounting heads and NSFR residual maturity bands |
| FSI_SUBSTITUTABLE_COLL | Fact Substitutable Collateral | This entity stores the details of substitutable collateral. Certain contracts allow counterparties to substitute the collateral provided to the bank with others to lower quality collateral. |
| FSI_UNDERLYING_EXPOSURES | Underlying Exposures | Table to hold the details of any underlying of exposures |
| FSI_ACCT_COLL_MAP_DETAILS | Account To Collateral Map Details | This table stores account to collateral map details |
| FSI_ACCT_COMPOSITE_KEY_MAP | FSI Account Composite Key Map | This table stores the mapping of account with composite key. In case of product like currency swaps an account have two currencies associated with it (pay & receive), such accounts will have multiple currency cashflows. |
| FSI_ACCT_STBL_CRITERIA_SCORE | FSI Account Stability Criteria Score |
This entity stores account stability criteria score at account and stability criteria granularity. Stability Score at account granularity is aggregation of account stability criteria score. Stability Score of an account is the numeric representation of the liquidity stability of an account. Stability Score is used to assign liquidity premium for an account. Liquidity premium that investors will demand when any given security cannot be easily converted into cash and converted at the fair market value. When the liquidity premium is high, then the asset is said to be illiquid, which will cause prices to fall, and interest rates to rise. |
| FSI_ALA_CONSOLIDATION_TYPE | Alternative Liquidity Approach Consolidation Type | This table is used to store the Alternative Liquidity Approach consolidation types at each jurisdiction level. |
| FSI_ALA_LE_CURRENCY_DETAILS | Alternative Liquidity Approach Details At Legal Entity And Currency Level | This table is used to store the SHQLA amounts after applying various alternative liquidity approaches at Legal Entity, Shortfall Currency and Currency Covering Shortfall level. All intermediate calculation of the alternative liquidity approaches for arriving at the SHLQA will be stored in this table. |
| FSI_ALA_LE_CURRENCY_SUMMARY | Alternative Liquidity Approach Summary At Legal Entity And Currency Level | This table is used to store the SHQLA amounts after applying various alternative liquidity approaches at Legal Entity and Shortfall Currency level. |
| FSI_ACCT_CF_COLL_MAP_DETAILS | Account Cash Flows To Collateral Map Details | This table stores account cash flows to collateral map details |
| FSI_COUNTERPARTY_TYPE | Fsi Counterparty Type | "This table captures the counterparty types that are used across the Inflows-Secured, Inflows- Unsecured, Outflows-Secured, Outflows- Deposits, Outflows-Wholesale and Outflows- Other sections in FR2052A reporting" |
| FSI_COUNTRY_TRANS_RESTRICTED | Country Transfer Restricted | This Table stores the countries who are marked for Transfer Restriction. EBA Delegated Act Commission Article 32(8). |
| FSI_FCAST_INTERCOMPANY_CF_TXNS | Forecast Intercompany Cash Flow Txns | This entity stores the intercompany cash flow transactions at Legal Entity, Legal Entity as Counterparty, Forecast Date and Currency granularity |
| FSI_FCAST_LRM_TB_DAYS | Forecast LRM Time Bucket Days | This table stores the bucket definition for each forecast run. Each of the bucket will be assigned a start date and end date corresponding to the date of execution and forecast dates. This table will be used by all the process which requires the time bucket like time bucket assignment and allocation engine. |
| FSI_FCAST_NETTING_AGREEMENT | FSI Forecast Net exposure on netting agreement level | This table stores records of forecasted net exposure amount on netting agreement level |
| FSI_FCAST_PEAK_NET_CASH_OUTFLW | Forecast Peak Net Cash Outflow | This table stores the intermediate processing details of peak net cash outflow calculated as per NPR guidelines for each forecast date. |
| FSI_FCST_SEC_UNDLYG_COLLCTN | FSI Forecasted Securitization Collections | This fsi table stores the forecasted collections done on the underlying of securitization program |
| FSI_FORECAST_BALANCES | FSI Forecast Balances |
"This fsi table stores the forecast net balances intended to capture the forecasted (best estimate) change in balances across products." |
| FSI_FOREIGN_CCY_UTIL_DETAILS | Foreign Currency Utilization Details | This Table Stores the Sequence of the Currency to be used and to be executed at Legal Entity level under Option 2 of LCR |
| FSI_FUND_CIS_COMPOSITION | Fsi Fund Cis Composition | This processing entity stores the composition of the Investment Funds |
| FSI_FUND_INVESTMENT_COMP | Fsi Fund Investment Composition | This table stores the details of the investment mandate of the Fund. This table captures the mandate composition percent of the fund and the existing composition percentage with the fund. If NSFR of the fund is greater than 100 percent and the existing composition is less than the mandate percent, then more eligible assets can be purchased from the bank up to the mandate level. |
| FSI_CROSS_BORDER_COLL_ARR_DTLS | Cross Border Collateral Arrangment Details | This table captures the central bank of the country of the issuer of the asset and the central bank of the country in which liquidity risk is being undertaken, between which cross border collateral arrangements (CBCA) exists. This is used to classify assets as high-quality liquid assets. |
| FSI_DEPOSIT_BLOCK_DTLS | Depost Blocked Account Details | This table captures the Deposit Account Balance that has been Blocked Due To Legal, Contractual, Regulatory, Tax, Statutory, Foreign Student, Bank Guarantee Or Other Restriction and hence cannot be withdrawn. The Blocked Balance can be withdrawn only after Blocked Expiry Date is Terminated. |
| FSI_DEPOSIT_INSURANCE | Deposit Insurance Processing Table | This table stores the details of Deposit Insurance calculations at Account Granularity. |
| FSI_DEPOSIT_INSURANCE_DTLS | Deposit Insurance Details Processing Table | This table stores the details of Deposit Insurance calculations at Account, Party & Related Party Granularity. |
| FSI_DEPOSIT_INSURANCE_RECLASS | Deposit Insurance Party Type Classification | Stores the party types and their standard party types |
| FSI_DEP_INSURANCE_POOL_DTLS | Deposit Insurance Pool Details Processing Table | This table stores the Insured and Uninsured Insurance amount Portion details at Pool ID granularity. |
| FSI_DOWNGRADE_SPECIFICATION | FSI Downgrade Specification | This table will store the downgrade details for legal entity as specified by user in assumption user interface for downgrade assumption. |
| FSI_DOWNGRADE_TRIGGER | FSI Downgrade Trigger | This entity stores the Trigger Identifier. There will be additional collateral that is required to be posted liabilities if legal entity's rating goes below the stated rating, this stated rating is called as downgrade trigger. |
| FSI_DPS_EXCLUDED_PARTY | Deposit Protection Scheme Excluded Party | This table is used to store the excluded party information for the Deposit Protection Scheme. |
| FSI_DYNAMIC_SQL_ERROR_LOG | Dynamic SQL Error Log | This table stores the processing specific dynamic SQL queries as well as Error details, if any. |
| FSI_EXCHANGE_RATES | Currency Exchange Rates | This entity stores the exchange rates between two currencies for each run, run skey wise |
| FSI_EXCHANGE_RATE_HIST | Exchange Rate History | This table stores history of Currency exchange rates |
| FSI_EXP_MITIGANT_LOAD_RUN_MAP | Exposure Mitigant Load Run Map | This table stores the multiple versions of exposure mitigant record to support incremental processing |
| FSI_FCAST_AGG_BALANCES | FSI Forecast Aggregated Balances | Table Stores the aggregated Forward Balances calculated for the run w.r.t to the forward date (In table referred as AS_OF_DATE) |
| FSI_FCAST_AGG_NET_EXP | FSI forecast Net Exposure Aggregation | This table stores records of aggregated net exposure download data. |
| FSI_FCAST_ALLOCATED_BALANCES | Forecast Allocated Balances | This table stores all the attributes Derived which are used in Liquidity Risk Management Solution of forecast Run. The data is allocated to this table at composite key level. |
| FSI_FCAST_DATES | FSI LRM Forecast Dates | Table stores the adhoc Forward dates selected during the lrm forecast run definition. |
| FSI_FCAST_DL_NET_EXPOSURE | FSI Forecast Download Net Exposure | This table stores records of net exposure downloaded data and Interpolation indicator. |
| FSI_FCAST_DOWNLOAD_BALANCES | FSI Forecast Download Balances | Table stores the balances for the forecast dates which are given as a download. |
| FSI_ACCOUNT_NSFR_FACTOR_MAP | NSFR to account map table | This table holds the ASF, RSF factors for each account |
| FSI_ACCOUNT_REPLINE_NSFR_MAP | NSFR account summary | This table holds the ASF, RSF factors against the respective maturity bands and the measures |