6.1 Overview of Account Summary Tables

Within ALM BI, customer account-level data from both the OFSAA Staging Area and Instrument tables and consolidated into the standardized relational ALM BI Data Model. This consolidation is performed to organize all the relevant Account-level Data into a single Fact structure to be used for reporting.

This relational BI Model consists of four vertically partitioned Account Summary tables that are organized by application subject area:

• FCT_COMMON_ACCOUNT_SUMMARY: This table is shared by all OFSAA BI Applications and contains dimensional values, attributes, and financial measures which are generally applicable to the individual account records. This data is sourced directly from the Staging Area.
• FCT_ALM_ACCOUNT_SUMMARY: This table contains ALM specific financial measures and is sourced from the operational Instrument tables.
• FCT_FTP_ACCOUNT_SUMMARY: This table contains FTP specific financial measures and is sourced from the operational Instrument tables.
• FCT_LOAN_COMMITMENTS: This table contains loan commitments, which are loans that are not yet booked and is sourced from the Operational Instrument table FSI_D_LOAN_COMMITMENTS.