The Pay Transparency Report process generates the pay gap analysis between identified genders within the payrolls. Gender information used in this analysis must be voluntarily provided by employees. If an employee chooses not to provide their gender information for the purpose of preparing the pay gap report, their pay information will still be used to prepare the report and their gender will be marked as unknown.
The number of employees as of January 1, and this date will be extracted from the starting pay period entered from the payroll which the report is run from, is reported as within one of the following ranges:
-
50 to 299 employees
-
300 to 999 employees
-
1000 or more employees
The comparison report is generated as an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined.
Enter NAICS (North American Industry Classification)
Enter the NAICS Code for the Education Services which is 61
NB: This will be the default entry and you can press Enter to continue
The Pay Transparency Report Selection Screen will open with the Payroll ID field populated with all the available payrolls.
For each payroll:
Enter Start Pay Period
Enter the starting pay period for inclusion in the report selection
Enter End Pay Period
Enter the ending pay period for inclusion in the report selection
Enter Excluded Salary Pay Codes
Enter the regular salary pay codes to be excluded from reporting, separated by commas
Any pay codes listed in the Overtime Pay Code and Bonus Pay Code fields are automatically excluded.
Note: These pay codes will NOT be reported
Enter Overtime Pay Codes
Enter the overtime pay codes to be reported, separated by commas
Enter Bonus Pay Codes
Enter the bonus pay codes to be reported, separated by commas
The export will detail the comparison reports as required by the province and will also contain the raw data below with the information contained in the report below.
The report lists the following:
Employee number
Employee name
Employee’s identified gender
Regular Salary
-
Total Pay for the year
-
Total Hours for the year
-
Salary Rate (dollars per hour)
Overtime Pay
-
Total Overtime Pay for the year
-
Total Overtime Hours for the year
-
Overtime Rate (dollars per hour)
Bonus Pay
-
Total Bonus Pay for the year
-
Total Bonus Hours for the year
-
Bonus Rate (dollars per hour)