J Creating and Executing T2T Processes

The following are the T2T definitions which move data from the staging table(s) to the Break Funding table when Breaks data is available from Source Systems.

• Full Breaks and Partial Breaks:
  • T2T_BROKEN_ACCOUNT_LOANS_FP
  • T2T_BROKEN_ACCOUNT_TD_FP
• Restructuring Accounts:
  • T2T_BROKEN_ACCOUNT_LOANS_R
  • T2T_BROKEN_ACCOUNT_TD_R
• For moving prior period records for Partial and Restructured accounts: The following T2T's will be used for moving prior records into the Break Funding table for Partial Break and Restructuring of accounts.
  • T2T_LOAN_PAR_RESTRUCTURED
  • T2T_MORTGAGES_PAR_RESTRUCTURED
  • T2T_TD_PAR_RESTRUCTURED

For executing these T2T's, follow these steps:

1. Create a batch.
2. Add the relevant tasks to the newly created batch.
3. Add the Transform Data task for updating the Process Run History table.
   The T2T_Process_Update procedure will insert/update the Last Execution Date in the Process Run History table which will be used in the next T2T for fetching prior period AS_OF_DATE.

   • T2T_LOAN_PAR_RESTRUCTURED
   • T2T_MORTGAGES_PAR_RESTRUCTURED
   • T2T_TD_PAR_RESTRUCTURED
4. Execute the new batch process from the Batch Execution screen.