4.15 Account Summary

The Account Summary table consolidates account and instrument-level output data from Funds Transfer Pricing (FTP), Profitability Management (PFT), and other Profitability and Balance Sheet Management Cloud Service applications into a single, unified table. This consolidated table can be used for dashboard reporting, extraction, and other downstream consumption, without the need to separately query multiple application-specific output tables.

• Introduction to Account Summary
  Account Summary is a single, shared table that consolidates account and instrument-level data across Funds Transfer Pricing Cloud Service (FTPCS), Profitability Management Cloud Service (PFTCS), Process Automation Cloud Service (PACS), Asset Liability Management Cloud Service (ALMCS), and Cash Flow Edits Cloud Service (CFECS). FTP and PFT currently update the Instrument tables, so the Account Summary table is populated with output from both applications in a common structure. This avoids the need to maintain separate common and application-specific account summary tables, and avoids joining large result sets between them.
• Source Instrument Tables
  Account Summary is populated from the following source Instrument tables:
• Account Summary Load Configuration
  The Account Summary Load Configuration screen allows you to select the columns that must be populated into the Account Summary table from the Portfolio table class. Columns are grouped into two categories: Mandatory columns, which are populated out-of-the-box, and User-selected columns, which you choose from the Available Columns list. You can also select the dynamic output columns generated from FTP, PFT, or other rule executions, to include in the Account Summary table.