7.1.4.5.5 Loan Commitments

The Loan Commitments Report provides the analysis capability on the Loan Commitments 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:

• Loan Commitments - 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_ID.

  In addition, for CUR_NET_RATE, the additional Balance Weighted Rate, WAVG_CUR_NET_RATE_LOAN_COMMITMENTS, is calculated as the Weighted AVG by CUR_PAR_BAL.

• Loan Commitments - Number of Records Trend

  Total Records Loan Commitments aggregated by AS_OF_DATE.

• Loan Commitments

  Granular table records at ACCOUNT_NUMBER level.

Figure 7-46 Processing Instrument Data – Loan Commitments