Skip to Main Content
Return to Navigation

Integration with PeopleSoft EPM Warehouses

PeopleSoft Funds Transfer Pricing draws data from PeopleSoft EPM warehouses 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 Extract, Transform, and Load (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 Business Intelligence reporting tools to create reports.

See Financial Performance Measures Process.

Funds Transfer Pricing Engine Output Tables

The following are output tables specific to PeopleSoft Funds Transfer Pricing processing:

  • FTP_RECALC_R00: Stores the components of the funds transfer pricing recalibrated rate.

  • FTP_RECALC_TBL: Stores the components of the cash flows used in the calculation of the funds transfer pricing recalibrated rate.

  • FTP_FCST_F00: Stores funds transfer pricing charges per accounting period for forecasted pools output.

  • FI_FCSTRATE_R00: Stores the funds transfer pricing rate for historical and forecast instruments/pools.

  • FI_IFTPRATE_R00: Stores funds transfer pricing rates for instruments.

  • FI_IFTPADJ_R00: Stores funds transfer pricing adjustments.

  • FI_IBFCHRG_R00: Stores break fund charges output from the FTP_BFND application engine .

  • FI_IFTPBFND_R00: Stores break fund rules.

  • FTP_CALC_IN_F00: Stores funds transfer pricing charge or credit amounts for instruments output from the FTP_INST application engine.

  • FTP_CALC_AC_F00: Stores funds transfer pricing charge or credit amounts for PF ledger accounts output from the FTP_ACCT application engine.

  • FTP_CALC_PS_F00: Stores funds transfer pricing charge or credit amounts for treasury positions output from the FTP_TRPS application engine.

  • FTP_CALC_IP_F00: Stores funds transfer pricing charge or credit amounts for forecasted instrument pools output from the FTP_FPOOL application engine.

  • FI_POOLFTP_R00: Stores funds transfer pricing rates for forecasted instrument pools.

  • FTP_CCRATE_F00: Stores current period cost of capital rates to be used when calculating funds transfer pricing charges for RWC allocations for an instrument, account, or position.

  • FTP_RCN_F00: Stores funds transfer pricing charges or credits for reconciliation amounts, (differences between product or PF Ledger balances and position or PF Ledger balances).

  • FTP_CALC_BL_F00: Stores funds transfer pricing charge or credit amounts per Accounting Period for Financial Instruments output from the FTP_INST application engine.