4.3.2.3 Result Master: Other Columns (DEFAULT - But do not omit)

Table 4-5 Details of Other Columns of Result Detail table for Market Value Results

Column	Description
Result_Sys_ID	This is a key column for associating the results with your ALM Process. Plug this with the value from the System ID of your consolidated processing rule.
All other Dimension Columns	These columns are not relevant to your simulation.

Sample SQL:

The following statement was used to consolidate the results of sys_id_num = 1 and 2 into a sys_id_num = 101:

INSERT INTO FSI_O_RESULT_MASTER SELECT 101 AS RESULT_SYS_ID,

SCENARIO_NUM, ORG_UNIT_ID,

0 AS GL_ACCOUNT_ID,

COMMON_COA_ID, PRODUCT_ID,

FINANCIAL_ROLLUP, START_DATE_INDEX,

LEG_TYPE, SUM(CUR_PAR_BAL), SUM(CUR_NET_PAR_BAL),

SUM(CUR_DEFER_BAL_C), SUM(CUR_NET_RATE_W), SUM(CUR_WARM),

SUM(CUR_INTR_REC_ACCR),

SUM(NEW_GROSS_BALANCE), SUM(NEW_NET_BALANCE), SUM(MARKET_VALUE),

SUM(DURATION), SUM(CONVEXITY), SUM(CUR_TRANSFER_RATE),

SUM(MARKET_VALUE_CLEAN), SUM(MODIFIED_DURATION), SUM(YTM), SUM(AVERAGE_LIFE)

FROM FSI_O_RESULT_MASTER WHERE RESULT_SYS_ID IN (1,2) GROUP BY

SCENARIO_NUM, ORG_UNIT_ID, COMMON_COA_ID, PRODUCT_ID, FINANCIAL_ROLLUP,

START_DATE_INDEX, RESULT_TYPE_CD, LEG_TYPE