1. User Guide
  2. On-prem to SaaS Migration
  3. Data Migration
  4. Migration Execution Scripts
  5. finalize.sh

4.3.3.4 finalize.sh

Execute finalize.sh script, to apply the transformations to the data loaded into the Target SaaS environment.

finalize.sh is located in <$FIC_HOME>/utility/Data_Export_to_SaaS/bin directory.

Syntax: ./finalize.sh <Start_Date DDMMYYYY> <End_Date DDMMYYYY>

Note:

  • The start date and end date are optional parameters.
  • To transform the data for a specific time period, ensure to enter both the start and end date.
  • If you provide only one date, it is considered as the start date.
  • The finalize.sh script can be executed any number of times, but it is recommended to execute after all the data migration is complete.

Example: ./finalize.sh 01122023 31122023

Transformations Post Data Migration

Executing finalize.sh triggers the following data transformations.

Table 4-3 Transformations post data migration

SaaS/Target Table SaaS-Column Transformations Post Data Migration
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS AMRT_TYPE_CD
  • If AMRT_TYPE_CD is between 1000 and 69999, the corresponding value is set to 20
  • If AMRT_TYPE_CD is between 70000 and 99999, the corresponding value is set to 10
  • If AMRT_TYPE_CD is either 400 or 500, the corresponding value is set to 100
  • In all other scenarios, the AMRT_TYPE_CD value is retained
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS PMT_PATTERN_CD If AMRT_TYPE_CD is between 1000 and 69999, the PMT_PATTERN_CD value is set to the AMRT_TYPE_CD value. In all other scenarios, it is set to NULL.
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS BEHAVIOUR_PATTERN_CD If AMRT_TYPE_CD is between 70000 and 99999, the BEHAVIOUR_PATTERN_CD is set to the AMRT_TYPE_CD value. Otherwise, it is set to NULL.
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS ADJUSTABLE_TYPE_CD
  • If ADJUSTABLE_TYPE_CD is 30, the corresponding value is set to 50
  • If ADJUSTABLE_TYPE_CD >= 500, the corresponding value is set to 10
  • In all other cases, the value of ADJUSTABLE_TYPE_CD is retained
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS REPRICE_PATTERN_CD If ADJUSTABLE_TYPE_CD is >= 500, then the REPRICE_PATTERN_CD is set to the ADJUSTABLE_TYPE_CD value. In all other cases, it is set to NULL.
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS COMPOUNDING_BASIS_CD If COMPOUNDING_BASIS_CD is either 200 or 999, the corresponding value is set to 160. Otherwise, the value of COMPOUNDING_BASIS_CD is retained.
FSI_D_ASSET, FSI_D_LIABILITY OPTION_EXPIRY_DATE The OPTION_EXPIRY_DATE column in the target table is updated with the values from the OPTION_EXPIRY_DATE column in the FSI_D_EMBEDDED_OPTIONS_SCH table.
FSI_D_ASSET, FSI_D_LIABILITY STRIKE_VALUE The STRIKE_VALUE column in the target table is updated with the values from the STRIKE_VALUE column in the FSI_D_EMBEDDED_OPTIONS_SCH table.
FSI_D_ASSET, FSI_D_LIABILITY STRIKE_IRC_CD The STRIKE_IRC_CD column in the target table is updated with the values from the STRIKE_IRC_CD column in the FSI_D_EMBEDDED_OPTIONS table.
FSI_D_ASSET, FSI_D_LIABILITY EXERCISE_TYPE_CD The EXERCISE_TYPE_CD column in the target table is updated with the values from the EXERCISE_TYPE_CD column in the FSI_D_EMBEDDED_OPTIONS table.
FSI_D_ASSET, FSI_D_LIABILITY RATE_LOOKUP_CD The RATE_LOOKUP_CD column in the target table is updated with the values from the RATE_LOOKUP_CD column in the FSI_D_EMBEDDED_OPTIONS table.
FSI_D_ASSET, FSI_D_LIABILITY STRIKE_TYPE_CD The STRIKE_TYPE_CD column in the target table is updated with the values from the STRIKE_TYPE_CD column in the FSI_D_EMBEDDED_OPTIONS table.
FSI_D_ASSET, FSI_D_LIABILITY OPTION_TYPE_CD The OPTION_TYPE_CD column in the target table is updated with the values from the OPTION_TYPE_CD column in the FSI_D_EMBEDDED_OPTIONS table.
FSI_D_ASSET, FSI_D_LIABILITY OPTION_START_DATE The OPTION_START_DATE column in the target table is updated with the values from the OPTION_START_DATE column in the FSI_D_EMBEDDED_OPTIONS table.

FSI_D_ASSET, FSI_D_FEE_BASED_SERVICE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET

 ACCOUNT_TYPE ACCOUNT_TYPE is searched sequentially in the following tables and the value is updated.
  1. Product
  2. Common COA
  3. General Ledger

If ACCOUNT_TYPE is not present in any of the above mentioned tables, it is set to 100.

FSI_D_LIABILITY ACCOUNT_TYPE ACCOUNT_TYPE is searched sequentially in the following tables and the value is updated.
  1. Product
  2. Common COA
  3. General Ledger

If ACCOUNT_TYPE is not present in any of the above mentioned tables, it is set to 300.

FSI_D_DERIVATIVE ACCOUNT_TYPE For the given LEG_TYPE values, the following ACCOUNT_TYPE values are configured.
  • If LEG_TYPE is 1, set ACCOUNT_TYPE as 310
  • If LEG_TYPE is 2, set ACCOUNT_TYPE as 110
  • In all other cases, set ACCOUNT_TYPE as 800