Table 281-0027 4151618
Survey of Employment, Payrolls and Hours (SEPH), average weekly earnings by type of employee, overtime status and detailed North American Industry Classification System (NAICS)
annual (current dollars)


Data table

The data below is a part of CANSIM table  281-0027.  Use the  Add/Remove data  tab to customize your table.

Selected items [Add/Remove data]
Geography = Canada
Type of employees = All employees 19
Overtime = Including overtime
by North American Industry Classification System (NAICS); Geography= Canada; Type of employees= All employees; Overtime= Including overtime
Survey of Employment, Payrolls and Hours (SEPH), average weekly earnings by type of employee, overtime status and detailed North American Industry Classification System (NAICS), annual (current dollars)
North American Industry Classification System (NAICS) 18 2012 2013 2014 2015 2016
footnotes
Industrial aggregate excluding unclassified businesses [11-91N] 56 895.58A 911.45A 935.58A 952.24A 956.50A
Goods producing industries [11-33N] 7 1,143.25A 1,173.32A 1,217.28A 1,221.80A 1,225.52A
Forestry, logging and support [11N] 8 993.40A 1,047.07A 1,040.46A 1,103.57A 1,108.87A
Mining, quarrying, and oil and gas extraction [21] 1,846.36A 1,879.33A 2,048.30A 1,985.31A 2,039.11A
Utilities [22221] 1,641.14A 1,652.08A 1,775.57A 1,790.22A 1,737.42A
Construction [23] 1,136.64A 1,187.73A 1,225.04A 1,213.35A 1,217.39A
Manufacturing [31-33] 1,007.74A 1,023.38A 1,043.92A 1,078.86A 1,088.88A
Service producing industries [41-91N] 11 838.55A 851.37A 871.36A 891.73A 897.85A
Trade [41-45N] 12 678.32A 684.84A 705.02A 726.72A 730.10A
Transportation and warehousing [48-49] 928.91A 969.38A 1,003.58A 1,032.41A 1,014.86A
Information and cultural industries [51] 1,122.89A 1,134.71A 1,166.94A 1,211.85A 1,305.32A
Finance and insurance [52] 1,092.38A 1,111.86A 1,166.86A 1,210.18A 1,260.10A
Real estate and rental and leasing [53] 861.87A 868.48A 932.36A 939.44A 968.57A
Professional, scientific and technical services [54541] 1,244.50A 1,273.90A 1,307.73A 1,335.70A 1,316.86A
Management of companies and enterprises [55551] 1,218.97A 1,255.05A 1,336.98A 1,414.15A 1,437.87A
Administrative and support, waste management and remediation services [56] 729.03A 749.44A 751.33A 774.13A 783.16A
Educational services [61611] 981.93A 987.37A 982.78A 1,005.51A 1,016.49A
Health care and social assistance [62] 817.11A 833.75A 853.82A 868.41A 866.43A
Arts, entertainment and recreation [71] 543.24A 562.61A 581.19A 571.07A 585.99A
Accommodation and food services [72] 368.12A 362.38A 371.36A 374.77A 370.70A
Other services (except public administration) [81] 732.98A 751.61A 755.53A 771.09A 787.00A
Public administration [91] 1,151.88A 1,176.58A 1,199.93A 1,225.82A 1,232.49A

Footnotes:

Although the creation of Nunavut officially took place in April 1999, the Survey of Employment, Payrolls and Hours (SEPH) was only able to begin publishing separate estimates for Northwest Territories and Nunavut with the release of the January 2001 data. Efforts were undertaken to estimate the employment for Nunavut back to April 1999. These are available upon request by contacting Client Services at 1-866-873-8788 (toll-free) or 613-951-4090 (labour@statcan.gc.ca).
Since January 2001, the Survey of Employment, Payrolls and Hours (SEPH) program no longer combines Northwest Territories and Nunavut. They are produced as two separate territories.
These terminated series are based on the North American Industry Classification System (NAICS) 2002.
Data quality indicators are based on the coefficient of variation (CV). Quality indicators indicate the following: A - Excellent (CV from 0% to 4.99%); B - Very good (CV from 5% to 9.99%); C - Good (CV from 10% to 14.99%); D - Acceptable (CV from 15% to 24.99%); E - Use with caution (CV from 25% to 34.99%); F - Too unreliable to publish (CV greater than or equal to 35% or sample size is too small to produce reliable estimates).
Industrial aggregate covers all industrial sectors except those primarily involved in agriculture, fishing and trapping, private household services, religious organisations and the military personnel of the defence services.
Unclassified businesses (00) are businesses for which the industrial classification (North American Industry Classification System [NAICS] 2012) has yet to be determined.
Goods producing industries (11-33N) includes the following sectors: forestry, logging and support (11N), mining, quarrying, and oil and gas extraction (21), utilities (22), construction (23) and manufacturing (31-33).
Forestry, logging and support (11N) includes the following industries: forestry and logging (113) and support activities to forestry (1153).
Non-durable goods (311N) of the manufacturing sector includes the following industries: food manufacturing (311), beverage and tobacco products manufacturing (312), textiles mills (313), textile products mills (314), clothing manufacturing (315), leather and allied products manufacturing (316), paper manufacturing (322), printing and related support activities (323), petroleum and coal products manufacturing (324), chemical manufacturing (325) and plastics and rubber products manufacturing (326).
Durable goods (321N) of the manufacturing sector includes the following industries: wood products manufacturing (321), non-metallic mineral products manufacturing (327), primary metal manufacturing (331), fabricated metal products manufacturing (332), machinery manufacturing (333), computer and electronic products manufacturing (334), electrical equipment, appliances and components manufacturing (335), transportation equipment manufacturing (336), furniture and related product manufacturing (337) and miscellaneous manufacturing (339).
Service producing industries (41-91N) includes the following industries: trade (41-45N), transportation and warehousing (48-49), information and cultural industries (51), finance and insurance (52), real estate and rental and leasing (53), professional, scientific and technical services (54), management of companies and enterprises (55), administrative and support, waste management and remediation services (56), educational services (61), health care and social assistance (62), arts, entertainment and recreation (71), accommodation and food services (72), other services (except public administration) (81) and public administration (91).
Trade (41-45N) industry includes the following sectors: wholesale (41) and retail trade (44-45).
Education special (611N) industry includes the following industries: elementary and secondary schools (6111), community colleges and CEGEP (6112), universities (6113), business schools and computer management training (6114) and technical and trade schools (6115).
The introduction of administrative data in 2001 and the associated change in methodology resulted in level shifts for some series. This affects the comparability of pre- and post-2001 estimates.
Earnings data are based on gross payroll before source deductions.
These terminated series are based on the North American Industry Classification System (NAICS) 2007.
Industry estimates in this table are based on the 2012 North American Industry Classification System (NAICS).
"All employees" is the sum of employees paid by the hour, salaried employees and other employees.

Source:  Statistics Canada. Table  281-0027 -  Survey of Employment, Payrolls and Hours (SEPH), average weekly earnings by type of employee, overtime status and detailed North American Industry Classification System (NAICS), annual (current dollars),  CANSIM (database). (accessed: )
Back to search

Add/Remove data

Select the specific items from each step to create your customized CANSIM table.

Step 1- Select: Geography  

(1 of 14 items selected)
D1-picklist-container

Step 2- Select: Type of employees  

(1 of 3 items selected)
D2-picklist-container

Step 3- Select: Overtime  

(1 of 2 items selected)
D3-picklist-container

Step 4- Select: North American Industry Classification System (NAICS) 18  

(22 of 391 items selected)
D4-picklist-container

Step 5 - Select the time frame

By default, only data for the most recent periods available will be retrieved. You may use the lists below to select a different time frame.
From :  To : (Annual data)

Step 6 - Select the Screen output format






Step 7

 

Download

Select an option to download data in the desired format.

Option 1 - Download data as displayed in the Data table tab
 

 

 




Option 2 - Download entire table
(Files modified on 2017-03-31)



Data table will contain:
Note: 
Statistics Canada assumes responsibility for the quality of data as retrieved with the frequency unchanged. Clients take responsibility for any manipulations made to the original data.
Frequency of data is already of annual frequency or greater, therefore no frequency conversion options are presented.
View additional information related to this table.

