Employment Equity Regulations – Reporting salary – IPG-107

On this page

Subject

Reporting salary under the Legislated Employment Equity Program (LEEP).

Issue

Employers subject to LEEP must report salary ranges and pay gap information using specific salary information. The following guidelines show how to use salary information to calculate annual salaries and pay gap information.

Background

The LEEP covers federally regulated private-sector employers, including Crown corporations and other federal organizations, that are subject to the Employment Equity Act (the Act).

The Employment Equity Regulations (the Regulations) require LEEP employers to include pay gap and salary information, in their annual employment equity reports due by June 1.

Policy

Employers must report the following information in Form 2 Parts A-G:

Employers must use the following elements to identify salary ranges and pay gap information:

Employers should report the following pay gaps as the percentage differences between 2 groups of employees:

The percentages reported should be rounded to the closest decimal place, for each of the following:

Overtime hours gaps are expressed as differences in number of hours, rather than percentages.

The subject and comparison groups for which pay gap information is calculated are set out in Form 2 Parts D-G. The groups compared are:

Important information

The Workplace Equity Information Management System (WEIMS) automatically performs the calculations for:

Definitions

Salary

Salary means remuneration paid for work performed, before deductions, in the form of:

Additional information has been published to clarify what employers must include as salary for their annual employment equity reports.

Employment Equity Regulations – Definitions and interpretations for reporting salary – IPG-106

Important information

When completing any part of Form 2 Parts A-G, employers must not include “bonus pay” and “overtime pay” in the annual salary and hourly wage calculations, as they are used separately for employment equity reporting purposes.

Hours worked

The number of hours worked that can be attributed to the salary refers to the number of hours an employee is paid, including hours on paid leave and excluding overtime hours for which they received overtime pay.

Important information

For employees whose hours of work are not recorded, an alternative approach to identify a representative number of hours may be used, such as:

An employer may use an alternative approach only if they are not required under the Canada Labour Code, Part III (or other legislation) to keep a record of hours worked for an exempt class of employees (such as managers).  

In selecting an alternative approach, an employer should ensure that the approach provides a consistent and balanced representation of the employees’ hourly wage.

In addition, records of the calculations should be kept to provide to the Canadian Human Rights Commission in the event of a compliance audit.

Overtime hours

Overtime hours means the hours worked by an employee, in excess of the standard hours of work, for which the employee received overtime pay.

Period over which the salary is paid

The period over which the salary is paid refers to the number of full weeks – 2 being the minimum – at the end of which the salary was paid to the employee.

Important information

The salary paid is required to determine the annual salary and the hourly wage for each employee. This information is used to calculate and report salary ranges and hourly wage gaps. WEIMS performs this automatically, but for WEIMS to determine an annual salary or an hourly wage, employers should enter the salary paid:

Salary ranges

Reporting salary ranges in Form 2 Parts A-C requires the calculation of the employee’s annual salary, as of December 31. This is required for all permanent (full-time and part-time) employees that are employed as of December 31.

Temporary employees, as defined in the Regulations, must also be included:

Each employee’s annual salary is determined based on the information presented above and using the following formula:

annual salary = salary × (52 ÷ period over which salary is paid)

For example, if an employee is paid a salary of $3,200 every 2 weeks, as of December 31 of the reporting period, then that employee’s annual salary is $83,200 because 52 ÷ 2 (period over which salary is paid) = 26 and $3,200 (salary) x 26 = $83,200:

$83,200 = $3,200 × (52 ÷ 2)

Note that WEIMS automatically performs this calculation.

Pay gap information

Reporting pay gap information in Form 2 Parts D-G requires the calculation of:

These calculations must use the following information:

Note that WEIMS automatically performs these calculations.

Means and medians

The gaps reported in Form 2 Parts D-G use 2 ways to find the middle in a group of values: means and medians.

Mean

A mean is calculated by dividing the sum of a set of terms by the number of terms:

mean = sum of a set of terms ÷ number of terms

Example

To calculate the mean hourly wage for a group of women (see Step 1: Calculate the hourly wage of each employee), follow these 4 steps:

  1. identify the hourly wage of each woman:
    • Mary: $15 per hour
    • Fatima: $18 per hour
    • Rosa: $18 per hour
  2. add the hourly wages of these women:
    • $15 per hour + $18 per hour + $18 per hour = $51 per hour
  3. identify the number of women: 3 (Mary, Fatima, and Rosa)
  4. apply the formula for calculating a mean to the hourly wages of these women:
    • mean hourly wage = sum of hourly wages for all women ÷ number of women
    • mean hourly wage = $51 per hour ÷ 3
    • mean hourly wage = $17 per hour

In this example, the mean hourly wage of these women is $17 per hour.

Median

