Ontario Bill 124 Retro Changes Process Overview
GOAL: To provide a wholistic overview of the necessary changes and process review for inputting retro salary grid changes for Ontario Bill 124.
ISSUE: Ontario Bill 124 - The union says wage rates in the 2022-2026 collective agreements will also be increased and wage hikes will be pensionable. The 2019 law, Bill 124, capped salary increases for public sector workers to one per cent a year for three years.
Note: Ensure DB is patched to P46v2 to account for Entitlement Year Cap fix.
IMPORTANT NOTE: It has been determined that configuring Adjust Indicator = N under Salary and Allowance Update, and actually using the traditional Pay Run Menu > Entitlement process provides meaningful gains in efficiency.
The Pay Process > Entitlement engine can run much more efficient and therefore keep the run time significantly lower for the process, allowing boards to process the change faster.
Process Overview
BOARD CONTROL > GENERAL TABLES > SITE CONFIGURATION
**Update ‘Entitlement Year Cap’ = 9 Years**
select ENTITLEMENT_YEAR_CAP, * from EC_CONFIGURATION
BOARD CONTROL > COMPENSATION > SALARY GRIDS > EMP_GROUP
SALARY GRIDS TABLE
select * from EC_GRID_STEPS_SALARY
where EMP_GROUP_CODE = 'EMP_GROUP'
and GRID_CATEGORY_CODE in ('xxxxxxx')
and GRID_START_DATE >= '2019-09-01'
**Current Salary Grids will be deleted from 2019/09/01 to Present**
IMPORTANT NOTE: Users must delete all 5 years of Salary Grids at once to avoid error in the system when re-inputting the Grids.
BOARD CONTROL > COMPENSATION > GROUP ALLOWANCES & GRIDS > EMP_GROUP
ALLOWANCE GRIDS TABLE
select * from EC_GRID_STEPS_ALLOWANCE
where EMP_GROUP_CODE = 'EMP_GROUP'
and ALLOWANCE_CODE in ('xxxxxx')
and GRID_START_DATE >= '2019-09-01'
**Current Allowance Grids will be deleted from 2019/09/01 to Present**
CREATE NEW SALARY & ALLOWANCE GRIDS:
select * from EC_GRID_STEPS_SALARY
where EMP_GROUP_CODE = 'EMP_GROUP'
and GRID_CATEGORY_CODE in ('xxxxxxx')
and GRID_START_DATE >= '2019-09-01'
**Created all New Salary Grids from Year 2019 to 2023**
select * from EC_GRID_STEPS_ALLOWANCE
where EMP_GROUP_CODE = 'EMP_GROUP'
and ALLOWANCE_CODE in ('xxxxxx')
and GRID_START_DATE >= '2019-09-01'
**Created all New Allowance Grids from Year 2019 to 2023**
BOARD CONTROL > COMPENSATION > SALARY AND ALLOWANCE UPDATE
NOTE: Users must process 1 Year at a time when completing Sal/Allow Updates.
EXAMPLE: 2019 Sal/Allow Update + Entitlement > 2020 Sal/Allow Update + Entitlement > 2021 > 2022 > etc.
**Run the process for EMP_GROUP & Year Start = 2019/09/01 in Run Mode = Trial > Update**
IMPORTANT NOTE: It has been determined that configuring Adjust Indicator = N under Salary and Allowance Update, and actually using the traditional Pay Run Menu > Entitlement process provides meaningful gains in efficiency.
The Pay Process > Entitlement engine can run much more efficient and therefore keep the run time significantly lower for the process, allowing boards to process the change faster.
IMPORTANT NOTE: When entering Grid Effective Date of (Example: 2019/09/01). This will produce entitlement from year 2019 all the way to Current, however the adjustment will only be for the single year (2019/09/01 - 2020/08/31).
- Year 2020 - 2024 will be without adjustment in this case. It is only the first year that the adjustment is present for.
This process is repeated for the next year 2020/09/01, Entitlements will generate again, and the system will complete the next year worth of adjustment.
- Rinse and repeat for all of the appropriate years.
NOTE: If Adjust Indicator is not set to Yes, then Entitlement will have to be run separately.
If Adjust Indicator = Yes then Entitlements are generated within this process and the report will populate under Process > Completed > Reports along with the Salary and Allowance Adjustments.
EMPLOYEE SALARY & ALLOWANCE UPDATE REPORT
**Salary Record has been updated and reflects new rate**
ENTITLEMENT REPORT
**View 2019 Increase for EMP_GROUP**
EMPLOYEE SALARY TABLE
select EMPLOYEE_ID, EMP_GROUP_CODE, JOB_CODE, SALARY_START_DATE, SALARY_END_DATE, SALARY_CATEGORY_CODE, GRID_EFFECTIVE_DATE, COMPENSATION_RATE, * from EC_EMPLOYEE_SALARY
where EMPLOYEE_ID = 'xxxxx'
and EMP_GROUP_CODE = 'EMP_GROUP'
and SALARY_START_DATE = '2019-09-01'
**View Year = 2019 Increase**
---------------------------------------------------------------------------------------------------------------------------
BOARD CONTROL > COMPENSATION > SALARY AND ALLOWANCE UPDATE
**Run the process for EMP_GROUP & Year = 2020 in Run Mode = Trial > Update **
EMPLOYEE SALARY & ALLOWANCE UPDATE REPORT
**Salary Record has been updated and reflects new rate**
ENTITLEMENT REPORT
**View 2020 Increase for EMP_GROUP**
EMPLOYEE SALARY TABLE
select EMPLOYEE_ID, EMP_GROUP_CODE, JOB_CODE, SALARY_START_DATE, SALARY_END_DATE, SALARY_CATEGORY_CODE, GRID_EFFECTIVE_DATE, COMPENSATION_RATE, * from EC_EMPLOYEE_SALARY
where EMPLOYEE_ID = 'xxxxx'
and EMP_GROUP_CODE = 'EMP_GROUP'
and SALARY_START_DATE = '2020-09-01'
**View Year = 2020 Increase**
--------------------------------------------------------------------------------------------------------------------------------
BOARD CONTROL > COMPENSATION > SALARY AND ALLOWANCE UPDATE
**Run the process for EMP_GROUP & Year = 2021 in Run Mode = Trial > Update **
EMPLOYEE SALARY & ALLOWANCE UPDATE REPORT
**Salary Record has been updated and reflects new rate**
ENTITLEMENT REPORT
**View 2021 Increase for EMP_GROUP**
EMPLOYEE SALARY TABLE
select EMPLOYEE_ID, EMP_GROUP_CODE, JOB_CODE, SALARY_START_DATE, SALARY_END_DATE, SALARY_CATEGORY_CODE, GRID_EFFECTIVE_DATE, COMPENSATION_RATE, * from EC_EMPLOYEE_SALARY
where EMPLOYEE_ID = 'xxxxx'
and EMP_GROUP_CODE = 'EMP_GROUP'
and SALARY_START_DATE = '2021-09-01'
**View Year = 2021 Increase**
NEXT STEPS: Rinse and repeat the above process for Year 2022 and 2023.