Related data tables
Wages, salaries and other earnings 
Industries
Display list of  Summary tables derived from this table.

Related publications
View list of related publications.

Additional information on the survey or statistical program


Help

Data table

When first opening a CANSIM table, the data that is shown is considered the initial view. Depending on the size of the CANSIM table, this table might only represent a summary with five reference periods, if available. You can use the Add/Remove data tab to add or remove data.

To download the entire table, select option 2 in the Download tab.

Add/Remove data

The Add/Remove data tab is a pick list where you choose which subset of the selected table you want to work with. There is one scrollable pick list for each dimension in the table and you must select at least one item from each list before selecting Apply.

An All checkbox appears under each dimension title and just above the scrollable list. Level checkboxes will appear for dimensions containing hierarchies. An Expand/Collapse option is available near the scrollable list which lets you open a dimension to see the list of its members/items.

Before proceeding with the request, check the data ranges for which data is available and reduce this range if you wish; data retrievals are faster when the time period is short. Also, you can select one of four options of a screen output format, default being HTML table, times as column.

Once done with your selections, select Apply to view your customized selection, or select Back to original table to return the selections back to the CANSIM initial view that was shown when first opening the table.

Note: There is no guarantee that data exist for every intersection of every dimension; so it is possible that even if you have selected at least one member/item from all the lists you might still be warned that your retrieval contains no series.

Note: If the designation (Terminated) appears at the end of a member/item name that member/item is terminated. Time series attached to a terminated member/item may be revised, but are no longer updated and may not contain data for the most recent time periods.

Tips for selecting members/items:

  • You can select all members/items in a hierarchical level by selecting the corresponding level.

Note: If you receive an error message after selecting your members from the pick list it's either because your request does not contain series or one member/item has not been selected from a dimension.

Manipulate

Statistics Canada assumes responsibility for the quality of data as retrieved with the frequency unchanged. Clients take responsibility for any manipulations made to the original data.

Frequency of output data will be:

The frequency conversion options are particularly useful to convert data from one frequency to another for comparability purposes.

Note: When frequency of data is already of annual frequency or greater, then no frequency conversion options are presented. Certain series can only be aggregated by specific methods. If the frequency conversion chosen is not allowed, resultant data will appear as "..".

Converted to:

The frequency designates how often data observations are published. A table can contain only one frequency. By default, the frequency of output data will be left unchanged.

Frequency can be converted by these choices:

  • Annual average: Conversion by averaging is more appropriate for "balance"-type data such as "Population as of July 1" as well as rates and indexes.
  • Annual sum: Conversion to a sum should not be performed on a rate or index. Conversion by summing is more appropriate for "count"-type data, such as "Number of cars sold" or "Number of births".
  • Quarterly average: Conversion by averaging is more appropriate for "balance"-type data such as "Population as of July 1" as well as rates and indexes.)
  • Quarterly sum: Conversion by summing is more appropriate for "count"-type data, such as "Number of cars sold" or "Number of births".
  • Annual - convert to annual by selecting a specific month or quarter: This type of calculation is most useful when data for a specific sub-annual period (month or quarter) is used to state an annual figure such as "Population as of July 1".

When converting frequency by summing or averaging:

Two choices are offered when converting frequency using either a sum or an average:

  • Use calendar year: This is a normal calendar year starting in January and ending in December.
  • Use fiscal year ending with last month retrieved: The annual non-calendar fiscal year average manipulation permits users to calculate the average value for the last twelve months ending with the most recent reference period selected. In order to complete this calculation, please follow these steps:
    • In the section entitled "Frequency of output data will be:" sub-section "Standard frequency conversion options" select "Annual (average)".
    • In the section "When converting frequency by summing or averaging:" select "Use fiscal year ending with last month retrieved".
    • If you wish the output of your data as a percentage change from the previous year please select "Percent changes, year-to-year" found below "Data table will contain:"

Data table will contain:

