1. User Guide
  2. Data Loaders
  3. Stage Instrument Table Loader
  4. Mapping To OFSAA Processing Tables

5.6.3 Mapping To OFSAA Processing Tables

Following are examples of some of the pre-defined application T2T mappings between the above staging tables and processing tables:

  • T2T_LOAN_CONTRACTS: for loading data from STG_LOAN_CONTRACTS to FSI_D_LOAN_CONTRACTS.
  • T2T_MORTGAGES: for loading data from STG_LOAN_CONTRACTS to FSI_D_MORTGAGES.
  • T2T_CASA: for loading data from STG_CASA to FSI_D_CASA.
  • T2T_CARDS: for loading data from STG_CARDS to FSI_D_CREDIT_CARDS.
  • T2T_TD_CONTRACTS: for loading data from STG_TD_CONTRACTS to FSI_D_TERM_DEPOSITS.
  • T2T_ANNUITY_CONTRACTS: for loading data from STG_ANNUITY_CONTRACTS to FSI_D_ANNUITY_CONTRACTS.
  • T2T_BORROWINGS: for loading data from STG_BORROWINGS to FSI_D_BORROWINGS.
  • T2T_FORWARD_CONTRACTS: for loading data from STG_FUTURES to FSI_D_FORWARD_RATE_AGMTS.
  • T2T_FUTURE_CONTRACTS: for loading data from STG_FUTURES to FSI_D_FUTURES.
  • T2T_FX_CONTRACTS: for loading data from STG_FX_CONTRACTS to FSI_D_FX_CONTRACTS.
  • T2T_INVESTMENTS: for loading data from STG_INVESTMENTS to FSI_D_INVESTMENTS.
  • T2T_LEASES_CONTRACTS: for loading data from STG_LEASES_CONTRACTS to FSI_D_LEASES.
  • T2T_MM_CONTRACTS: for loading data from STG_MM_CONTRACTS table to FSI_D_MM_CONTRACTS.
  • T2T_OPTION_CONTRACTS: for loading data from STG_OPTION_CONTRACTS to FSI_D_OPTION_CONTRACTS.
  • T2T_SWAP_CONTRACTS: for loading data from STG_SWAPS_CONTRACTS to FSI_D_SWAPS.
  • T2T_OD_ACCOUNTS: for loading data from STG_OD_ACCOUNTS to FSI_D_CREDIT_LINES.
  • T2T_LOAN_COMMITMENTS: for loading data from STG_LOAN_COMMITMENTS to FSI_D_LOAN_COMMITMENTS
COLUMN SOURCE/OUTPUT COLUMN DESCRIPTION
COMMIT_START_DATE From source – Mandatory for Rate The date on which the Rate Lock period starts
COMMIT_MAT_DATE From source – Mandatory for Rate The date on which the Rate Lock period expires. Corresponds to the Loan Origination Date
COMMIT_TERM From source – Mandatory for Rate The Rate Lock term period. Equal to COMMIT_MAT_DATE – COMMIT_START_DATE
COMMIT_TERM_MULT From source – Mandatory for Rate The Rate Lock term multiplier
COMMIT_FEE_TO_CUST From source – Optional The fee that is charged to the customer for the Rate Lock agreement.
COMMIT_OPTION_COST_PCT Calculated – Output column The Rate Lock cost expressed as a percentage
COMMIT_OPTION_COST Calculated – Output column The calculated Rate Lock cost charged by treasury to the banker – Rate Lock % * Balance
COMMIT_OPTION_TYPE_CD From source - Mandatory Refers to Option Type (default = 1). At present, we support only European. If Option Type is European, then compute Rate Lock option cost using the Black Swaption formula. Otherwise do nothing.

Note:

FSI_D_LOAN_COMMITMENTS - Contains all existing columns from FSI_D_LOAN_CONTRACTS, plus the following columns which support the calculations

You can view the Database Extract definitions by performing the following steps:

Note:

The Data Management Tools and Data Ingestion were previously known as Data Integrator Framework and Warehouse Designer respectively. These new terminologies are applicable only for OFSAAI versions 7.3.2.3.0 and above.
  1. Navigate to Unified Metadata Manager and select Data Management Tools, and then select Data Ingestion, and then select Database Extracts section.
  2. In the left pane, expand the application as defined during application installation and click the Data Source defined during application installation.
  3. Expand the required T2T definition to view the Database Extract definitions.

You can view the Source - Target mapping definitions by performing the following steps:

Note:

The Data Management Tools and Data Ingestion were previously known as Data Integrator Framework and Warehouse Designer respectively. These new terminologies are applicable only for OFSAAI versions 7.3.2.3.0 and above.
  1. Navigate to Unified Metadata Manager and select Data Management, and then select Data Ingestion, and then select Database Extracts.
  2. In the left pane, expand the application as defined during application installation and click the Data Source defined during application installation.
  3. Expand the required T2T definition to view the extract definition.
  4. Click the required Database Extract definition.

The selected Database Extract definition details are displayed with the available Source - Target mappings under the Source - Target Mappings grid.

Note:

Staging instrument tables contain alphanumeric display codes for various IDENTIFIER and CODE columns. T2T mapping looks up in respective dimension tables for fetching an equivalent numeric ID and CODE corresponding to the alphanumeric display code. Hence, these dimension tables should be populated with the alphanumeric display code before executing any data movement tasks.