2.15.2 Migration with Historical Data

This topic provides information on the Migration with Historical Data.

In this approach, all historical event details from the legacy system are migrated to the new system. Key aspects include:
  • Original account opening dates and maturity dates will be preserved.
  • Interest rates will be carried forward from the legacy system.
  • The interest start date will be the later of the account opening date or the last rollover date.
  • Deposits will be created with original deposit amount.
  • Historical event data is expected to be provided in a predefined format via a staging file.
  • Depending on the availability of historical data from the legacy system, this approach is categorized as follows:
    • Deposit History and Interest Liquidation available
Deposit History and Interest Liquidation Available.
  • With this approach, all the deposit events will be migrated from old system.
  • Interest liquidation details will be migrated up to the last liquidation date.
  • Accounting entries up to the last liquidation date will be migrated; corresponding IC, TD, and balance tables will be updated.
  • Any deposit events occurring after the last liquidation date will also be migrated.
  • Post-migration, the new system will recalculate interest and accruals for the current cycle through EOD processing.

Below is the Sample Data for History scenario.

Table 2-18 Sample Data

49EA…32CD SB2002…~SB2 MIG0001 SB2 SB200222000 6-13-2019 DEBK 10000 SB200222000 134000067 TD-PRINC 1 2
49EA…32CD SB2002…~SB2 MIG0001 SB2 SB200222000 7-1-2019 LIQD_INT 1.92 SB200222000 134000067 ILIQ 1 2
49EA…32CD SB2002…~SB2 MIG0001 SB2 SB200222000 7-1-2019 LIQD_TAX 0.76 134000067 SB200222000 TAX 1 2
49EA…32CD SB2002…~SB2 MIG0001 SB2 SB200222000 7-2-2019 LIQD_INT 1.92 SB200222000 134000067 ILIQ 1 2
49EA…32CD SB2002…~SB2 MIG0001 SB2 SB200222000 7-2-2019 LIQD_TAX 0.76 134000067 SB200222000 TAX 1 2

Calculation and Data Population Details.

Next Accrual and Liquidation Dates:

The next accrual date and next liquidation date are determined based on the product configuration and the last liquidation date for the account.

IC Details Table Population:

Additional IC-related tables are populated using event information and details extracted from the staging table.

Event History Data Mapping:

Historical data is used to populate the tdtb_Event_Details table, ensuring all events are accurately captured.

Balance Calculation:

Account balance is calculated incrementally by processing each event. Additions and subtractions are applied based on the event type to update the current balance accordingly. Only applicable for History scenario as Backdated will not have the required data.

Business Product Population:

The business product populated is always the current product associated with the account. Historical product lineage is not maintained or supported.

Populated IC Tables

The following IC-related tables are populated during the process:

Ictb_acc_pr:

This table is filled using product details, account information from the staging data, and product configuration. The next accrual and liquidation dates are calculated based on the last liquidation date and product setup.

Ictb_Entries:

Entries for the current cycle are populated in this table, reflecting the latest interest and charge transactions.

Tdtb_event_details:

This table is populated based on event information from the staging data, recording a detailed log of all significant account events.

Ictb_entries_history, ictb_entries_history_accr, rdep_pp_event_entries:

These tables are built using historical data and event types, recording detailed transaction histories and accruals.

Ictm_td_details, rdep_pp_depcust_details, ictm_tdpayin_details, ictm_tdpayout_details:

Additional tables capturing term deposit details and related customer or transaction specifics.

Technical Data Flow in IC Tables

Historical data is aggregated to compute totals for top-up, redemption, liquidation, initial deposit, penalty, tax, and creation events, along with running balances.

Interest Accrual: Calculated from events of type LIQD_INT with amount tag ILIQ.

Tax Amount: Calculated from events of type LIQD_TAX with amount tag TAX.

Penalty Amount: Calculated from events of type LIQD_PEN with amount tag PENALTY.

Balance Calculation Strategies:

Backdated Case:

The current principal balance amount is used directly and updated in the balance table.

Historical Case:

For capitalized certificates of deposit (CDs), the current balance is updated with all liquidation amounts up to the last liquidation date.

For non-capitalized CDs, the current balance is calculated without including the liquidation amounts.

Handling Account Open Dates:

If the account is a rollover account, the open date is set to the last rollover date.

If the account is set to close on maturity, the account open date provided in the staging table is used.

Parent topic: Migration Strategy