10.7.20 Analyzing Results

You should always analyze results obtained from the BSP Engine. For example, you should review the forecast rate – audit information to ensure that the new business rates and resulting interest accruals have been generated correctly for each scenario.

In addition, you should review both your beginning balances and resulting balances in each forecast period as well as your scenario-specific behavioral assumptions to verify that assumptions have been defined and applied correctly. The following relational database tables are populated with BSP Static Deterministic process results and can be queried directly by a SQL query tool such as Oracle SQL Developer:

Table 10-9 Database Tables Populated with Static Deterministic Process

Table Name	Description	Sample SQL query
Result Master	Static and point-in-time information such as current balance, current rate, current transfer rate, yield to maturity, market value, duration, DV01, and convexity are stored in this table for each Product COA member included in the process, for all scenarios associated with the process. Result Master data is stored in original / base currency.	select * from fsi_o_result_master where result_sys_id=xxxxxx order by start_date_index, scenario_num, product_id;
Result Detail	Cash flow results are stored in result detail and are spread across columns based on the "active" time bucket rule used when the process was run. Each row of data represents a distinct Financial Element such as Beginning Balance, Average Balance, Ending Balance, Interest Cash Flow, Principal Cash Flow, and so on. Result Detail data is stored in original/base currency.	select * from res_dtl_xxxxxx order by start_date_index, scenario_num, product_id, financial_elem_id, result_type_cd;