Ontario Bill 124 Retro Changes Process Overview

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. 

**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.