7.1.4.1.6 Off Balance Sheet Items
The Off Balance Sheet Items Report provides the analysis capability on the Stage off Balance Sheet Contracts Table.
You can use a series of Report Prompts to filter the data according to Functional Key Attributes pertaining to the Table Columns Perimeter.
The report displays the underlying data according to the following Charts’ logic:
- Stage Off Balance Sheet Contracts - Aggregated Statistics
Aggregation for CUR_PAR_BAL (sum), ORG_PAR_BAL (sum) and CUR_NET_RATE (avg) by AS_OF_DATE, ISO_CURRENCY_CD and PRODUCT_CODE.
In addition, for CUR_NET_RATE, the additional Balance Weighted Rate, WAVG_CUR_NET_RATE_OFF_BALANCE_SHEET, is calculated as the Weighted AVG by CUR_PAR_BAL.
- Stage Off Balance Sheet Contracts - Number of Records Trend
Total Record off Balance Sheet aggregated by AS_OF_DATE.
- Stage Off Balance Sheet Contracts
Granular table records at ACCOUNT_NUMBER level.
Figure 7-25 Staging Instrument Data – Off Balance Sheet Items