5.4.1 Forecast Rate Data Loader Tables
Forecast rate assumption data is stored in the following staging area tables:
STG_FCAST_XRATES:
This table holds the forecasted exchange rate data for the current ALM modeling period.Note:
For Direct Input Method, bothN_FROM_BUCKET
andN_TO_BUCKET
column contain the same bucket number for the record inSTG_FCAST_XRATES
table.STG_FCAST_IRCS:
This table holds the forecasted interest rate data for the current ALM modeling period.STG_FCAST_EI:
This table holds the forecasted economic indicator data for the current ALM modeling period.
Rates present in the above staging tables are copied into the following ALM metadata tables.
FSI_FCAST_IRC_DIRECT_INPUT, FSI_FCAST_IRC_STRCT_CHG_VAL.
FSI_FCAST_XRATE_DIRECT_INPUT, FSI_FCAST_XRATE_STRCT_CHG.
FSI_FCAST_EI_DIRECT_INPUT, FSI_FCAST_EI_STRCT_CHG_VAL