1. User Guide
  2. Data Loaders
  3. Historical Rates Data Loader
  4. Tables Related to Historical Rates

5.3.1 Tables Related to Historical Rates

Historical rates are stored in the following staging area tables:

  • STG_EXCHANGE_RATE_HIST: This staging table contains the historical exchange rates for Currencies used in the system. Following columns are available:

Table 5-5 STG_EXCHANGE_RATE_HIST

Column Name Column Details
V_QUOTE_TYPE VARCHAR2(5 CHAR)
V_RATE_DATA_ORIGIN VARCHAR2(20 CHAR)
  • STG_IRC_RATE_HIST: This staging table contains the historical interest rates for the Interest Rate codes used in the system.
  • STG_IRC_TS_PARAM_HIST: This staging table contains the historical interest rate term structure parameters, used by the Monte Carlo engine.
  • STG_ECO_IND_HIST_RATES: This staging table stores the historical values for the Economic Indicators used in the system.

Historical rates in OFSAA Rate Management are stored in the following processing tables:

  • FSI_EXCHANGE_RATE_HIST: This table contains the historical exchange rates for the Currencies used in the system.
  • FSI_IRC_RATE_HIST: This table contains the historical interest rates for the Interest Rate codes used in the system.
  • FSI_IRC_TS_PARAM_HIST: This table stores the historical interest rate term structure parameters, used by the Monte Carlo engine.
  • FSI_ECO_IND_HIST_RATES: This table contains the historical values for the Economic Indicators used in the system.