1. User Guide
  2. Data Loaders
  3. Stage Instrument Table Loader
  4. Stage Tables

5.6.1 Stage Tables

Following are examples of some of the various application staging instrument tables:

  • STG_LOAN_CONTRACTS: holds contract information related to various loan products including mortgages.
  • STG_TD_CONTRACTS: holds contract information related to term deposit products.
  • STG_CASA: holds information related to Checking and Savings Accounts.
  • STG_OD_ACCOUNTS: holds information related to over-draft accounts.
  • STG_CARDS: holds information related to credit card accounts.
  • STG_LEASES: holds contract information related to leasing products.
  • STG_ANNUITY_CONTRACTS: holds contract information related to annuity contracts.
  • STG_INVESTMENTS: holds information related to investment products like bond, equities, and so on.
  • STG_MM_CONTRACTS: holds contract information related to short term investments in money market securities.
  • STG_BORROWINGS: holds contract information related to various inter-bank borrowings.
  • STG_FX_CONTRACTS: holds contract information related to FX products like FX Spot, FX Forward, and so on. Leg level details, if any, are stored in various leg-specific columns within the table.
  • STG_SWAPS_CONTRACTS: holds contract information related to various types of swaps. Leg level details, if any, are stored in various leg-specific columns within the table.
  • STG_OPTION_CONTRACTS: holds contract information related to various types of options. Leg level details, if any, are stored in various leg-specific columns within the table.
  • STG_FUTURES: holds contract information related to interest rate forwards and all types of futures. Leg level details, if any, are stored in various leg-specific columns within the table.
  • STG_LOAN_COMMITMENTS: contains all existing columns from STG_LOAN_CONTRACTS

Note:

You can modify any existing instrument table to include the columns by adding the COMMITMENT_CONTRACTS super type. If you want to execute the Forward Rate transfer pricing pricing against tables in addition to FSI_D_LOAN_COMMITMENTS, then add the required columns and do so by adding the COMMITMENT_CONTRACTS super type via ERWIN.