11.6.3 SQL Query Results

The results of running a SQL query can be exported to an Excel file for validation.

Financial Elements: The FINANCIAL_ELEMENT_ID column lists the financial elements written for each payment and repricing event processed by the cash flow engine. An initial set of data is also written, recording the balance and rate as of the last payment date.

The following table describes the financial elements that can be present in a base set of financial elements written during a cash flow audit process:

Table 11-14 Financial Elements Written During Audit

Financial Element	Description
Initial Event
100	Ending balance. The final balance on the payment date, after the payment has occurred.
430	Interest cash flow.
210	Total principal runoff, including scheduled payments, prepayments, and balloon payments.
60	Beginning balance. Starting balance and payment date, before payment.
120	Runoff Net Rate. The rate at the time of payment, weighted by ending balance. To view the actual rate, divide financial element 120 by financial element 100.
490	A discount factor used to determine the present value of cash flow on the payment date.
Initial Event
250	Par balance at the time of repricing.
280	Before Reprice Net Rate. Rate before repricing, weighted by repricing balance. To determine the true rate, divide this financial element value by financial element 250.
290	After Reprice Net Rate. Newly assigned net rate after repricing occurs, weighted by repricing balance. To determine the true rate, divide this financial element value by financial element 250.
Initial Event
100	The initial balance at the start of processing.
120	The initial net rate at the start of processing.

Cash Flow Codes: The Cash Flow Code column lists a code for each row that describes the event modeled by the Cash Flow Engine. The following table describes the different cash flow codes:

Table 11-15 Description of Cash Flow Codes

Cash Flow Code	Description
1	Initial recording of balances and rates.
2	Payment event only.
20	Reprice event only (not during the tease period).
8	Reprice during the tease period.
22	Reprice and payment events together (not during the tease period).
10	Reprice and payment during the tease period.