I External Break Process Flow

Breaks Event Data Loaded from External Source Systems

The following approach is recommended when break data is provided by third party source systems and loaded via standard ETL. This is an alternative and possibly a complementary approach to using the FTP Break Identification Process.

Data Flow

• Current period data is moved from staging tables to break funding charges table.
• Prior period data is moved from instrument tables to break funding charges table.

Assumptions: Source systems need to provide information related to breaks in the following fields:

1. Loans:
   • Prepayment Indicator – column to indicate if a prepayment has happened in the current period.
   • Closed Indicator – column to indicate if an account is closed in the current period.
   • Ending Principal Balance – column to store the outstanding principal balance.
   • Prepayment Amount – column to store the amount that is pre-paid in case of partial or full pre-payment.
   • Restructured Indicator – column to indicate if the account is restructured.
2. Term Deposits:
   • Early Redemption indicator – column to indicate if the account is redeemed early.
   • Redeemed amount – column to indicate that is redeemed in the current period.
   • Closed indicator – column to indicate if the account is closed in the current period.
   • Ending balance – column to store the ending balance of the account.