Select one of these data transformations options to convert your data:

  • Percent changes, period-over-period: If the frequency of the data is monthly, the calculation would measure the change of the data value in percent between consecutive time periods, (for example: between July 1998 and August 1998.)
  • Percent changes, year-over-year: If the frequency of the data is monthly, the calculation would measure the change of the data value in percent between consecutive years, (for example: between July 1998 and July 1999).
  • Year-to-date sums: Data for each sub-annual period is added consecutively to the previous period showing cumulative sums for each period.
  • Year-to-date average: Data for each sub-annual period is averaged consecutively to the previous period showing cumulative averages for each period.

Note: CANSIM rounds data using statistician's rounding (also known as round-to-even method, unbiased rounding, convergent rounding and banker's rounding) which may differ from rounding methods used by common spreadsheet software.

Statistician's rounding rounds the following way:

  • If the second decimal is larger than 5, the first decimal is incremented by 1 (see example 1).
  • If the second decimal is smaller than 5, the first decimal stays unchanged (see example 2).
  • When the second decimal is exactly 5, the "odd/even" rules apply. The first decimal is incremented by 1 if it is odd (see example 4), and left unchanged if it is even (see example 3).
  • Example:
    1. 4.46 rounded to one decimal equals 4.5
    2. 4.44 rounded to one decimal equals 4.4
    3. 4.45 rounded to one decimal equals 4.4
    4. 4.15 rounded to one decimal equals 4.2

Once you made your selections select the Apply button.

Download

Option 1 - Download data as displayed in the Data table tab

This option downloads your selection and is displayed in the Data table tab or you can modify using the download options.

Three download options are available:

  • Select the language: You have the choice of the English or French language for the textual content.
  • Select the data output format type: You have the choice of the following six format types:
    • time as columns, where the time frame you have selected will be displayed in columns
    • time as rows, where the time frame you have selected will be displayed in rows.
    • for database loading, where you will download a flat format file ready for database loading
    • for database loading with data quality indicators, where you will download a flat format file including data quality indicators
    • time as columns with data quality indicators, where the time frame you have selected will be displayed in columns including data quality indicators
    • time as rows with data quality indicators, where the time frame you have selected will be displayed in rows including data quality indicators
  • Select the file format: you will have the choice of the following two output separator types:
    • CSV (comma-separated values) English spreadsheet is usually used when retrieving English tables with computers having their Regional set to English.

If your objective is to load the data into a spreadsheet package the best choice for output format is a comma-separated values (CSV) file.

Note: CSV and Semicolon-Separated Values (SCSV) files are produced differently whether you perform the retrieval in English or French. This is because, in French, the comma is used to indicate decimals; a different separator (a semicolon) must therefore be used. SCSV files retrieved in French will parse correctly only if the Regional Settings are set to French.

Once you made your selections select the Download data button.

Option 2 - Download entire table

You will have the option to Download entire table as a CSV file or a Beyond 20/20 or SDMX file which will open a new window.

This table represents all of the items in the CANSIM table. To get an initial view (summary) of the CANSIM table, select the Data table tab.

Note: Downloading tables in Beyond 20/20 output format requires the Beyond 20/20 Table Browser.

Once you made your selections select the Download entire table button.

Related information

This page contains links to items related to your CANSIM table. Select the various links to view these related items.

Related data tables

View a list of related CANSIM tables that are related to this CANSIM table.

Related publications

View the latest article from The Daily and a list of related publications from Statistics Canada.

The Daily is Statistics Canada's official release bulletin, the Agency's first line of communication with the media and the public. The Daily issues news releases on current social and economic conditions and announces new products. It provides a comprehensive one-stop overview of new information available from Statistics Canada.

Additional information on the survey or statistical program

Definitions, data sources and methods: Here is where you will find a link to the Integrated Meta Data Base (IMDB) where you may view details for the survey number(s) assigned to the CANSIM table.

The Integrated Meta Data Base (IMDB) contains information about the surveys and statistical programs carried out by Statistics Canada and other agencies to collect assemble process and disseminate statistical information.

The IMDB may be used to find out how data for particular CANSIM tables are collected or to identify contacts for questions on the data or survey methodology. The IMDB contains descriptions of over 450 surveys and statistical programs each identified by a unique four-digit survey number.

After selecting a survey or a program from the list, you may choose to either retrieve the list of CANSIM tables for that survey or program, or consult the IMDB for more information.