A median is calculated using the following steps:

  1. list all values in order from smallest to largest
  2. if there is an odd set of values, the median is the value in the middle. For example, if the hourly wage values are:
    • $14 per hour, $15 per hour, $16 per hour, $17 per hour, $18 per hour
    • The median value is $16 per hour
  3. if there is an even set of values, the median is the mean of the 2 middle values in the ranked order. For example, to calculate the median hourly wage of a group of four women:
    • identify the hourly wage of each woman:
      • Mary: $15 per hour
      • Fatima: $18 per hour
      • Rosa: $18 per hour
      • Olivia: $17 per hour
    • list these hourly wages in order from smallest to largest:
      • $15 per hour, $17 per hour, $18 per hour, $18 per hour
    • find the 2 middle values:
      • $17 per hour and $18 per hour (as 1 hourly wage is more or equal to these two values ($18 per hour) and 1 is less than them ($15 per hour))
    • calculate the mean hourly wage of these two middle values using the following formula:
      • mean hourly wage = sum of hourly wages for middle values ÷ number of middle values
      • mean hourly wage = ($17 per hour + $18 per hour) ÷ 2
      • mean hourly wage = $35 per hour ÷ 2
      • mean hourly wage = $17.5 per hour

Therefore, the median hourly wage for these 4 women is $17.5 per hour.

Hourly wage gaps

Reporting hourly wage gaps in Form 2 Parts D-G is a 2-step process.

Step 1: Calculate the hourly wage of each employee

The hourly wage is calculated using this formula:

hourly wage = salary ÷ number of hours

For example, if an employee is paid a salary of $1,600 every 2 weeks and this employee works 80 hours every 2 weeks, then that employee’s hourly wage is $20 per hour because $1,600 ÷ 80 hours = $20 per hour.

Step 2: Calculate the hourly wage gaps

Once the hourly wages of all employees have been determined, hourly wage gaps are calculated using these formulas, where:

mean hourly wage gap (%) = (mean w for g1 - mean w for g2) ÷ mean w for g1 × 100

median hourly wage gap (%) = (median w for g1 - median w for g2) ÷ median w for g1 × 100

For example, calculate the hourly wage gaps between women and men as follows:

Where:

mean hourly wage gap (%) = ($20 per hour - $19 per hour) ÷ $20 per hour × 100 = 5%

And where:

median hourly wage gap (%) = ($18 per hour - $15 per hour) ÷ $18 per hour × 100 = 16.7%

Bonus pay gaps

Only include employees who received bonus pay in the reporting period in the bonus pay gap calculations.

Bonus pay gaps are calculated using these formulas, where:

mean bonus pay gap (%) = (mean b for g1 - mean b for g2) ÷ mean b for g1 × 100

median bonus pay gap (%) = (median b for g1 - median b for g2) ÷ median b for g1 × 100

For example, calculate the bonus pay gaps between Aboriginal peoples and non-Aboriginal peoples as follows:

Where:

mean bonus pay gap = ($10,000 - $2000) ÷ $10,000 × 100 = 80%

And where:

median bonus pay gap = ($8,000 - $500) ÷ $8,000 × 100 = 93.8%

Employers must also report the proportion of employees in each subject group as well as among men who received bonus pay in Form 2 Parts D-G. Proportions are calculated using this formula:

proportion of g with bonus pay (%) = number of employees in g with bonus pay ÷ number of employees in g × 100

Where:

For example, calculate the proportion of Aboriginal employees with bonus pay as follows:

Where:

proportion of Aboriginal employees with bonus pay (%) = 3 ÷ 5 × 100 = 60%

Overtime pay gaps

Only include employees who received overtime pay in the reporting period in the overtime pay gap calculations.

Overtime pay gaps are calculated using these formulas, where:

mean overtime pay gap (%) = (mean ot for g1 - mean ot for g2) ÷ mean ot for g1 × 100

median overtime pay gap (%) = (median ot for g1 - median ot for g2) ÷ median ot for g1 × 100

For example, calculate the overtime pay gaps between women with disabilities and all men as follows:

Where:

mean overtime pay gap = ($800 - $1,000) ÷ $800 × 100 = -25%

And where:

median overtime pay gap = ($1,200 - $1,000) ÷ $1,200 × 100 = 16.7%

Employers must also report the proportion of employees in each subject group as well as among men who received overtime pay in Form 2 Parts D-G. Proportions are calculated using this formula:

proportion of g with overtime pay (%) = number of employees in g with overtime pay ÷ number of employees in g × 100

Where:

For example, calculate the proportion of women with disabilities with overtime pay as follows:

Where:

proportion of women with disabilities with overtime pay (%) = 1 ÷ 4 × 100 = 25%

Important information

When calculating overtime pay gaps, only take into account overtime paid in the reporting period. This excludes overtime worked for which the employee is compensated with time in lieu or banked hours.

Overtime hours gaps

Only include employees who received overtime pay in the reporting period in the overtime hours gap calculations.

Overtime hours gaps are calculated using these formulas:

mean overtime hours gap (%) = mean h for g1 - mean h for g2

median overtime hours gap (%) = median h for g1 - median h for g2

Where:

For example, calculate the overtime hours gaps between visible minority women and non-visible minority women as follows:

Where:

mean overtime hours gap = 52 hours - 26 hours = 26 hours

And where:

median overtime hours gap = 60 hours - 38 hours = 22 hours

Important information

When calculating the overtime hours gaps, only take into account overtime hours for which pay was received in the reporting period. This excludes overtime worked for which the employee is compensated with time in lieu or banked hours.

Related links

Page details

Date modified: