1. User Guide
  2. Data Loaders
  3. Forecast Rate Data Loader
  4. Forecast Rate Data Loader Tables

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, both N_FROM_BUCKET and N_TO_BUCKET column contain the same bucket number for the record in STG_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