I.1 Load Instrument Summary

For users who want to consolidate Profitability and Funds Transfer Pricing information from multiple Instrument tables into a single consolidated table, a new process has been created and is described below. The process includes a Data Transformation procedure that will move account-level data from each Instrument table into a single table, FSI_D_INST_SUMMARY. The primary use for this new table is that it becomes a single data source for moving Profitability and Funds Transfer Pricing results to FCT tables in the reporting area and replaces the previous process that included separate T2T’s for each instrument table. Users may also want to use this table to build Profitability or Funds Transfer Pricing reports directly against process area data.

In earlier versions, customers who use FTP or Profitability BI applications have been required to run multiple T2Ts’; one for each instrument table to load data into a reporting area table, which was an error-prone and time-consuming activity.

Additionally, each relevant BI application (for example ALM and FTP Analytics, Retail Performance Analytics and Institutional Performance Analytics will provide a single T2T to move data from FSI_D_INST_SUMMARY to FCT_FTP_ACCOUNT_SUMMARY or FCT_PFT_ACCOUNT_SUMMARY as needed to support their specific reporting requirements.

Batch to Load Instrument Summary table:

• Seeded batch name: <INFODOM>_LOAD_INSTRMNT_SUMMARY
• Function name (which gets triggered from the batch): FN_LOAD_INSTRMNT_SUMMARY
• DT name: LOAD_INSTRMNT_SUMMARY