Skip to Main Content
Return to Navigation

Integration with Enterprise Performance Management Warehouses

Risk-Weighted Capital draws data from the EPM data warehouse tables for its processing, and posts results back to the warehouse for reporting. After you load the data from your source systems into the Operational Warehouse Store (OWS), the ETL process moves it into the Operational Warehouse-Enriched (OWE). You can run another set of ETL maps to populate the Multidimensional Warehouse (MDW) tables, which are used by reporting tools to create reports.

For a discussion of the EPM warehouse tables common to all the Financial Services Industry applications, including Risk-Weighted Capital, see PeopleSoft Application Fundamentals for the Financial Services Industry Documentetion, "Understanding Common FSI Processes".

Risk-Weighted Capital Output Tables

The following are output tables specific to Risk-Weighted Capital processing:

  • RWC_CALC_IN_F00

    Stores RWC and normalized loss amounts for instruments.

  • RWC_CALC_AC_F00

    Stores RWC and normalized loss amounts for PF ledger accounts.

  • RWC_CALC_PS_F00

    Stores RWC and normalized loss amounts for treasury positions.

  • RWC_CALC_IP_F00

    Stores RWC and normalized loss amounts for forecasted pools.

  • RWC_BS_PROD_F00

    Stores instrument balances processed, their weighted average risk and normalized loss weights.

  • RWC_BS_TRPS_F00

    Stores treasury position balances processed, their weighted average risk and normalized loss weights.

  • RWC_RCN_F00: stores RWC and normalized loss amounts from the RWC reconciliation process.

  • FI_IRWCALC_R00

    Stores RWC rates for instruments.

  • FI_POOLRWC_R00

    Stores RWC rates for forecasted pools.

  • FI_RWC_CR_F00

    Stores credit risk engine final output. Includes final fields for risk-weighted asset and regulatory capital results.

  • FI_IBAL_R00

    Stores balance amounts related to the instrument.

  • FI_POOL_CF_R00

    Stores balance amounts related to financial instrument pool cash flows.

  • FI_POOLINST_F00

    Primary table for the Financial Instrument Pool family of tables. Contains a row for each Pool created as the result of the Stratification Engine process. An instrument pool is a single entity that acts as a proxy for a group of financial instruments. The Stratification Engine provides a way to programmatically group and summarize Financial Instruments into a Pool that can be used as a data source for the Financial Calculator and Cash Flow generators.

  • FI_POOLHDR_R00

    Stores balance amounts related to pooled instrument records.