If you are uploading your data, you will require all the information below in a spreadsheet with header column names. To upload, each entry in your spreadsheet is required to be a separate row with no empty rows (below the header row). You can add multiple years in one upload if you have a column noting the year, where applicable. If not, you can manually add the year during upload (each year must be uploaded separately). Sample Documents are available in the samples section for your assistance in understanding requirements.
What you will need:
- Job Evaluation System: You can use/create any Point Table base Job Evaluation System / Tool that is able to measure all Job Classes in your organization on Skill, Responsibility, Effort and Working Conditions. You also have access to a predefined HCI Job Evaluation System if desired. Please see the FAQ/Help section for more information on creating a Job Evaluation System.
- Payroll Data: Minimum recommended 3 years of data (The Pay Equity Commission can ask for more especially if you plan shows adjustments). Included in Payroll Data for each year (year can align to your business cycle and does not have to be a calendar year):
- Unique Identifier
- Name (not required)
- Job Class ID (this is the key that ties all data together across all sections, if you do not have unique IDs for Job Classes, please create before uploading data)
- Job Class Title (see help on defining your job classes) (optional – but recommended)
- Hourly Base Rate
- Base Salary
- Actual Earnings during year
- Variable Pay (Actual Only - Target Variable Pay Should be entered in the Job Data section and should be the same for all employees in a job class)
- Actual Hours Worked
- Compensation (Job Class Related Data): Aligned with the Payroll data the Job Data section allows you to input compensation grid information and target variable compensation, including *note – all fields are optional and only employee data is required if Job Data does not exist:
- Job Class IDs (required – if any information below is being uploaded / inputted same as employee Job Class IDs)
- Job Class Title (optional)
- Highest Obtainable Job Rate for Job Class (if you organization has defined compensation grids which all employees in a Job Class have equal access you can enter this information here) in either:
- Target Variable Pay: (if all employees in a Job Class have the same target variable pay – generally Bonus or Commission you can enter this as an annualized number) – NOTE- if you have employees in the same Job with different Target Variable Pay or Commission Structure, these employees should be entered as separate Job Classes.
- Benefits: If all employees do not have equal access to Benefits this should be represented as a dollar value here for Job Classes with additional benefits. If employees in the same Job have different access to benefits they should be separate Job Classes
- Other Compensation: Any other compensation that is not equally accessible to all Job Classes can be entered here.
- Job Class Hours: If you have a job(s) that does not work that same amount of hours you can enter this information here. For example, office staff vs plant staff.
- Gender Stereotype Data – As a default the HCI Compensation Tool uses National Occupation Classification Codes (NOC Codes) with the gender determination based on data for Ontario from 2016 Canadian Census. If you know the associated NOC Code or Title you can use the search functionality in the Compensation, otherwise we recommend using the Government of Canada website to determine NOC code. Note you are note required to use the NOC codes for stereotype and can use another source. HCI makes no warranties to validity of any chosen NOC codes or use of external data.
- Job Information Documentation – Documentation for each Job Class that can be used / was used to evaluate the Job Classes. Generally, Job Fact Sheets, Job Questionnaires or Job Descriptions are used for evaluation. Each document can be uploaded and associated to a Job Class and stored within the Compensation Tool
- Existing Job Evaluations - If you have existing evaluations associated to the Job Evaluation Tool Created/Uploaded in step one you can upload them directly in the Job Evaluation Section. Required:
- Job Class IDs (same as used in previous steps)
- Score for each Sub-Factor Scored
- New Job Evaluations: If you haven’t already completed your job evaluations or need to complete additional evaluation, all the Job Classes created in Step 2 or 3 will be pre-populated in the evaluation section. The easiest way to evaluate Jobs is using the Job Evaluation Wizard.
Once Evaluations are complete, ensure you have set your incumbent year correctly in the Project Management section and have added standard project hours. Continue on to the Banding and Pay Equity section and either create a banding scenario or choose to find an optimized Banding Scenario and perform a Pay Equity Analysis to develop your Pay Equity Plan. Once Complete, all documents, including a Pay Equity Plan can be downloaded from the Project Management Section
More in depth information is available within the FAQ/Help section.