Analysis: Tiered ECR Report

This DNAapp is used to find the current rate schedule for Commercial Analysis accounts based on their account level calculation variables and the application will change the rate schedule to a new one based on the average balance less the reserve.

The earnings credit assigned to each account will be based on the account's Average Collected Balance in Related Accounts at the time that the Analysis is run. In its current form the existing core batch job DP_Canly does not support different earnings credit rates by account based on balances (tiered rate structures). This new logic has been developed specifically for creating rate schedules to new schedules based on the average balance. It also returns all the information used to find the new rate schedule for reporting.

Benefits

• Application finds current rate schedule based on account level calculation variables
• Automatically change commercial account to a new rate schedule based on average account balance less the reserve