User Guide for Personalized Electronic Reporting Questionnaire System (PERQS) – 2011 Annual Retail Trade Survey

Unified Enterprise Survey

5-3600-152.3: 2012-02-16

Personalized Electronic Reporting Questionnaire System (PERQS)

User Guide for Electronic Data Reporting

User Guide Contents

About PERQS
Tools needed to use PERQS
Accessing the 2011 version of PERQS for the first time
Decrypting the company data file
Opening PERQS
Completing Part A of the questionnaire
Completing Part B of the questionnaire
General information
Exporting and importing
Closing the questionnaire
Returning your company data to Statistics Canada via Internet
Accessing the e-File Transfer Service
Appendix A
Appendix B
Appendix C
Appendix D

PERQS – User guide for electronic data reporting

About PERQS

Welcome to Statistics Canada’s electronic data reporting system for the 2011 Annual Retail Trade Survey. This system, referred to as PERQS (Personalized Electronic Reporting Questionnaire System), is comprised of preloaded encrypted Excel spreadsheets stored on an electronic Statistics Canada vault. A tool allows you to decrypt the spreadsheets to get started, then the e-File Transfer Service allows you to securely send them back to Statistics Canada via the Internet (see page 13, Returning your Company Data to Statistics Canada).

Information from your previous year’s report: (business name(s), addresses, square footage, contacts, reporting period, etc.) has been pre-loaded into PERQS.

Also stored in the same Statistics Canada vault are guides to use PERQS; reporting guides for the questionnaire; a North American Industrial Classification System Guide and the decryption tool called ETUNPROT.exe.

Tools needed to use PERQS

PERQS was designed to run in a Windows 95 or higher environment and requires Microsoft Excel 97 or higher. If you do not have access to a PC with Windows installed on it, or if you do not have Microsoft Excel 97 or higher, you will not be able to use PERQS.

In order to read the Reporting Guide: 2011 Annual Retail Trade Survey and the NAICS (North American Industrial Classification System), you must install Adobe Acrobat reader. If you do not have Adobe reader installed, it is available as a download from www.adobe.com. You will also need access to the Internet.

You should have received a letter containing your password, a series of 9 randomly generated characters. This password is unique to each PERQS package and is needed to decrypt the PERQS company data file. If at any time you lose or forget your original password, please call our toll-free Help Line at 1-877-949-9492 for instructions or email - - SOS@statcan.gc.ca.

If you do not wish to have PERQS pre-loaded with information from your previous report, please advise us.

Thank you for taking the time to respond to the 2011 Annual Retail Trade Survey.

Note to users:

Please uninstall any previous versions of PERQS from your system before accessing the 2011 version of PERQS.

To uninstall previous PERQS versions from your PC’s hard drive:

1. From the Windows Start menu, select Settings;

2. In the Control Panel, select the Add/Remove Program icon;

3. Select STCDRF;

4. Click Remove.

Accessing the 2011 version of PERQS for the first time

1. From the Internet, go to URL http://www.statcan.gc.ca/ec-ce/eft-tef. Click the Logon button.

2. Enter the username that was provided by Statistics Canada.

3.Enter temporary password that was provided by Statistics Canada. Click the Logon button.

4. Your password will expire and an error message is displayed in red
(Error: ITATS203E Password has expired) and you will be prompted to enter a new one*.

5. Enter the new password.

6. Re-enter the new password to confirm.

7. You will see a list of safes.

8. Click on the safe of your choice.

9. To download files, click on FromStatcan-->Download, and then browse for the files you want to download to your computer. Please save the decryption file, ETUNPROT.exe, to your desktop. Please save the other files (especially the “.xls.enp” file) to a location of your choice (e.g. “C:\PERQSTemp\DownloadedFiles”).
Note: Some respondents may receive a security message asking if they want to run or save the etunprot.exe file. Please choose the SAVE option.

10. Logout.

* Password must be at least 8 characters with at least one capital letter and one digit.

Note: if you have a problem using the e-File Transfer service, please send an e-mail to the support team at: SOS@statcan.gc.ca.

Decrypting the company data file

1. After the PERQS excel (.xls.enp) file and the decryption program have been downloaded to your computer, execute the decryption file, ETUNPROT.exe, by double-clicking the icon on your desktop. This will cause the following window to appear (see Figure 1).

Figure 1

Figure 1 is an image of a screen entitled “Select a password-protected file”. The full title of the PERQS file that you have just downloaded appears on the screen. When you open the file (by clicking on “Open”) you will be asked to enter the password that was written on the letter that was sent to you in the mail.

2. Browse to the location that you downloaded the files to and select the file you have saved “your file name.xls.enp” then select the Open button.

3. You will then be prompted to enter a password (see Figure 2). This password was written on the letter that was sent to you in the mail.

Figure 2

Figure 2 asks you to enter that password.

4. You will then be prompted to save the data file to a location of your choice (see Figure 3).

Figure 3

Figure 3 asks you to save the PERQS file on your computer. Now you are ready to fill in your PERQS questionnaire. The reporting guide will give you more information and help to fill it in.

5. Fill in the questionnaire (see below for instructions). The Reporting Guide (found on the Statistics Canada electronic vault) can assist you in completing the questionnaire.

6. After completing the questionnaire, follow the Returning your company data to Statistics Canada via Internet instructions.

Opening PERQS

PERQS 2011 was developed using Microsoft Excel 97 and therefore requires that either Excel 97 or higher be installed on your PC.

When your customized questionnaire information on the company data file is decrypted, please locate it using Windows Explorer and double click on it (Excel should automatically open your questionnaire).

Alternatively, open Microsoft Excel, and go to File -> Open. Locate the questionnaire using the Excel browser. When the questionnaire is opened, the following message (Figure 4a) will appear:

Note: For users of Excel 2007, see Appendix D "Using Excel 2007 to open the questionnaire and use the macros".

Figure 4a

Figure 4a tells you that you should click on “Enable macros”.

Activate the user-friendly macros developed by Statistics Canada by clicking Enable Macros

Disabling macros will make it impossible to fill out the questionnaire. Instructions will appear on the screen, as shown in Figure 4b.

Figure 4b

Figure 4b contains instructions to open the questionnaire in various Excel versions.

You now have full access to PERQS which is made up of two Excel spreadsheets, identified as Part A and Part B. When the questionnaire is opened, Part A will be displayed. In the upper left hand corner you will see the title 2011 Annual Retail Trade Survey.

Completing Part A of the questionnaire

The questionnaire text in PERQS is black on a coloured background. The coloured boxes contain instructions, information and/or questions. The white boxes are reserved for your answers.

The easiest way to move through PERQS is to use the Tab key. It will take you from one white box to the next, from left to right and from top to bottom. This is the order in which you should answer the questions.

Shift +Tab enables you to go backwards. Using the Enter key is not recommended, as it does not allow you to go from one white area to the next; instead, the Enter key takes you to the cell below in the next row down.

Some white boxes may contain information collected in previous years. Please verify the information and make the necessary corrections. To change it, please overwrite the content of the cell by entering the corrections.

You will also see several additional buttons displayed on the menu (see Figure 4c). Go to Part B will move your cursor to the second Excel spreadsheet, entitled Part B. Save and Close closes the application (see Closing the questionnaire on page 12). Save saves the current session on your hard disk. Next Error moves your cursor to the next cell in error.

Note: For users of Excel 2007, see Appendix D "Finding additional buttons when accessing Part A and Part B of the questionnaire".

Figure 4c

Figure 4c is an image of four computer buttons: go to Part B, Close, Save and Next Error.

Some cells may contain a small red triangle in the upper right hand corner. When you point your cursor over this red triangle, a dialog box containing additional information about this cell will appear (see Figure 5).

Figure 5

Figure 5 is an image that contains blank spaces for some information you might have missed. When you move the curser on these spaces, the computer will let you know which one you have missed.

If PERQS assesses that the information collected is erroneous, the cell turns red. When you move your cursor over it, a dialog box containing the information of the erroneous cell will be posted (see General Information section).

You will have the option of coming back later by clicking the Next Error button at the top of the worksheet. Next Error will allow you to navigate between all the possibly erroneous cells in Part A.

You may now complete Part A by following the instructions on the questionnaire. Once Part A is completed, please go to Part B by clicking the appropriate button on the top menu or by selecting the sheet tab entitled Part B at the bottom of the worksheet.

Completing Part B of the questionnaire

Part B is designed to capture detailed information on each retail chain store. Many additional buttons also appear in Part B (see Figure 6a).

Note: For users of Excel 2007, see Appendix D "Finding additional buttons when accessing Part A and Part B of the questionnaire".

Figure 6a

Figure 6a is an image of ten computer buttons: Go to Part A, Close, Save, Sort A-Z, Sort Z to A, Next error, Record ID, Export ID, Import, and Export.

Go to Part A moves your cursor to the first Excel spreadsheet entitled Part A. Close closes the application, Save saves the current session on your hard disk and Next Error moves your cursor to the next cell with an error.

Sort A-Z will allow you to sort the content of the selected column in alphabetical order. Sort Z-A will sort in the reverse order. Please note that you can only sort one column at a time.

Recode ID, Export ID, Import and Export are explained on page 11.

Part B is divided by store, and the information collected for each store is on the same line. As in Part A, the sheet already contains information collected over the years. To change it, simply overwrite the content of the cell by entering the corrections.

Columns containing store addresses and company IDs appear twice. Columns appearing in colour are protected and reserved for use by Statistics Canada for processing purposes. Use blank store address and company ID columns to update information.

To add a new location, use a new line at the bottom of the spreadsheet.

If a store has gone out of business, you must indicate this in the column headed Part Year Operation. This application does not allow you to delete stores.

For Part Year Operation (see Figure 6b), enter the number corresponding to the correct description. The numbers and their descriptions are available by moving the cursor to the top of the red triangle located in the header of the column as illustrated in Figure 6b.

Figure 6b

Figure 6b pertains to you if your store was only open part of the year. As you tab down the list, choose the description that most closely relates to your situation.

In Part B, it is recommended that you use the Tab key for browsing. By using the Tab key, you can move through all the boxes for the same store before moving to the next.

When Part B is completed, you can either return to Part A or save and close the questionnaire so that it can be sent to Statistics Canada (see Closing the questionnaire on page 12).

General information

Error message

Error messages identifying inconsistencies in your answers may appear at various points while you complete the questionnaire. Please read the messages and correct the erroneous information.

Also, when PERQS assesses that the data entry is erroneous, the cell turns red. When you move your cursor over the cell, a comment box containing the information on this erroneous cell is posted (see Figure 7a).

Figure 7a

Figure 7a will let you know there is a mistake in one of the numbers you have entered and will tell you which cell number needs to be re-entered.

It is possible that some of your data will seem inconsistent according to PERQS. If this happens, explanations for particular questions may be provided in the comment box (see Figure 7b). Providing such explanations means that Statistics Canada might not have to contact you to obtain more details about the information.

Figure 7b

Figure 7b is a comment box that provides space for explaining why some of your data seems inconsistent.

You may also include additional comments in Section G of Part A.

Printing the questionnaire

To print your questionnaire select Part A or Part B. Then, select File -> Print in the Excel menu.

Since every printer has its own configuration, you may have to adjust your margins to print a presentable document. Also, in Part B, due to the amount of information included, we recommend that you use the Export option for better printing capabilities.

Exporting and importing

Recoding ID and exporting ID

In Part B of PERQS you will see 2 buttons entitled Recode ID or Export ID. These PERQS buttons allow you to import and export data using Excel. This section will explain how to use these functions.

Exporting and changing the location number

Sometimes the number used to identify your locations can vary from one year to the next. PERQS allows you to overwrite the number directly in the questionnaire and gives you the option to import the number from another, pre-existing spreadsheet.

If you want to use the import option, create another Excel spreadsheet with two columns: one column containing the old identification number and another column containing the updates (see Appendix B).

Click on Recode ID and select the spreadsheet containing this information. PERQS will open the file and update the number of locations using the information collected.

If necessary, PERQS will allow you to export the identification numbers currently in your system to another Excel file. When you use the Export ID option, PERQS can create a new Excel file requesting the identification of a location for your new file. The new file is saved and you return to PERQS.

This new file will contain a complete list of numbers already in PERQS, as well as the names of columns already identified to facilitate the future import of these files.

For users with another spreadsheet program (such as Lotus), please refer to Appendix C for information on how to convert from Lotus to Excel.

Exporting and/or importing data

If you have most of the information required by the questionnaire in another Excel spreadsheet, PERQS gives you the option of importing this information.

To import information, you must have an Excel spreadsheet that has specific names for its columns in the first row (see Appendix A). The system will use the names of the rows to update the data.

To use the import function, click on Import and select the spreadsheet containing the updated information. PERQS will open the file and update the location data. It will use the identification number of the location to merge the spreadsheets.

When PERQS discovers new locations during the process (i.e., the ID number of the source file does not correspond to any record presently on PERQS), it will automatically add it to the end of the questionnaire.

PERQS will allow you to export the data presently in the system to another Excel file. When using the Export option, PERQS will create a new Excel file and ask you to identify a location for your new file through Explorer in Excel. The new file is saved and you return to PERQS.

The new file will contain a complete list of numbers already in PERQS, as well as the names of already identified columns to facilitate future importation of these files. Columns labelled ADDRESS, CITY, PROVINCE and PCODE are blank white columns on your questionnaire.

For users with another spreadsheet program (such as Lotus), please refer to Appendix C for information on how to convert from Lotus to Excel.

Closing the questionnaire

Once the questionnaire is completed, click on the Save or on the Close button to save your changes or exit the questionnaire. When you click on this button, this window (Figure 8a) will appear:

Figure 8a

Figure 8a asks if you have completed filling in the questionnaire, a yes or no answer.

If the questionnaire is fully completed, click on Yes and the questionnaire with your information will be saved.

Consistency errors in your questionnaire (see Figure 8b) will also appear. If you do not want to correct these errors, you can add a comment concerning these errors (see Figure 8c).

If you have not finished completing the questionnaire, click on No and the information will be saved. Cancel will take you back to the application.

Figure 8b

Figure 8b lists particular questions that you may have missed when filling in your questionnaire and asks if you would like to complete them now. These missed questions appear as errors.

Figure 8c

Figure 8c is a comment box asking for your comments regarding the errors in the figure above.

Returning your company data to Statistics Canada via Internet

Once you have completed the survey and you are ready to return it to Statistics Canada via the Internet, you must execute the e-File Transfer Service to upload PERQS.

Accessing the e-File Transfer Service

1. From the Internet, go to URL http://www.statcan.gc.ca/ec-ce/eft-tef.

2. Enter username provided by Statistics Canada.

3. Enter your password, then click Logon.

4. You will see a list of safes.

5. Click on your safe.

6. To upload files to Statistics Canada, click ToStatcan-->Upload file, then Browse for the file you want to upload (e.g. Q11111111.xls).

7. Once you have chosen the file, click on the Upload button.

8. Logout.

Note: if you have a problem using the e-File Transfer service, please send an e-mail to the support team at: SOS@statcan.gc.ca

Appendix A

PERQS Import file record layout:
  Column Header Description
Column 1 SNUMBER Location ID (from Statistics Canada)
Column 2 COMPID Location ID (do not exceed 8 characters)
Column 3 OPNAME Operating name
Column 4 ADDRESS Name of street
Column 5 CITY City
Column 6 PROVINCE Province or territory (2 characters)*
Column 7 PCODE Postal code
Column 8 C2080 Total operating revenue
Column 9 C0876 Gross leasable area
Column 10 C0875 Unit of measurement (1 = square feet; 2 = square meters)
Column 11 C0873 Part year operation (1 digit)
1: Seasonal operation;
2: New store;
3: Change of fiscal year;
4: Change of ownership;
5: Ceased operations;
6: Temporarily closed;
7: Moved
Column 12 C0871 Part year operation from (6 digits) yyyy/mm or leave blank
Column 13 C0872 Part year operation to (6 digits) yyy/mm or leave blank
Column 14 NAICS NAICS (North American Industry Classification System) (6 digits)
Column 15 C9921 Comments

Numeric columns:

C2080, C0875, C0876, C0873, C0871 and C0872.

Abbreviations used for the provinces and territories:
Province *Code
Newfoundland and Labrador NL
Nova Scotia NS
New Brunswick NB
Prince Edward Island PE
Quebec QC
Ontario ON
Manitoba MB
Saskatchewan SK
Alberta AB
British Columbia BC
Yukon YT
North West Territories NT
Nunavut NU

Appendix B

To import data in PERQS, you must use Excel 97 or higher. In order for PERQS to import your data correctly, please indicate the names of the following columns in the first row of your Excel spreadsheet.

Record layout for importing new location number in PERQS:
  Column Header Description
Column 1 OLDID Old Location ID
Column 2 NEWID New Location ID (do not exceed 8 characters)

Appendix C

As mentioned in this guide, you may only import and export if your data currently exists in an Excel 97 spreadsheet or higher. However, if your data exists in a different format your software may convert to Excel. Conversion to Excel is possible for Lotus and Microsoft Access.

For users who have other types of software, please consult your software documentation to find out whether it is possible to convert to Excel 97 and follow those instructions.

Lotus to Excel

To convert from Lotus to Excel, you must use the command Save under and click on File in your Lotus tab. Please save the spreadsheet in Excel 97 format (see figure 9a).

Figure 9a

Figure 9a is an image of a screen that will help you convert your data from Lotus to Excel. Select “Save under” and click on “File”.

Microsoft Access to Excel

To convert from Microsoft Access to Excel you must select your data and use the command Save as under File on your toolbar (see Figure 9b).

Figure 9b

Figure 9b is an image of a screen that will help you convert your data from Microsoft Access to Excel. Select “Save as” under “File” on your toolbar.

After choosing the option to save to the external file, you must save your data in Excel 97 format by selecting Microsoft Excel 97 (*.xls) as the type of file (see Figure 9c).

Figure 9c

Figure 9c is an image of a screen that allows you to save your data in Excel format. At the bottom of the screen, select “Microsoft Excel 97”.

Using Excel 2007 to open the questionnaire and use the macros

Open the questionnaire with the Microsoft Office button, menu Open, and then find the questionnaire using the Excel explorer.

To activate the macros, use the Options… buttons which will be found on the security warning tool bar (Figure 10a). Once the Microsoft Office Security Options window has open, choose the option: Enable this content (Figure 10b). This will open the questionnaire and data entry can begin.

Figure 10a

Figure 10a shows part of the Microsoft toolbar. In order to open the questionnaire and activate the macros, you will need to go to the “Options” button on the security toolbar.

Figure 10b

Figure 10b allows you to open the questionnaire by choosing “Enable this content”.

Finding additional buttons when accessing Part A and Part B of the questionnaire

To manoeuvre more easily once in either Part A or Part B of the questionnaire, use the Add-Ins ribbon, see Figure 10c.

Figure 10c

(Part A)

Figure 10c, Part A allows you to manoeuvre more easily in Part B by using the Add-Ins ribbon.

(Part B)

Figure 10c, Part B allows you to manoeuvre more easily in Part A by using the Add-Ins ribbon.

Thank you!

 

User Guide for Personalized Electronic Reporting Questionnaire System (PERQS) – 2010 Annual Retail Trade Survey

Unified Enterprise Survey

5-3600-152.3 E STC/UES-375-75376

Personalized Electronic Reporting Questionnaire System (PERQS)

User Guide for Electronic Data Reporting

User Guide Contents

About PERQS
Tools needed to use PERQS
Accessing the 2010 version of PERQS for the first time
Decrypting the company data file
Opening PERQS
Completing Part A of the questionnaire
Completing Part B of the questionnaire
General information
Exporting and importing
Closing the questionnaire
Returning your company data to Statistics Canada via Internet
Accessing the e-File Transfer Service
Appendix A
Appendix B
Appendix C
Appendix D

PERQS – User guide for electronic data reporting

About PERQS

Welcome to Statistics Canada’s electronic data reporting system for the 2010 Annual Retail Trade Survey. This system, referred to as PERQS (Personalized Electronic Reporting Questionnaire System), is comprised of preloaded encrypted Excel spreadsheets stored on an electronic Statistics Canada vault. A tool allows you to decrypt the spreadsheets to get started, then the e-File Transfer Service allows you to securely send them back to Statistics Canada via the Internet (see page 13, Returning your Company Data to Statistics Canada).

Information from your previous year’s report: (business name(s), addresses, square footage, contacts, reporting period, etc.) has been pre-loaded into PERQS.

Also stored in the same Statistics Canada vault are guides to use PERQS; reporting guides for the questionnaire; a North American Industrial Classification System Guide and the decryption tool called ETUNPROT.exe.

Tools needed to use PERQS

PERQS was designed to run in a Windows 95 or higher environment and requires Microsoft Excel 97 or higher. If you do not have access to a PC with Windows installed on it, or if you do not have Microsoft Excel 97 or higher, you will not be able to use PERQS.

In order to read the Reporting Guide: 2010 Annual Retail Trade Survey and the NAICS (North American Industrial Classification System), you must install Adobe Acrobat reader. If you do not have Adobe reader installed, it is available as a download from www.adobe.com. You will also need access to the Internet.

You should have received a letter containing your password, a series of 9 randomly generated characters. This password is unique to each PERQS package and is needed to decrypt the PERQS company data file. If at any time you lose or forget your original password, please call our toll-free Help Line at 1-877-949-9492 for instructions or email - - SOS@statcan.gc.ca.

If you do not wish to have PERQS pre-loaded with information from your previous report, please advise us.

Thank you for taking the time to respond to the 2010 Annual Retail Trade Survey.

Note to users:

Please uninstall any previous versions of PERQS from your system before accessing the 2010 version of PERQS.

To uninstall previous PERQS versions from your PC’s hard drive:

1. From the Windows Start menu, select Settings;

2. In the Control Panel, select the Add/Remove Program icon;

3. Select STCDRF;

4. Click Remove.

Accessing the 2010 version of PERQS for the first time

1. From the Internet, go to URL http://www.statcan.gc.ca/ec-ce/eft-tef. Click the Logon button.

2. Enter the username that was provided by Statistics Canada.

3.Enter temporary password that was provided by Statistics Canada. Click the Logon button.

4. Your password will expire and an error message is displayed in red
(Error: ITATS203E Password has expired) and you will be prompted to enter a new one*.

5. Enter the new password.

6. Re-enter the new password to confirm.

7. You will see a list of safes.

8. Click on the safe of your choice.

9. To download files, click on FromStatcan-->Download, and then browse for the files you want to download to your computer. Please save the decryption file, ETUNPROT.exe, to your desktop. Please save the other files (especially the “.xls.enp” file) to a location of your choice (e.g. “C:\PERQSTemp\DownloadedFiles”).
Note: Some respondents may receive a security message asking if they want to run or save the etunprot.exe file. Please choose the SAVE option.

10. Logout.

* Password must be at least 8 characters with at least one capital letter and one digit.

Note: if you have a problem using the e-File Transfer service, please send an e-mail to the support team at: SOS@statcan.gc.ca.

Decrypting the company data file

1. After the PERQS excel (.xls.enp) file and the decryption program have been downloaded to your computer, execute the decryption file, ETUNPROT.exe, by double-clicking the icon on your desktop. This will cause the following window to appear (see Figure 1).

Figure 1

Figure 1 is an image of a screen entitled “Select a password-protected file”. The full title of the PERQS file that you have just downloaded appears on the screen. When you open the file (by clicking on “Open”) you will be asked to enter the password that was written on the letter that was sent to you in the mail.

2. Browse to the location that you downloaded the files to and select the file you have saved “your file name.xls.enp” then select the Open button.

3. You will then be prompted to enter a password (see Figure 2). This password was written on the letter that was sent to you in the mail.

Figure 2

Figure 2 asks you to enter that password.

4. You will then be prompted to save the data file to a location of your choice (see Figure 3).

Figure 3

Figure 3 asks you to save the PERQS file on your computer. Now you are ready to fill in your PERQS questionnaire. The reporting guide will give you more information and help to fill it in.

5. Fill in the questionnaire (see below for instructions). The Reporting Guide (found on the Statistics Canada electronic vault) can assist you in completing the questionnaire.

6. After completing the questionnaire, follow the Returning your company data to Statistics Canada via Internet instructions.

Opening PERQS

PERQS 2010 was developed using Microsoft Excel 97 and therefore requires that either Excel 97 or higher be installed on your PC.

When your customized questionnaire information on the company data file is decrypted, please locate it using Windows Explorer and double click on it (Excel should automatically open your questionnaire).

Alternatively, open Microsoft Excel, and go to File -> Open. Locate the questionnaire using the Excel browser. When the questionnaire is opened, the following message (Figure 4a) will appear:

Note: For users of Excel 2007, see Appendix D "Using Excel 2007 to open the questionnaire and use the macros".

Figure 4a

Figure 4a tells you that you should click on “Enable macros”.

Activate the user-friendly macros developed by Statistics Canada by clicking Enable Macros

Disabling macros will make it impossible to fill out the questionnaire. Instructions will appear on the screen, as shown in Figure 4b.

Figure 4b

Figure 4b contains instructions to open the questionnaire in various Excel versions.

You now have full access to PERQS which is made up of two Excel spreadsheets, identified as Part A and Part B. When the questionnaire is opened, Part A will be displayed. In the upper left hand corner you will see the title 2010 Annual Retail Trade Survey.

Completing Part A of the questionnaire

The questionnaire text in PERQS is black on a coloured background. The coloured boxes contain instructions, information and/or questions. The white boxes are reserved for your answers.

The easiest way to move through PERQS is to use the Tab key. It will take you from one white box to the next, from left to right and from top to bottom. This is the order in which you should answer the questions.

Shift +Tab enables you to go backwards. Using the Enter key is not recommended, as it does not allow you to go from one white area to the next; instead, the Enter key takes you to the cell below in the next row down.

Some white boxes may contain information collected in previous years. Please verify the information and make the necessary corrections. To change it, please overwrite the content of the cell by entering the corrections.

You will also see several additional buttons displayed on the menu (see Figure 4c). Go to Part B will move your cursor to the second Excel spreadsheet, entitled Part B. Save and Close closes the application (see Closing the questionnaire on page 12). Save saves the current session on your hard disk. Next Error moves your cursor to the next cell in error.

Note: For users of Excel 2007, see Appendix D "Finding additional buttons when accessing Part A and Part B of the questionnaire".

Figure 4c

Figure 4c is an image of four computer buttons: go to Part B, Close, Save and Next Error.

Some cells may contain a small red triangle in the upper right hand corner. When you point your cursor over this red triangle, a dialog box containing additional information about this cell will appear (see Figure 5).

Figure 5

Figure 5 is an image that contains blank spaces for some information you might have missed. When you move the curser on these spaces, the computer will let you know which one you have missed.

If PERQS assesses that the information collected is erroneous, the cell turns red. When you move your cursor over it, a dialog box containing the information of the erroneous cell will be posted (see General Information section).

You will have the option of coming back later by clicking the Next Error button at the top of the worksheet. Next Error will allow you to navigate between all the possibly erroneous cells in Part A.

You may now complete Part A by following the instructions on the questionnaire. Once Part A is completed, please go to Part B by clicking the appropriate button on the top menu or by selecting the sheet tab entitled Part B at the bottom of the worksheet.

Completing Part B of the questionnaire

Part B is designed to capture detailed information on each retail chain store. Many additional buttons also appear in Part B (see Figure 6a).

Note: For users of Excel 2007, see Appendix D "Finding additional buttons when accessing Part A and Part B of the questionnaire".

Figure 6a

Figure 6a is an image of ten computer buttons: Go to Part A, Close, Save, Sort A-Z, Sort Z to A, Next error, Record ID, Export ID, Import, and Export.

Go to Part A moves your cursor to the first Excel spreadsheet entitled Part A. Close closes the application, Save saves the current session on your hard disk and Next Error moves your cursor to the next cell with an error.

Sort A-Z will allow you to sort the content of the selected column in alphabetical order. Sort Z-A will sort in the reverse order. Please note that you can only sort one column at a time.

Recode ID, Export ID, Import and Export are explained on page 11.

Part B is divided by store, and the information collected for each store is on the same line. As in Part A, the sheet already contains information collected over the years. To change it, simply overwrite the content of the cell by entering the corrections.

Columns containing store addresses and company IDs appear twice. Columns appearing in colour are protected and reserved for use by Statistics Canada for processing purposes. Use blank store address and company ID columns to update information.

To add a new location, use a new line at the bottom of the spreadsheet.

If a store has gone out of business, you must indicate this in the column headed Part Year Operation. This application does not allow you to delete stores.

For Part Year Operation (see Figure 6b), enter the number corresponding to the correct description. The numbers and their descriptions are available by moving the cursor to the top of the red triangle located in the header of the column as illustrated in Figure 6b.

Figure 6b

Figure 6b pertains to you if your store was only open part of the year. As you tab down the list, choose the description that most closely relates to your situation.

In Part B, it is recommended that you use the Tab key for browsing. By using the Tab key, you can move through all the boxes for the same store before moving to the next.

When Part B is completed, you can either return to Part A or save and close the questionnaire so that it can be sent to Statistics Canada (see Closing the questionnaire on page 12).

General information

Error message

Error messages identifying inconsistencies in your answers may appear at various points while you complete the questionnaire. Please read the messages and correct the erroneous information.

Also, when PERQS assesses that the data entry is erroneous, the cell turns red. When you move your cursor over the cell, a comment box containing the information on this erroneous cell is posted (see Figure 7a).

Figure 7a

Figure 7a will let you know there is a mistake in one of the numbers you have entered and will tell you which cell number needs to be re-entered.

It is possible that some of your data will seem inconsistent according to PERQS. If this happens, explanations for particular questions may be provided in the comment box (see Figure 7b). Providing such explanations means that Statistics Canada might not have to contact you to obtain more details about the information.

Figure 7b

Figure 7b is a comment box that provides space for explaining why some of your data seems inconsistent.

You may also include additional comments in Section G of Part A.

Printing the questionnaire

To print your questionnaire select Part A or Part B. Then, select File -> Print in the Excel menu.

Since every printer has its own configuration, you may have to adjust your margins to print a presentable document. Also, in Part B, due to the amount of information included, we recommend that you use the Export option for better printing capabilities.

Exporting and importing

Recoding ID and exporting ID

In Part B of PERQS you will see 2 buttons entitled Recode ID or Export ID. These PERQS buttons allow you to import and export data using Excel. This section will explain how to use these functions.

Exporting and changing the location number

Sometimes the number used to identify your locations can vary from one year to the next. PERQS allows you to overwrite the number directly in the questionnaire and gives you the option to import the number from another, pre-existing spreadsheet.

If you want to use the import option, create another Excel spreadsheet with two columns: one column containing the old identification number and another column containing the updates (see Appendix B).

Click on Recode ID and select the spreadsheet containing this information. PERQS will open the file and update the number of locations using the information collected.

If necessary, PERQS will allow you to export the identification numbers currently in your system to another Excel file. When you use the Export ID option, PERQS can create a new Excel file requesting the identification of a location for your new file. The new file is saved and you return to PERQS.

This new file will contain a complete list of numbers already in PERQS, as well as the names of columns already identified to facilitate the future import of these files.

For users with another spreadsheet program (such as Lotus), please refer to Appendix C for information on how to convert from Lotus to Excel.

Exporting and/or importing data

If you have most of the information required by the questionnaire in another Excel spreadsheet, PERQS gives you the option of importing this information.

To import information, you must have an Excel spreadsheet that has specific names for its columns in the first row (see Appendix A). The system will use the names of the rows to update the data.

To use the import function, click on Import and select the spreadsheet containing the updated information. PERQS will open the file and update the location data. It will use the identification number of the location to merge the spreadsheets.

When PERQS discovers new locations during the process (i.e., the ID number of the source file does not correspond to any record presently on PERQS), it will automatically add it to the end of the questionnaire.

PERQS will allow you to export the data presently in the system to another Excel file. When using the Export option, PERQS will create a new Excel file and ask you to identify a location for your new file through Explorer in Excel. The new file is saved and you return to PERQS.

The new file will contain a complete list of numbers already in PERQS, as well as the names of already identified columns to facilitate future importation of these files. Columns labelled ADDRESS, CITY, PROVINCE and PCODE are blank white columns on your questionnaire.

For users with another spreadsheet program (such as Lotus), please refer to Appendix C for information on how to convert from Lotus to Excel.

Closing the questionnaire

Once the questionnaire is completed, click on the Save or on the Close button to save your changes or exit the questionnaire. When you click on this button, this window (Figure 8a) will appear:

Figure 8a

Figure 8a asks if you have completed filling in the questionnaire, a yes or no answer.

If the questionnaire is fully completed, click on Yes and the questionnaire with your information will be saved.

Consistency errors in your questionnaire (see Figure 8b) will also appear. If you do not want to correct these errors, you can add a comment concerning these errors (see Figure 8c).

If you have not finished completing the questionnaire, click on No and the information will be saved. Cancel will take you back to the application.

Figure 8b

Figure 8b lists particular questions that you may have missed when filling in your questionnaire and asks if you would like to complete them now. These missed questions appear as errors.

Figure 8c

Figure 8c is a comment box asking for your comments regarding the errors in the figure above.

Returning your company data to Statistics Canada via Internet

Once you have completed the survey and you are ready to return it to Statistics Canada via the Internet, you must execute the e-File Transfer Service to upload PERQS.

Accessing the e-File Transfer Service

1. From the Internet, go to URL http://www.statcan.gc.ca/ec-ce/eft-tef.

2. Enter username provided by Statistics Canada.

3. Enter your password, then click Logon.

4. You will see a list of safes.

5. Click on your safe.

6. To upload files to Statistics Canada, click ToStatcan-->Upload file, then Browse for the file you want to upload (e.g. Q11111111.xls).

7. Once you have chosen the file, click on the Upload button.

8. Logout.

Note: if you have a problem using the e-File Transfer service, please send an e-mail to the support team at: SOS@statcan.gc.ca

Appendix A

PERQS Import file record layout:
  Column Header Description
Column 1 SNUMBER Location ID (from Statistics Canada)
Column 2 COMPID Location ID (do not exceed 8 characters)
Column 3 OPNAME Operating name
Column 4 ADDRESS Name of street
Column 5 CITY City
Column 6 PROVINCE Province or territory (2 characters)*
Column 7 PCODE Postal code
Column 8 C2080 Total operating revenue
Column 9 C0876 Gross leasable area
Column 10 C0875 Unit of measurement (1 = square feet; 2 = square meters)
Column 11 C0873 Part year operation (1 digit)
1: Seasonal operation;
2: New store;
3: Change of fiscal year;
4: Change of ownership;
5: Ceased operations;
6: Temporarily closed;
7: Moved
Column 12 C0871 Part year operation from (6 digits) yyyy/mm or leave blank
Column 13 C0872 Part year operation to (6 digits) yyy/mm or leave blank
Column 14 NAICS NAICS (North American Industry Classification System) (6 digits)
Column 15 C9921 Comments

Numeric columns:

C2080, C0875, C0876, C0873, C0871 and C0872.

Abbreviations used for the provinces and territories:
Province *Code
Newfoundland and Labrador NL
Nova Scotia NS
New Brunswick NB
Prince Edward Island PE
Quebec QC
Ontario ON
Manitoba MB
Saskatchewan SK
Alberta AB
British Columbia BC
Yukon YT
North West Territories NT
Nunavut NU

Appendix B

To import data in PERQS, you must use Excel 97 or higher. In order for PERQS to import your data correctly, please indicate the names of the following columns in the first row of your Excel spreadsheet.

Record layout for importing new location number in PERQS:
  Column Header Description
Column 1 OLDID Old Location ID
Column 2 NEWID New Location ID (do not exceed 8 characters)

Appendix C

As mentioned in this guide, you may only import and export if your data currently exists in an Excel 97 spreadsheet or higher. However, if your data exists in a different format your software may convert to Excel. Conversion to Excel is possible for Lotus and Microsoft Access.

For users who have other types of software, please consult your software documentation to find out whether it is possible to convert to Excel 97 and follow those instructions.

Lotus to Excel

To convert from Lotus to Excel, you must use the command Save under and click on File in your Lotus tab. Please save the spreadsheet in Excel 97 format (see figure 9a).

Figure 9a

Figure 9a is an image of a screen that will help you convert your data from Lotus to Excel. Select “Save under” and click on “File”.

Microsoft Access to Excel

To convert from Microsoft Access to Excel you must select your data and use the command Save as under File on your toolbar (see Figure 9b).

Figure 9b

Figure 9b is an image of a screen that will help you convert your data from Microsoft Access to Excel. Select “Save as” under “File” on your toolbar.

After choosing the option to save to the external file, you must save your data in Excel 97 format by selecting Microsoft Excel 97 (*.xls) as the type of file (see Figure 9c).

Figure 9c

Figure 9c is an image of a screen that allows you to save your data in Excel format. At the bottom of the screen, select “Microsoft Excel 97”.

Using Excel 2007 to open the questionnaire and use the macros

Open the questionnaire with the Microsoft Office, menu Open, and then find the questionnaire using the Excel explorer.

To activate the macros, use the Options… buttons which will be found on the security warning tool bar (Figure 10a). Once the Microsoft Office Security Options window has open, choose the option: Enable this content (Figure 10b). This will open the questionnaire and data entry can begin.

Figure 10a

Figure 10a shows part of the Microsoft toolbar. In order to open the questionnaire and activate the macros, you will need to go to the “Options” button on the security toolbar.

Figure 10b

Figure 10b allows you to open the questionnaire by choosing “Enable this content”.

Finding additional buttons when accessing Part A and Part B of the questionnaire

To manoeuvre more easily once in either Part A or Part B of the questionnaire, use the Add-Ins ribbon, see Figure 10c.

Figure 10c

(Part A)

Figure 10c, Part A allows you to manoeuvre more easily in Part B by using the Add-Ins ribbon.

(Part B)

Figure 10c, Part B allows you to manoeuvre more easily in Part A by using the Add-Ins ribbon.

Thank you!

 

User Guide for Personalized Electronic Reporting Questionnaire System (PERQS) – 2009 Annual Retail Trade Survey

Unified Enterprise Survey

5-3600-152.3 E STC/UES-375-75376

Personalized Electronic Reporting Questionnaire System (PERQS)

User Guide for Electronic Data Reporting

What’s new for 2009:

Statistics Canada has acquired a new software product called e-File Transfer Service (e-FT). This product allows the retrieval of the PERQS files and guides from secure electronic storage vaults and then enables organizations to securely exchange confidential information back to Statistics Canada using the Internet.

User Guide Contents

About PERQS
Tools needed to use PERQS
Accessing the 2009 version of PERQS for the first time
Decrypting the company data file
Opening PERQS
Completing Part A of the questionnaire
Completing Part B of the questionnaire
General information
Exporting and importing
Closing the questionnaire
Returning your company data to Statistics Canada via Internet
Accessing the e-File Transfer Service
Appendix A
Appendix B
Appendix C
Appendix D

PERQS – User guide for electronic data reporting

About PERQS

Welcome to Statistics Canada’s electronic data reporting system for the 2009 Annual Retail Trade Survey. This system, referred to as PERQS (Personalized Electronic Reporting Questionnaire System), is comprised of preloaded encrypted Excel spreadsheets stored on an electronic Statistics Canada vault. A tool allows you to decrypt the spreadsheets to get started, then the e-File Transfer Service allows you to securely send them back to Statistics Canada via the Internet (see page 13, Returning your Company Data to Statistics Canada).

Information from your previous year’s report: (business name(s), addresses, square footage, contacts, reporting period, etc.) has been pre-loaded into PERQS.

Also stored in the same Statistics Canada vault are guides to use PERQS; reporting guides for the questionnaire; a North American Industrial Classification System Guide and the decryption tool called ETUNPROT.exe.

Tools needed to use PERQS

PERQS was designed to run in a Windows 95 or higher environment and requires Microsoft Excel 97 or higher. If you do not have access to a PC with Windows installed on it, or if you do not have Microsoft Excel 97 or higher, you will not be able to use PERQS.

In order to read the Reporting Guide: 2009 Annual Retail Trade Survey and the NAICS (North American Industrial Classification System), you must install Adobe Acrobat reader. If you do not have Adobe reader installed, it is available as a download from www.adobe.com. You will also need access to the Internet.

You should have received a letter containing your password, a series of 9 randomly generated characters. This password is unique to each PERQS package and is needed to decrypt the PERQS company data file. If at any time you lose or forget your original password, please call our toll-free Help Line at 1-800-368-1582 for instructions or email - - business.surveys.unit.oid@statcan.gc.ca.

If you do not wish to have PERQS pre-loaded with information from your previous report, please advise us.

Thank you for taking the time to respond to the 2009 Annual Retail Trade Survey.

Note to users:

Please uninstall any previous versions of PERQS from your system before accessing the 2009 version of PERQS.

To uninstall previous PERQS versions from your PC’s hard drive:

1. From the Windows Start menu, select Settings;

2. In the Control Panel, select the Add/Remove Program icon;

3. Select STCDRF;

4. Click Remove.

Accessing the 2009 version of PERQS for the first time

1. From the Internet, go to URL http://www.statcan.gc.ca/ec-ce/eft-tef. Click the Logon button.

2. Enter the username that was provided by Statistics Canada.

3. Enter temporary password: Password1. Click the Logon button.

4. Your password will expire and an error message is displayed in red
(Error: ITATS203E Password has expired) and you will be prompted to enter a new one*.

5. Enter the new password.

6. Re-enter the new password to confirm.

7. You will see a list of safes.

8. Click on the safe of your choice.

9. To download files, click on FromStatcan-->Download, and then browse for the files you want to download to your computer. Please save the decryption file, ETUNPROT.exe, to your desktop, Please save the other files (especially the “.xls.enp” file) to a location of your choice (e.g. “C:\PerqsTemp\DownloadedFiles”).
Note: Some respondents may receive a security message asking if they want to run or save the etunprot.exe file. Please choose the SAVE option.

10. Logout.

* Password must be at least 8 characters with at least one capital letter and one digit.

Note: if you have a problem using the e-File Transfer service, please send an e-mail to the support team at: eft-tef-support@statcan.gc.ca.

Decrypting the company data file

1. After the PERQS excel (.xls.enp) file and the decryption program have been downloaded to your computer, execute the decryption file, ETUNPROT.exe, by double-clicking the icon on your desktop. This will cause the following window to appear (see Figure 1).

Figure 1

Figure 1 is an image of a screen entitled “Select a password-protected file”. The full title of the PERQS file that you have just downloaded appears on the screen. When you open the file (by clicking on “Open”) you will be asked to enter the password that was written on the letter that was sent to you in the mail.

2. Browse to the location that you downloaded the files to and select the file “PerqsFileStatCan.xls.enp” then select the Open button.

3. You will then be prompted to enter a password (see Figure 2). This password was written on the letter that was sent to you in the mail.

Figure 2

Figure 2 asks you to enter that password.

4. You will then be prompted to save the data file to a location of your choice (see Figure 3).

Figure 3

Figure 3 asks you to save the PERQS file on your computer. Now you are ready to fill in your PERQS questionnaire. The reporting guide will give you more information and help to fill it in.

5. Fill in the questionnaire (see below for instructions). The Reporting Guide (found on the Statistics Canada electronic vault) can assist you in completing the questionnaire.

6. After completing the questionnaire, follow the Returning your company data to Statistics Canada via Internet instructions.

Opening PERQS

PERQS 2009 was developed using Microsoft Excel 97 and therefore requires that either Excel 97 or higher be installed on your PC.

When your customized questionnaire information on the company data file is decrypted, please locate it using Windows Explorer and double click on it (Excel should automatically open your questionnaire).

Alternatively, open Microsoft Excel, and go to File -> Open. Locate the questionnaire using the Excel browser. When the questionnaire is opened, the following message (Figure 4a) will appear:

Note: For users of Excel 2007, see Appendix D "Using Excel 2007 to open the questionnaire and use the macros".

Figure 4a

Figure 4a tells you that you should click on “Enable macros”.

Activate the user-friendly macros developed by Statistics Canada by clicking Enable Macros

Disabling macros will make it impossible to fill out the questionnaire. Instructions will appear on the screen, as shown in Figure 4b.

Figure 4b

Figure 4b contains instructions to open the questionnaire in various Excel versions.

You now have full access to PERQS which is made up of two Excel spreadsheets, identified as Part A and Part B. When the questionnaire is opened, Part A will be displayed. In the upper left hand corner you will see the title 2009 Annual Retail Trade Survey.

Completing Part A of the questionnaire

The questionnaire text in PERQS is black on a coloured background. The coloured boxes contain instructions, information and/or questions. The white boxes are reserved for your answers.

The easiest way to move through PERQS is to use the Tab key. It will take you from one white box to the next, from left to right and from top to bottom. This is the order in which you should answer the questions.

Shift +Tab enables you to go backwards. Using the Enter key is not recommended, as it does not allow you to go from one white area to the next; instead, the Enter key takes you to the cell below in the next row down.

Some white boxes may contain information collected in previous years. Please verify the information and make the necessary corrections. To change it, please overwrite the content of the cell by entering the corrections.

You will also see several additional buttons displayed on the menu (see Figure 4c). Go to Part B will move your cursor to the second Excel spreadsheet, entitled Part B. Save and Close closes the application (see Closing the questionnaire on page 12). Save saves the current session on your hard disk. Next Error moves your cursor to the next cell in error.

Note: For users of Excel 2007, see Appendix D "Finding additional buttons when accessing Part A and Part B of the questionnaire".

Figure 4c

Figure 4c is an image of four computer buttons: go to Part B, Close, Save and Next Error.

Some cells may contain a small red triangle in the upper right hand corner. When you point your cursor over this red triangle, a dialog box containing additional information about this cell will appear (see Figure 5).

Figure 5

Figure 5 is an image that contains blank spaces for some information you might have missed. When you move the curser on these spaces, the computer will let you know which one you have missed.

If PERQS assesses that the information collected is erroneous, the cell turns red. When you move your cursor over it, a dialog box containing the information of the erroneous cell will be posted (see General Information section).

You will have the option of coming back later by clicking the Next Error button at the top of the worksheet. Next Error will allow you to navigate between all the possibly erroneous cells in Part A.

You may now complete Part A by following the instructions on the questionnaire. Once Part A is completed, please go to Part B by clicking the appropriate button on the top menu or by selecting the sheet tab entitled Part B at the bottom of the worksheet.

Completing Part B of the questionnaire

Part B is designed to capture detailed information on each retail chain store. Many additional buttons also appear in Part B (see Figure 6a).

Note: For users of Excel 2007, see Appendix D "Finding additional buttons when accessing Part A and Part B of the questionnaire".

Figure 6a

Figure 6a is an image of ten computer buttons: Go to Part A, Close, Save, Sort A-Z, Sort Z to A, Next error, Record ID, Export ID, Import, and Export.

Go to Part A moves your cursor to the first Excel spreadsheet entitled Part A. Close closes the application, Save saves the current session on your hard disk and Next Error moves your cursor to the next cell with an error.

Sort A-Z will allow you to sort the content of the selected column in alphabetical order. Sort Z-A will sort in the reverse order. Please note that you can only sort one column at a time.

Recode ID, Export ID, Import and Export are explained on page 11.

Part B is divided by store, and the information collected for each store is on the same line. As in Part A, the sheet already contains information collected over the years. To change it, simply overwrite the content of the cell by entering the corrections.

Columns containing store addresses and company IDs appear twice. Columns appearing in colour are protected and reserved for use by Statistics Canada for processing purposes. Use blank store address and company ID columns to update information.

To add a new location, use a new line at the bottom of the spreadsheet.

If a store has gone out of business, you must indicate this in the column headed Part Year Operation. This application does not allow you to delete stores.

For Part Year Operation (see Figure 6b), enter the number corresponding to the correct description. The numbers and their descriptions are available by moving the cursor to the top of the red triangle located in the header of the column as illustrated in Figure 6b.

Figure 6b

Figure 6b pertains to you if your store was only open part of the year. As you tab down the list, choose the description that most closely relates to your situation.

In Part B, it is recommended that you use the Tab key for browsing. By using the Tab key, you can move through all the boxes for the same store before moving to the next.

When Part B is completed, you can either return to Part A or save and close the questionnaire so that it can be sent to Statistics Canada (see Closing the questionnaire on page 12).

General information

Error message

Error messages identifying inconsistencies in your answers may appear at various points while you complete the questionnaire. Please read the messages and correct the erroneous information.

Also, when PERQS assesses that the data entry is erroneous, the cell turns red. When you move your cursor over the cell, a comment box containing the information on this erroneous cell is posted (see Figure 7a).

Figure 7a

Figure 7a will let you know there is a mistake in one of the numbers you have entered and will tell you which cell number needs to be re-entered.

It is possible that some of your data will seem inconsistent according to PERQS. If this happens, explanations for particular questions may be provided in the comment box (see Figure 7b). Providing such explanations means that Statistics Canada might not have to contact you to obtain more details about the information.

Figure 7b

Figure 7b is a comment box that provides space for explaining why some of your data seems inconsistent.

You may also include additional comments in Section G of Part A.

Printing the questionnaire

To print your questionnaire select Part A or Part B. Then, select File -> Print in the Excel menu.

Since every printer has its own configuration, you may have to adjust your margins to print a presentable document. Also, in Part B, due to the amount of information included, we recommend that you use the Export option for better printing capabilities.

Exporting and importing

Recoding ID and exporting ID

In Part B of PERQS you will see 2 buttons entitled Recode ID or Export ID. These PERQS buttons allow you to import and export data using Excel. This section will explain how to use these functions.

Exporting and changing the location number

Sometimes the number used to identify your locations can vary from one year to the next. PERQS allows you to overwrite the number directly in the questionnaire and gives you the option to import the number from another, pre-existing spreadsheet.

If you want to use the import option, create another Excel spreadsheet with two columns: one column containing the old identification number and another column containing the updates (see Appendix B).

Click on Recode ID and select the spreadsheet containing this information. PERQS will open the file and update the number of locations using the information collected.

If necessary, PERQS will allow you to export the identification numbers currently in your system to another Excel file. When you use the Export ID option, PERQS can create a new Excel file requesting the identification of a location for your new file. The new file is saved and you return to PERQS.

This new file will contain a complete list of numbers already in PERQS, as well as the names of columns already identified to facilitate the future import of these files.

For users with another spreadsheet program (such as Lotus), please refer to Appendix C for information on how to convert from Lotus to Excel.

Exporting and/or importing data

If you have most of the information required by the questionnaire in another Excel spreadsheet, PERQS gives you the option of importing this information.

To import information, you must have an Excel spreadsheet that has specific names for its columns in the first row (see Appendix A). The system will use the names of the rows to update the data.

To use the import function, click on Import and select the spreadsheet containing the updated information. PERQS will open the file and update the location data. It will use the identification number of the location to merge the spreadsheets.

When PERQS discovers new locations during the process (i.e., the ID number of the source file does not correspond to any record presently on PERQS), it will automatically add it to the end of the questionnaire.

PERQS will allow you to export the data presently in the system to another Excel file. When using the Export option, PERQS will create a new Excel file and ask you to identify a location for your new file through Explorer in Excel. The new file is saved and you return to PERQS.

The new file will contain a complete list of numbers already in PERQS, as well as the names of already identified columns to facilitate future importation of these files. Columns labelled ADDRESS, CITY, PROVINCE and PCODE are blank white columns on your questionnaire.

For users with another spreadsheet program (such as Lotus), please refer to Appendix C for information on how to convert from Lotus to Excel.

Closing the questionnaire

Once the questionnaire is completed, click on the Save or on the Close button to save your changes or exit the questionnaire. When you click on this button, this window (Figure 8a) will appear:

Figure 8a

Figure 8a asks if you have completed filling in the questionnaire, a yes or no answer.

If the questionnaire is fully completed, click on Yes and the questionnaire with your information will be saved.

Consistency errors in your questionnaire (see Figure 8b) will also appear. If you do not want to correct these errors, you can add a comment concerning these errors (see Figure 8c).

If you have not finished completing the questionnaire, click on No and the information will be saved. Cancel will take you back to the application.

Figure 8b

Figure 8b lists particular questions that you may have missed when filling in your questionnaire and asks if you would like to complete them now. These missed questions appear as errors.

Figure 8c

Figure 8c is a comment box asking for your comments regarding the errors in the figure above.

Returning your company data to Statistics Canada via Internet

Once you have completed the survey and you are ready to return it to Statistics Canada via the Internet, you must execute the e-File Transfer Service to upload PERQS.

Accessing the e-File Transfer Service

1. From the Internet, go to URL http://www.statcan.gc.ca/ec-ce/eft-tef.

2. Enter username provided by Statistics Canada.

3. Enter your password, then click Logon.

4. You will see a list of safes.

5. Click on your safe.

6. To upload files to Statistics Canada, click ToStatcan-->Upload file, then Browse for the file you want to upload (e.g. Q11111111.xls).

7. Once you have chosen the file, click on the Upload button.

8. Logout.

Note: if you have a problem using the e-File Transfer service, please send an e-mail to the support team at: eft-tef-support@statcan.gc.ca

Appendix A

PERQS Import file record layout:
  Column Header Description
Column 1 SNUMBER Location ID (from Statistics Canada)
Column 2 COMPID Location ID (do not exceed 8 characters)
Column 3 OPNAME Operating name
Column 4 ADDRESS Name of street
Column 5 CITY City
Column 6 PROVINCE Province or territory (2 characters)*
Column 7 PCODE Postal code
Column 8 C2080 Total operating revenue
Column 9 C0876 Gross leasable area
Column 10 C0875 Unit of measurement (1 = square feet; 2 = square meters)
Column 11 C0873 Part year operation (1 digit)
1: Seasonal operation;
2: New store;
3: Change of fiscal year;
4: Change of ownership;
5: Ceased operations;
6: Temporarily closed;
7: Moved
Column 12 C0871 Part year operation from (6 digits) yyyy/mm or leave blank
Column 13 C0872 Part year operation to (6 digits) yyy/mm or leave blank
Column 14 NAICS NAICS (North American Industry Classification System) (6 digits)
Column 15 C9921 Comments

Numeric columns:

C2080, C0875, C0876, C0873, C0871 and C0872.

Abbreviations used for the provinces and territories:
Province *Code
Newfoundland and Labrador NL
Nova Scotia NS
New Brunswick NB
Prince Edward Island PE
Quebec QC
Ontario ON
Manitoba MB
Saskatchewan SK
Alberta AB
British Columbia BC
Yukon YT
North West Territories NT
Nunavut NU

Appendix B

To import data in PERQS, you must use Excel 97 or higher. In order for PERQS to import your data correctly, please indicate the names of the following columns in the first row of your Excel spreadsheet.

Record layout for importing new location number in PERQS:
  Column Header Description
Column 1 OLDID Old Location ID
Column 2 NEWID New Location ID (do not exceed 8 characters)

Appendix C

As mentioned in this guide, you may only import and export if your data currently exists in an Excel 97 spreadsheet or higher. However, if your data exists in a different format your software may convert to Excel. Conversion to Excel is possible for Lotus and Microsoft Access.

For users who have other types of software, please consult your software documentation to find out whether it is possible to convert to Excel 97 and follow those instructions.

Lotus to Excel

To convert from Lotus to Excel, you must use the command Save under and click on File in your Lotus tab. Please save the spreadsheet in Excel 97 format (see figure 9a).

Figure 9a

Figure 9a is an image of a screen that will help you convert your data from Lotus to Excel. Select “Save under” and click on “File”.

Microsoft Access to Excel

To convert from Microsoft Access to Excel you must select your data and use the command Save as under File on your toolbar (see Figure 9b).

Figure 9b

Figure 9b is an image of a screen that will help you convert your data from Microsoft Access to Excel. Select “Save as” under “File” on your toolbar.

After choosing the option to save to the external file, you must save your data in Excel 97 format by selecting Microsoft Excel 97 (*.xls) as the type of file (see Figure 9c).

Figure 9c

Figure 9c is an image of a screen that allows you to save your data in Excel format. At the bottom of the screen, select “Microsoft Excel 97”.

Using Excel 2007 to open the questionnaire and use the macros

Open the questionnaire with the Microsoft Office, menu Open, and then find the questionnaire using the Excel explorer.

To activate the macros, use the Options buttons which will be found on the security warning tool bar (Figure 10a). Once the Microsoft Office Security Options window has open, choose the option: Enable this content (Figure 10b). This will open the questionnaire and data entry can begin.

Figure 10a

Figure 10a shows part of the Microsoft toolbar. In order to open the questionnaire and activate the macros, you will need to go to the “Options” button on the security toolbar.

Figure 10b

Figure 10b allows you to open the questionnaire by choosing “Enable this content”.

Finding additional buttons when accessing Part A and Part B of the questionnaire

To manoeuvre more easily once in either Part A or Part B of the questionnaire, use the Add-Ins ribbon, see Figure 10c.

Figure 10c

(Part A)

Figure 10c, Part A allows you to manoeuvre more easily in Part B by using the Add-Ins ribbon.

(Part B)

Figure 10c, Part B allows you to manoeuvre more easily in Part A by using the Add-Ins ribbon.

Thank you!

 

Protecting your privacy as a client

This notice applies to Statistics Canada clients who use our data, products or services, visit our website, or contact us for information. It does NOT apply to people, organizations, institutions or businesses who respond to our surveys; their information is protected by the Statistics Act. See also: When you give information in a Statistics Canada survey.

Your right to privacy and security is fundamental

We are fully committed to protecting the confidentiality of the information provided by our clients. This information will be used only to support your client relationship with Statistics Canada. The following explains how practices at Statistics Canada protect your privacy and your personal information.

You have a choice about how your personal information will be used. Statistics Canada is committed to helping you maintain control over which personal information you provide to us. You will be given the opportunity to inform Statistics Canada if you prefer not to receive promotional materials. You are entitled to confirm that information held about you is correct or ask to be removed from our client file at any time.

Statistics Canada’s principles for client information privacy

Statistics Canada must ensure that client information, whether received online, by telephone, fax or mail, or by personal contact, is fully protected as required under the federal Privacy Act. The following are the principles developed by Statistics Canada to protect your privacy and the confidentiality of your personal information.

  • Statistics Canada will not sell, distribute, trade or transfer client information to other government departments, businesses, institutions, organizations or individuals outside the Agency for commercial or any other purposes, unless required by law.
  • When you make a purchase from Statistics Canada, only the information required to complete your transaction will be requested.
  • No personal information is gathered without your knowledge.

Privacy notices are found on all our order forms, invoices and on our website.

Why is information collected?

Statistics Canada requires information:

  • to complete your sales transaction, deliver products or services to you, announce product updates and administer your account; and
  • to offer you products and services that we think you would like to hear about.

Contact us, if you wish to:

  • obtain a copy of your contact information;
  • change your contact information;
  • have your name removed from our client file for promotional purposes; and
  • ask questions or make comments about this privacy statement.

If you are not satisfied that we have adequately responded to your privacy concerns, you may wish to contact the Office of the Privacy Commissioner at 1-800-282-1376 or Office of the Privacy Commissioner of Canada.

Ordering products and services online

You can order products and services via our website. When you do this, you are usually required to provide contact information, such as your name and address, and financial information such as a credit card number.

We use contact information only to support your client relationship with us. In other words, we use it for invoicing purposes or informing you about new products. If you do not wish to be contacted for promotional purposes, please contact us.

Statistics Canada stores your client information for seven years and then destroys it. While the information is in Statistics Canada's keeping, it is completely confidential. Statistics Canada will not sell, distribute, trade or transfer client information to other government departments, businesses, institutions, organizations or individuals outside Statistics Canada for commercial or any other purposes, unless required by law.

For more information on Statistics Canada's commitment to respecting the privacy of individuals—whether you are respondents to one of our surveys, clients who are purchasing a product or service or users of our website—view our Privacy notice.

Countries and Areas of Interest for Social Statistics – SCCAI 2011

Introduction to the classification

The variant Countries and Areas of Interest for Social Statistics – SCCAI 2011 was developed to create groupings of countries to enable the production of integrated statistics when publishing social statistics data. These groupings are based on those used historically for Statistics Canada's Census of Population, place of birth variable.

The variant Countries and Areas of Interest for Social Statistics – SCCAI 2011 has three levels: 6 geographical macro-regions, 19 geographical sub-regions and 251 countries or areas of interest. This variant is defined in terms of countries or areas of interest in the Standard Classification of Countries and Areas of Interest (SCCAI) 2011. The hierarchical structure of the classification shows the relationship between the three levels of the classification variant.

This variant has a coding structure built on the United Nations numeric codes (NUM-3) for countries or areas. These three-digit codes are preceded by two numeric digits where the first digit represents the macro-regions and the second digit identifies the sub-regions within the macro-region; together these five-digit codes form the SCCAI code.

Relation to previous standard

This is a revision of the previous Standard Classification of Countries and Areas of Interest (SCCAI) 2010. The current standard, like the previous standard, is also based on the International Standard for country codes ISO 3166-1:2006Footnote 1, and has been modified for consistency with Canadian norms. This standard includes a classification variant Countries and Areas of Interest for Social Statistics – SCCAI 2011 that provides standard groupings of countries and associated codes for publication purposes. Usage notes are included with the standard.

Conformity to relevant internationally recognized standards

This standard is compatible with the composition of geographical macro-regions and geographical sub-regions of the United Nations Statistics DivisionFootnote 2; however, some differences remain. The main differences are:

  • In this standard, Bermuda is included within the sub-region Caribbean and Bermuda while it is part of Northern America in the United Nations groupings;
  • The macro-region Oceania is not further divided into sub-regions in SCCAI;
  • The West Central Asia and the Middle East is one sub-region in SCCAI while most of the countries found here are in two sub-regions: Central Asia, and Western Asia in the United Nations groupings;
  • Estonia, Latvia and Lithuania are included with Eastern Europe in SCCAI while they are part of Northern Europe within the United Nations groupings;
  • Finally, some French sub-region names used by the United Nations have been modified in the SCCAI to make them simpler and more consistent with Canadian convention.

Footnotes

Footnote 1

International Organization for Standardization, ISO 3166 code lists (accessed February 16, 2012). The country list accessed contains updates from Newsletters of ISO 3166-1:2006, including updates from Newsletter ISO 3166-1:2006 VI-11 published on November 8, 2011.

Return to footnote 1 referrer

Footnote 2

United Nations Statistics Division, Standard Country or Area Codes for Statistical Use (accessed February 16, 2012).

Return to first footnote 2 referrer

Countries and Areas of Interest for Social Statistics – SCCAI 2010

Introduction to the classification

The variant Countries and Areas of Interest for Social Statistics – SCCAI 2010 was developed to create groupings of countries to enable the production of integrated statistics when publishing social statistics data.

The variant Countries and Areas of Interest for Social Statistics has three levels: 6 geographical macro-regions, 19 geographical sub-regions and 249 countries or areas of interest. This variant is defined in terms of countries or areas of interest in the Standard Classification of Countries and Areas of Interest (SCCAI) 2010. The hierarchical structure of the classification shows the relationship between the three levels of the classification variant.

This variant has a coding structure built on the United Nations numeric codes (NUM-3) for countries or areas. These three-digit codes are preceded by two numeric digits where the first digit represents the macro-regions and the second digit identifies the sub-regions within the macro-region; together these five-digit codes form the SCCAI code.

These groupings are based on those used historically for Statistics Canada's Census of Population, place of birth variable.

Relation to previous standard

This is a revision of the previous Standard Classification of Countries and Areas of Interest (SCCAI) 2009. The current standard, like the previous standard, is also based on the International Standard for country codes ISO 3166-1:2006Footnote 1, and has been modified for consistency with Canadian norms. This standard includes a classification variant Countries and Areas of Interest for Social Statistics – SCCAI 2010 that provides standard groupings of countries and associated codes for publication purposes. Usage notes are included with the standard.

Conformity to relevant internationally recognized standards

This standard is compatible with the composition of geographical macro-regions and geographical sub-regions of the United Nations Statistics DivisionFootnote 2; however, some differences remain. The main differences are:

  • In this standard, Bermuda is included within the sub-region Caribbean and Bermuda while it is part of Northern America in the United Nations groupings;
  • The macro-region Oceania is not further divided into sub-regions in SCCAI;
  • The West Central Asia and the Middle East is one sub-region in SCCAI while most of the countries found here are in two sub-regions: Central Asia, and Western Asia in the United Nations groupings;
  • The former Soviet Baltic republics are included with Eastern Europe in SCCAI while they are part of Northern Europe within the United Nations groupings;
  • Finally, some French sub-region names used by the United Nations have been modified in the SCCAI to make them simpler and more consistent with Canadian convention.

Footnotes

Footnote 1

International Organization for Standardization, ISO 3166 code lists (accessed December 23, 2010).The country list accessed contains updates from Newsletters of ISO 3166-1:2006, including updates from Newsletter ISO 3166-1:2006 VI-8 published on December 15, 2010.

Return to footnote 1 referrer

Footnote 2

United Nations Statistics Division, Standard Country or Area Codes for Statistical Use (accessed December 23, 2010).

Return to first footnote 2 referrer

Countries and Areas of Interest for Social Statistics – SCCAI 2009

Introduction to the classification

The variant Countries and Areas of Interest for Social Statistics – SCCAI 2009 was developed to create groupings of countries to enable the production of integrated statistics when publishing social statistics data.

The variant Countries and Areas of Interest for Social Statistics has three levels: 6 geographical macro-regions, 19 geographical sub-regions and 247 countries or areas of interest. This variant is defined in terms of countries or areas of interest in the Standard Classification of Countries and Areas of Interest (SCCAI) 2009. The hierarchical structure of the classification shows the relationship between the three levels of the classification variant.

This variant has a coding structure built on the United Nations numeric codes (NUM-3) for countries or areas. These three-digit codes are preceded by two numeric digits where the first digit represents the macro-regions and the second digit identifies the sub-regions within the macro-region; together these five-digit codes form the SCCAI code.

These groupings are based on those used historically for Statistics Canada's Census of Population, place of birth variable.

Relation to previous standard

This is a revision of the previous standard List of Countries, Dependencies and Other Areas of Interest. The current standard, like the previous standard, is also based on the International Standard for country codes ISO 3166-1:2006Footnote 1, but the current standard has been modified for consistency with Canadian norms. This standard includes a classification variant Countries and Areas of Interest for Social Statistics – SCCAI 2009 that provides standard groupings of countries and associated codes for publication purposes. New usage notes are included with the standard.

Conformity to relevant internationally recognized standards

This standard is compatible with the composition of geographical macro-regions and geographical sub-regions of the United Nations Statistics DivisionFootnote 2; however, some differences remain. The main differences are:

  • In this standard, Bermuda is included within the sub-region Caribbean and Bermuda while it is part of Northern America in the United Nations groupings;
  • The macro-region Oceania is not further divided into sub-regions in SCCAI;
  • The West Central Asia and the Middle East is one sub-region in SCCAI while most of the countries found here are in two sub-regions: Central Asia, and Western Asia in the United Nations groupings;
  • The former Soviet Baltic republics are included with Eastern Europe in SCCAI while they are part of Northern Europe within the United Nations groupings;
  • Finally, some French sub-region names used by the United Nations have been modified in the SCCAI to make them simpler and more consistent with Canadian convention.

Footnotes

Footnote 1

International Organization for Standardization, ISO 3166 code lists (accessed June 24, 2010).

Return to footnote 1 referrer

Footnote 2

United Nations Statistics Division, Standard Country or Area Codes for Statistical Use (accessed June 24, 2010).

Return to first footnote 2 referrer

National Occupational Classification (NOC) 2011

Introduction

Preface

This publication represents the third revision of the National Occupational Classification (NOC) system and the National Occupational Classification for Statistics (NOC-S). The NOC was jointly developed by Human Resources and Skills Development Canada and Statistics Canada and has been maintained in partnership since the first edition published in 1991/1992. However, until this revision, NOC and NOC-S differed in their major group structures and, consequently, in their coding systems. The publication of NOC 2011 on this twentieth anniversary of the classification system reflects the unification of the two versions. With the adoption of NOC 2011 all differences between the classifications used by Human Resources and Skills Development Canada and by Statistics Canada have been eliminated. Furthermore, this has been accomplished while maintaining the advantages of both former classification versions.

NOC 2011 would not have been possible without the significant contribution of a number of individuals and groups. Their commitment to excellence is evident in this revised edition of the foundational system used for describing occupations in the Canadian labour market and for managing the collection and reporting of occupational statistics. The collaborative partnership between the two departments has ensured that the quantitative and qualitative information on occupations is reliable, timely and relevant for a wide range of audiences.

Acknowledgements

This major, structural revision of the NOC was accomplished under the guidance of Alice Born, Director of Standards Division, Statistics Canada and Christian Boucher, Director, Labour Market Information (LMI) Division of the Temporary Foreign Worker and Labour Market Information Directorate, Human Resources and Skills Development Canada. Subject matter expertise was provided from Statistics Canada by Debra Mair of Standards Division and Sandra Swain of Labour Statistics Division. From Human Resources and Skills Development Canada, subject matter expertise was provided by Clara Hamory and Ian McRae of LMI Division. Service Canada's Regional Labour Market Information Directors, their staff and provincial colleagues, as well as Statistics Canada's Methods and Standards Committee and its Advisory Committee on Labour and Income Statistics provided important input to the development of NOC 2011. The many stakeholders who responded to the public online consultation for the 2011 Revision of the NOC, hosted by both departments, provided valuable input which is much appreciated.

The realization of NOC 2011 was dependent on the direct involvement and hard work of a team of occupational research analysts and assistants from both Human Resources and Skills Development Canada and Statistics Canada. The overall process also included consultations with an Interdepartmental Committee of representatives from several government departments that are key users of the NOC. The professionalism and dedication of all those involved in the revision process is reflected in the results of this project which has unified the two variants of the classification while maintaining the advantages of both systems. This success is attributable to the co-operation between these stakeholders and to the partnership between Human Resources and Skills Development Canada and Statistics Canada.

Statistics Canada's Internet version of this publication was created jointly by Sylvain Boucher and Niloufar Zanganeh. Their Systems Engineering Division and Administrative and Dissemination Systems Division were responsible for their systems development of the PDF and HTML versions. Human Resources and Skills Development Canada's NOC content development was undertaken by the analysts of LMI Division's Occupational Research unit and Web development by Lyne Philion, Linda Trudel and Jules-André Léger with the help of the Skills and Labour Market Information team of Innovation, Information and Technology Branch.

Both Statistics Canada and Human Resources and Skills Development Canada wish to acknowledge the valuable input of other individuals and groups too numerous to name. Research consultants, academics, professional associations, sector organizations, educators as well as employers and workers throughout the Canadian labour market provided occupational information and advice that informed this revision process. Their contribution has ensured that the quality and integrity of NOC 2011 has been maintained and it will continue to be the authoritative foundational reference and framework for occupational data and descriptive information.

Background

The National Occupational Classification (NOC) 2011 updates both the National Occupational Classification of Human Resources and Skills Development Canada and Statistics Canada's National Occupational Classification for Statistics (NOC-S) which was based on it. It is the nationally accepted taxonomy and organizational framework of occupations in the Canadian labour market. This revision represents the 20th anniversary of the classification and reflects the unification of Human Resources and Skills Development Canada's NOC and Statistics Canada's NOC-S. This revised edition eliminates the differences between the two former systems and incorporates the advantages of both. Through the collaborative partnership between Human Resources and Skills Development Canada and Statistics Canada the department and the statistical agency introduce the revised and unified National Occupational Classification - NOC 2011.

As in the past, this revision is based on extensive occupational research, analysis and consultation conducted across the country. In the decade since its first structural revision in 2001, the labour market has evolved significantly. Technological innovation, further globalization of the economy and restructuring of the workplace have impacted many occupations. In addition to content changes, the harmonization of the NOC and the NOC-S has resulted in a new classification structure.

The NOC is designed to classify occupational information from statistical surveys. It is also used in a range of contexts to compile, analyze and communicate information about occupations. Occupational information is of critical importance for the provision of labour market and career intelligence, skills development, occupational forecasting, labour supply and demand analysis, employment equity and numerous other programs and services. It provides a standardized framework for organizing the world of work in a manageable, understandable and coherent system.

The basic principle of classification of the NOC is that of kind of work performed. Occupations are identified and grouped primarily in terms of the work usually performed, this being determined by the tasks, duties, and responsibilities of the occupation. Factors such as the materials processed or used, the industrial processes and the equipment used, the degree of responsibility and complexity of work, as well as the products made and services provided, have been taken as indicators of the work performed when combining jobs into occupations and occupations into groups.

An occupation is defined as a collection of jobs, sufficiently similar in work performed to be grouped under a common label for classification purposes. A job, in turn, encompasses all the tasks carried out by a particular worker to complete their duties.

Structure of NOC 2011

The National Occupational Classification 2011 is a four-tiered hierarchical arrangement of occupational groups with successive levels of disaggregation. It contains broad occupational categories, major, minor and unit groups.

10 broad occupational categories

Each broad occupational category has a unique one-digit code number and is composed of one or more major groups.

40 major groups

Each major group has a unique two-digit code number and is composed of one or more minor groups. The first digit of this code indicates the broad occupational category to which the major group belongs.

140 minor groups

Each minor group has a unique three-digit code number and is composed of one or more unit groups. The first two digits of this code indicate the major group to which the minor group belongs.

500 unit groups

Each unit group has a unique four-digit code. The first three digits of this code indicate the major and minor groups to which the unit group belongs.

For example:

0
Management occupations
00
Senior management occupations
001
Legislators and senior management
0011
Legislators
0012
Senior government managers and officials
0013
Senior managers - financial, communications and other business services
0014
Senior managers - health, education, social and community services and membership organizations
0015
Senior managers - trade, broadcasting and other services, n.e.c.
0016
Senior managers - construction, transportation, production and utilities

The broad occupational category code, designated by a single digit, is repeated at all levels. Major group codes are created by adding a second digit. This digit appears in the second position at all lower levels in the structure. Minor group codes add a third digit. Finally, the 4-digit unit group codes contain the digit identifying the broad occupational category, followed by the digit identifying the major group and the digit identifying the minor group and a last digit identifying the unit group.

There are approximately 40,000 occupational titles classified in the 500 unit groups of the NOC 2011. Some of these titles are clearly occupations, such as librarian and chef, while others reflect specializations within an occupational area, such as music librarian and pastry chef. Still others represent a range of jobs, such as furniture assembler and sawmill machine operator.

These titles are used to describe the work performed by many individuals holding similar jobs within an occupational area. The list of titles in the NOC is not meant to be exhaustive, but attempts to cover the most commonly used and universally understood labels that identify work in the labour market.

Abbreviations

Few abbreviations are used in this classification. Particular attention should be given to the abbreviation n.e.c. (not elsewhere classified). As an occupational qualifier it is occasionally used in the labels of major, minor and unit groups to refer to occupations not elsewhere classified; e.g. 065 Managers in customer and personal services, n.e.c. indicates that this class includes managers in customer and personal services that are not classified elsewhere in the classification.

Language

The NOC is available separately in both official languages. It is important to note that the French version includes only titles commonly used in French and proper to the milieu and, therefore, these are not normally translations of the English titles. The classification structure is the same in both languages.

Unit group labels are presented in gender-neutral format in French identifying the masculine and feminine titles separated by a slash. Where relevant, this structure is used in English as well. The illustrative example titles are also presented in gender-neutral format. The NOC descriptions are written using the masculine form as they refer to all workers within the included occupations. This has been done in order to lighten the text and to reduce reading burden.

Modifying terms

Modifying terms have been added to several job titles, as extensions, to designate the industrial sector or the domain of expertise. If applicable, this information is preceded by a dash at the end of the title (cashier supervisor - retail trade) to distinguish between similar titles. These modifying terms specify where the titles appear in the classification structure (painter - visual arts; painter - manufacture of motor vehicles). This information should be considered when coding job titles.

Format of unit group descriptions

Each NOC unit group description consists of several standardized sections which define and describe its content.

Lead statement

This section provides a general description of the content and boundaries of the unit group and indicates the main activities of occupations within the unit group. It also indicates the kinds of industries or establishments in which the occupations are found. The list of places of employment is not always exhaustive, but can assist in clarifying the occupations described and in differentiating them from occupations found in other groups.

Illustrative examplesFootnote 1 / Example titlesFootnote 2

This section is a list of titles commonly used in the labour market. The titles are intended to illustrate the contents and range of the occupational group. This is not an exhaustive list of titles.

ExclusionsFootnote 1 / Classified elsewhereFootnote 2

This section clarifies the boundaries of the unit group by identifying related unit groups and similar occupations that are classified elsewhere. Unit groups or individual occupations are cited in this section when they bear a functional similarity to the unit group or when similar titles occur.

Main duties

This section lists some of the tasks or duties performed in the occupations in the unit group. Depending on the contents of the unit group, one of three formats is used.

  • A series of statements that can be applied to all occupations in the unit group. This format was selected for unit groups that contain a single core occupation, such as 1242 Legal administrative assistants and 2146 Aerospace engineers. This format was also selected for unit groups that contain a range of related titles that nevertheless share a set of common duties, such as 1411 General office support workers and 9417 Machining tool operators.
  • Two or more sub-sets of occupations with a series of statements that apply to each component. This format was selected for unit groups that consist of two or more sub-components which, while similar enough to be in the same unit group, can be described separately. Examples of unit groups with this format are 3141 Audiologists and speech-language pathologists and 5125 Translators, terminologists and interpreters.
  • A series of brief descriptive statements that are linked to specific occupations within a group. This format was selected for unit groups that contain a series of occupations which, while similar enough to be in the same unit group, can be described separately. Examples of unit groups with this format include 4423 By-law enforcement and other regulatory officers, n.e.c. and 5226 Other technical and co-ordinating occupations in motion pictures, broadcasting and the performing arts.

For some unit groups, a statement appears at the end of the tasks performed or main duties section, identifying specializations that exist within the occupational area encompassed by the unit group.

Employment requirements

This section describes the employment requirements for the unit group. Several types of requirements are identified in this section and are listed in the following order.

  • Type and level of formal education: for example, secondary school, college diploma, university degree. Efforts were made to be as specific as possible, though many unit groups have a range of acceptable educational requirements.
  • Specific training: for example, apprenticeship training, on-the-job training, training courses specific to an occupation.
  • Experience in another occupation: for example, supervisors usually require several years of experience in the occupation that they supervise.
  • Licences, certificates or registration: for example, regulatory requirements to practice in a regulated profession, special licenses to operate certain kinds of vehicles.
  • Other requirements: for example, athletic ability or artistic talent.

Note: Some occupations are designated as regulated professions and trades. Regulations are subject to change and may vary across jurisdictions. The most reliable information on regulatory requirements for occupations is found on the Web sites of provincial regulatory organizations and licensing authorities.

The Employment requirements section does not attempt to describe personal suitability requirements that are assessed by employers as part of the hiring process.

Some occupations have very definite employment requirements while for others, there is no consensus or a range of acceptable requirements exist. To reflect this variation in the labour market, this section describes employment requirements using the following terminology:

  • "... is required" - to indicate a definite requirement;
  • "... is usually required" - to indicate something that is usually required by the majority of employers, but not always required by all employers; and
  • "... may be required" - to indicate something that may be required by some employers, but on a less frequent basis.

Note: For reasons of brevity, in this section the term college includes the following types of post-secondary institutions: community colleges, CÉGEPS, technical institutes, trade schools and agricultural colleges. Where relevant, in some provinces, it may also include private training organizations, music conservatories and other non-degree granting institutions.

Additional information

This section appears in some unit group descriptions. It provides information on the following:

  • progression to other occupations (such as supervisory or management positions) based on transferability of skills from acquired occupational experience;
  • mobility patterns, such as inter- and intra-occupational transferability of skills (for example, identifying occupations that are part of internal lines of progression or specializations within a subject matter area);
  • trends and forthcoming changes in the unit group's employment requirements; and
  • other information to clarify and define the unit group.

Related classifications: NAICS, Class of Worker

The classification of occupations does not stand alone but must be understood as being related to other classifications, such as the North American Industry Classification System (NAICS) and that of Class of Worker. Each of these classifications supplements the NOC 2011 in presenting a rounded picture of the nature of a person's job.

North American Industry Classification System (NAICS)

The industrial qualifier which may accompany the job title:

  1. Indicates the type of economic activity with which the job is usually associated. (It is important to note that the assignment of an industrial qualifier does not necessarily limit a job to that industry. These qualifiers are merely indicative of the possible areas of activity in which the job may be found.)
  2. Permits the assignment of similar occupational titles to different occupation groups where the duties vary between industries.
  3. Aids in defining the specific occupations and helps the coder grasp the underlying principles of this classification.

The industry in which the individual is employed is determined by the kind of economic activity of the establishment. The establishment is usually a factory, mine, farm, store, other place of business or an institution for which a number of basic production variables can be compiled.

It is important to note the conceptual differences between an industry classification and an occupation classification. An establishment can employ individuals performing completely different occupations, and these are classified to appropriate occupational groups, but the industrial classification of each individual employed in the establishment should be the same and is determined by the nature of the product made or service rendered. In other words, the nature of the factory, business or service in which the person is employed does not determine the classification of the occupation, except to the extent that it enables the nature of the duties to be more clearly defined.

Class of Worker

Class of worker refers to an individual's employment relationship to the business in which he or she works, as employee or self employed, including unpaid family worker, and thus provides another means of describing the work. The NOC 2011 does not indicate the class of worker classification for each occupation since many occupations contain both jobs held by employees and jobs of self-employed individuals. However, a general rule has been established for coding purposes and is discussed in full under the section on Coding.


NOC 2011

NOC 2011 replaces the National Occupational Classification (NOC) of Human Resources and Skills Development Canada and Statistics Canada's National Occupational Classification for Statistics (NOC-S). These classifications were revised jointly by Human Resources and Skills Development Canada and Statistics Canada every 5 years according to the census cycle. The maintenance of the classification alternates between minor updates and structural revisions. Only in 10-year structural revisions are such changes considered as: the creation of new classes, the collapsing of classes, the moving of classes in the structure or the moving of content between classes.

The 2011 revision represents a major structural realignment. A key objective of this revision was to harmonize the coding structures and eliminate all other differences between the two classifications, fulfilling a request heard from users of both the NOC and the NOC-S. The result is the unified NOC 2011 which was developed through the joint efforts of Human Resources and Skills Development Canada and Statistics Canada and will be used by both.

Separate concordance tables explain the revisions to both classification systems that have resulted in the harmonized classification structure for NOC 2011.

In addition to these changes, for NOC 2011, a new variant of the classification has been developed at a high level of aggregation. It is designed to better support the analysis of highly aggregated data (See: Variant for highly aggregated data).

Citation

The National Occupation Classification 2011 is a joint product of Statistics Canada and Human Resources and Skills Development Canada. The appropriate department should be cited when materials are used. The structure, class labels, class definitions (lead statements), example titles and exclusions were jointly developed and are to be attributed to both departments. The content of the main duties, employment requirements and additional information sections as well as the theoretical framework and the accompanying definitions of skill level and skill type are the intellectual property of Human Resources and Skills Development Canada and are to be attributed to the department when cited.

Comparison of NOC 2006 and NOC-S 2006 to NOC 2011

The major difference between the NOC and the NOC-S had been the greater use in the NOC of skill level as a classification criterion. Whereas the NOC organized occupations by 10 skill types and four skill levels, NOC-S relied more on skill type in defining its major groups. The NOC 2011 uses the organizational structure of the NOC (See: NOC Classification criteria).

In order to incorporate skill level as an organizational principle, several major groups from NOC-S 2006 were changed and a new coding structure reflecting the skill type by skill level numerical coding of the NOC was adopted. The relationship between the major groups of NOC 2011 and NOC-S 2006 is detailed in the concordance tables (See: NOC 2011 - NOC-S 2006 and NOC-S 2006 - NOC 2011).

In order to provide at the major group level a comparable level of detail to that which had been provided by the NOC-S major groups, the number of major groups was increased from the 26 major groups of NOC 2006 to 40 major groups in NOC 2011. The relationship between the major groups of NOC 2011 and NOC 2006 is detailed in the concordance tables (See: NOC 2006 - NOC 2011).

The unit group descriptions of NOC 2011 contain all the types of information carried in NOC 2006. In comparison to NOC-S 2006, users will find additional information on the activities performed by workers in each unit group and a section related to educational and/or training requirements for entering an occupation. These sections provide further information on the nature of the jobs included in each unit group, help to code job titles to the correct class and help identify the relative distinctions between skill levels for occupations.

The NOC and NOC-S had also differed in their treatment of military personnel. The NOC classified military personnel whose occupations had a civilian counterpart in the group appropriate to that civilian occupation. The NOC-S classified all military personnel on the basis of rank to one of two unit groups: one for commissioned officers and one for other ranks. NOC 2011 follows the approach used in NOC-S, with all military personnel being classified to either 0433 Commissioned officers of the Canadian Forces or 4313 Non-commissioned ranks of the Canadian Forces. The adoption of the NOC-S approach allowed this difference to be resolved with no impact on the historical comparability of data.

In this structural revision, various changes were also made at the unit group level to enable the classification to continue to provide a framework for the provision of relevant and reliable information on the occupational structure of Canada. New unit groups have been formed either by combining unit groups or parts of unit groups from 2006 and content has been moved between skill types and levels. The full relationship between the unit groups of NOC 2011 and those of NOC and NOC-S 2006 is presented in the concordances, but some highlights are noted here.

Some unit groups were moved to better reflect the skill type of the work performed. For example, Loan officers, Customer service representatives - financial, and Customer service, information and related clerks all moved from Business to Sales and service. Public relations and communications professionals moved from Art and culture to Business. Protective service occupations, including the military, police and firefighters, moved from Sales and service to Government services. Care providers and educational assistants moved from Sales and service to Community and education services. Certain trades, including upholsterers and tailors, moved from Trades and equipment to Services. As a final example, Power system, station and auxiliary equipment operators moved from Trades and equipment operators to Utilities.

In other cases, only part of a group was moved. For example, legal assistants moved out of Paralegal and related occupations, in Law, into Legal administrative assistants, in Business. Advertising and marketing managers moved out of Sales, marketing and advertising managers, in Sales, into Advertising, marketing and public relations managers, in Business services. Similarly, Library assistants moved from Library and archive technicians and assistants, in Education, law and social, community and government services, to Library assistants and clerks, in Business, finance and administration.

Other unit groups were moved to better reflect the occupation's current skill level. For example, the group for Non-commissioned ranks of the Canadian Forces was moved from skill level C to skill level B to recognize the training that occurs post-recruitment. Water and waste treatment plant operators also moved from skill level C to B due to the changing requirements associated with this occupation. Farmers and farm managers were moved into management to recognize the significant management component in these occupations.

As was the case with skill type, here also there were cases where only part of a unit group was moved. For example, midwives were moved from skill level B to skill level A into a new unit group, Allied primary health practitioners. Pharmacy technicians and physiotherapy assistants moved from skill level C to skill level B, now included, respectively, in Other medical technologists and technicians (except dental health) and Other technical occupations in therapy and assessment.

Finally, some unit groups were combined. Administrative clerks were merged with General office clerks due to the increasing similarity in the job titles and work performed in these two unit groups. In other cases, particularly in manufacturing, unit groups that have been declining in size were combined with related groups.

In addition to these structural changes, the 2011 revision also provided an opportunity to add many new job titles in order to reflect changing terminology and new technology in the workplace and the rise of new occupations and specializations. Too numerous to list, these additions included titles ranging from oil and gas contractor to mystery shopper and from physician assistant to seismic buried facilities locator.

NOC classification criteria

The two major attributes of jobs used as classification criteria in developing the NOC are skill type and skill level. A description of skill levels is presented first as the definitions of skill types incorporate some information related to the concept of skill level. Other factors, such as industry and occupational mobility, are also taken into consideration.

Skill level

Skill level is defined generally as the amount and type of education and training required to enter and perform the duties of an occupation. In determining skill level, the experience required for entry, and the complexity and responsibilities typical of an occupation are also considered in relation to other occupations.

Four skill level categories are identified in the NOC. Each major, minor and unit group is assigned to one of the skill levels.

The skill level categories are broad aggregates, reflecting four commonly accepted educational, training or preparatory routes for entering employment. Requirements for individual unit groups or occupations may overlap between the boundaries of the skill levels. For example, some occupations can be entered with either a university degree or a college diploma. When the entry requirements for a unit group or occupation reflect a range of possible educational and training specifications, skill level placement of the group was determined by considering several factors. These include the requirements most generally demanded by employers, the minor group context, complexity of overall responsibilities and knowledge requirements as well as further training and specialization acquired on the job.

The classification describes the educational and training requirements for occupations. However, the education and experience of particular job incumbents may not correspond exactly to the level described. Individuals may be over-qualified for their work or they may work in occupations for which the entry requirements have changed after they became employed.

It is important to note that the skill level categories are not intended to designate socio-economic status or prestige. Rather they are intended to reflect actual occupational entry requirements. These requirements are expressed in terms of the formal educational system and other types of training specified by employers.

Management occupations, while considered a skill type, are assigned to the skill level A category. These occupations are at the top of organizational hierarchies and as such, are characterized by high levels of responsibility, accountability and subject matter expertise gained through either formal education or extensive occupational experience. Management occupations span the entire classification structure and are found in all sectors or areas of the labour market. A range of factors are taken into consideration as determinants for employment in management occupations.

The skill level categories of the NOC are outlined and defined below.

NOC skill level criteria - education/training and other criteria

Skill level A

  • University degree (bachelor's, master's or doctorate)

Skill level B

  • Two to three years of post-secondary education at community college, institute of technology or CÉGEP

    or
  • Two to five years of apprenticeship training

    or
  • Three to four years of secondary school and more than two years of on-the-job training, occupation-specific training courses or specific work experience
  • Occupations with supervisory responsibilities are also assigned to skill level B.
  • Occupations with significant health and safety responsibilities (e.g., fire fighters, police officers and licensed practical nurses) are assigned to skill level B.

Skill level C

  • Completion of secondary school and some short-duration courses or training specific to the occupation

    or
  • Some secondary school education, with up to two years of on-the-job training, training courses or specific work experience

Skill level D

  • Short work demonstration or on-the-job training

    or
  • No formal educational requirements

Skill level is referenced in the code for all occupations with the exception of management occupations. For all non-management occupations the second digit of the numerical code corresponds to skill level. Skill levels are identified as follows: level A - 0 or 1; level B - 2 or 3; level C - 4 or 5; and level D - 6 or 7.

Skill type

Skill type is defined as the type of work performed, although other factors related to skill type are also reflected in the NOC. One of these factors is similarity with respect to the educational discipline or field of study required for entry into an occupation. Another factor is the industry of employment where experience within an internal job ladder or within a specific industry is usually a prerequisite for entry. The 10 skill types, 0 to 9, are presented below and are also identified in the first digit of the NOC numerical code for all occupations.

The ten broad occupational categories of the NOC are based on skill type

0. Management occupations

This skill type category contains legislators, senior management occupations and middle management occupations. While management occupations are defined as a skill type, they are also found throughout all other skill type areas of the classification. The first digit of the code for all management occupations is 0.

These occupations are considered to be at the top of the organizational hierarchy of workplaces or businesses. Decision-making that affects the organization as a whole, or departments within organizations, is undertaken by management. As such, management is characterized by high levels of responsibility, accountability and subject matter expertise. Expertise is acquired through either formal education or extensive occupational experience. For these reasons all management occupations in the NOC 2011 are also included within skill level A.

1. Business, finance and administration occupations

This category contains occupations that are concerned with providing financial and business services, administrative and regulatory services and clerical supervision and support services. Some occupations in this category are unique to the financial and business service sectors; however, most are found in all industries.

Often, occupations at skill levels A and B are supplied from educational programs specific to the profession or occupation. Some occupations at skill level B are also supplied from experienced workers in related administrative support occupations.

2. Natural and applied sciences and related occupations

This category contains professional and technical occupations in the sciences, including physical and life sciences, engineering, architecture and information technology.

Occupations in this skill type category require post-secondary education in an appropriate scientific discipline. Progression from occupations in skill level B to occupations in skill level A is usually dependent on completion of additional formal education.

3. Health occupations

This category includes occupations concerned with providing health care services directly to patients and occupations that provide support to professional and technical staff. Most occupations in this skill type category require post-secondary education in a related health care program. Progression from occupations in skill level B to occupations in skill level A is usually dependent on completion of additional formal education. Occupations in skill level C require short training programs.

4. Occupations in education, law and social, community and government services

This skill type category includes a range of occupations that are concerned with law, public protective services, teaching, counselling, conducting social science research, developing government policy, and administering government and other programs.

Occupations in this skill type category usually require completion of a related post-secondary program. Progression from occupations in skill level B to occupations in skill level A is not usually possible without completion of additional formal education.

5. Occupations in art, culture, recreation and sport

This skill type category includes professional and technical occupations related to art and culture, including the performing arts, film and video, broadcasting, journalism, writing, creative design, libraries and museums. It also includes occupations in recreation and sport.

This category is characterized by occupations which are linked by subject matter to formal post-secondary educational programs but which have, for the most part, a range of acceptable qualifications. Occupations in this category are also characterized by a requirement for creative talent, such as for designers and performers, or for athletic ability. Unit groups for occupations that usually require university graduation in a professional discipline, such as journalism or library science, have been classified in skill level A. Most others have been classified in skill level B in recognition of the wide range of entry routes that are possible.

6. Sales and service occupations

This skill type category contains sales occupations, personal services and security service occupations, and occupations related to the hospitality and tourism industries.

Occupations in skill level B of this category can be linked, for the most part, to formal post-secondary or occupation-specific training programs. Others are characterized by periods of formal on-the-job training other than apprenticeship. Progression from occupations in skill level C or D to those in skill level B usually require completion of related training programs. Some progression through experience is possible for supervisory positions.

7. Trades, transport and equipment operators and related occupations

This skill type category includes construction and mechanical trades, trades supervisors and contractors and operators of transportation and heavy equipment. These occupations are found in a wide range of industrial sectors, with many occurring in the construction and transportation industries.

This category includes most of the apprenticeable trades, including all of those related to the construction industry. Other occupations in this category usually require completion of college or other programs combined with on-the-job training. Progression to supervisory or self-employed contractor status is possible with experience. There is limited mobility or transferability of skills among occupations in this category due to specific apprenticeship, training and licensing requirements for most occupations.

8. Natural resources, agriculture and related production occupations

This category contains supervisory and equipment operation occupations in the natural resource-based sectors of mining, oil and gas production, forestry and logging, agriculture, horticulture and fishing. Most occupations in this category are industry specific and do not occur outside of the primary industries.

Occupations within skill level B of this category generally require completion of college or other post-secondary training programs. Some, however, are characterized by industry-based training and progression through experience.

9. Occupations in manufacturing and utilities

This category contains supervisory and production occupations in manufacturing, processing and utilities.

Occupations in this category are characterized by internal progression and on-the-job training. Workers typically start out in these occupations at entry-level positions and progress to increasingly higher skilled occupations through experience. Mobility between employers or industries may be limited by seniority provisions of collective agreements. The occupations in skill level B of this category are increasingly technical in nature and post-secondary training programs are required for some.

Industry

Industry and occupation are separate variables which can be cross-tabulated to provide detailed information on employment. However, many occupations are found almost solely within one particular industry. For example, mining and automobile assembly occupations occur each within their respective industrial sectors.

During the original research and development of the NOC, it was realized that in many industries, occupational mobility is determined more by internal job ladders than by functional specialization. In consequence, some unit groups include workers of a particular skill level within a specific industry. Although the occupational categorisation resembles in part an industrial categorisation, the variables remain separate and distinct.

Industry was used in the development of classification categories for senior management occupations, for occupations in natural resources, agriculture and related production and for occupations in manufacturing and utilities.

Occupational mobility

In developing the NOC, an effort was made to consider mobility or transferability of skills between occupations. The objective was to develop unit groups where the potential for mobility, or substitution of workers, would be greater within the group than between groups. Movement within groups usually follows when the group is homogeneous in skill level and skill type, indicating increased potential for transferability of competencies and development of specialization. Movement between groups, or inter-occupational mobility, usually reflects a change in skill level (e.g., vertical mobility) or a change in skill type (e.g., acquisition of new responsibilities and diversified skills).

The degree of occupational mobility that exists for unit groups varies. Many unit group descriptions include a statement that indicates the potential for, and type of, mobility that characterizes the unit group.

Other classification considerations

In addition to the previously mentioned criteria, other factors were considered in determining the boundaries between unit groups and the contents of each group. These additional factors were the size of the unit groups and the codability or operational feasibility of the groups. Codability relates to the ease of accurately coding or assigning reported job titles from survey respondents to the occupational groups of the classification.

The size (or estimated number of workers) of the unit group was considered for reasons of statistical reliability and confidentiality. Generally, unit groups which contain fewer than 1,000 Canadian workers have not been delineated.

Because the NOC structure is used to code responses to the National Household Survey and other surveys, it must provide a set of unit groups that can be used for this operational application. The insufficient precision of some survey responses and ambiguities of language were given consideration in finalizing the unit groups.

The NOC Matrix

A matrix classifying the NOC major and minor groups has been developed to provide an overview of the entire classification and to show the organization of the groups by both skill type and skill level.

There are 10 skill types in the NOC identified as 0 to 9. The vertical columns of the matrix correspond to nine of the 10 skill type categories with the exception of management. Management, the first skill type or 0, is organized across the top of the matrix and spans all nine skill types as it is found within all occupational sectors or categories. The first digit of each code identifies the major and minor group as belonging to one of the ten skill type categories, 0 to 9.

The horizontal rows of the matrix correspond to the four skill level categories. Management occupations are by default included in the skill level A category. For all non-management occupations, the second digit of each code identifies the major and minor group as belonging to one of the four skill level categories.

Within each cell of the matrix, the major and minor groups that belong to each skill type and skill level category are listed. Management occupations are the exception, which span all skill type categories and are included in skill level A. The second digit of management occupations identifies the occupational sector of management, for example 031 Managers in health care. (See: Matrix).

Issues and conventions of the NOC

Some of the many issues that were encountered in the development of the NOC and the conventions adopted in response are discussed in the following paragraphs.

Management occupations

Management occupations present a special problem for reliable coding of occupational survey responses. In many cases there is little indication of the level of responsibility, the size of the enterprise or division managed, or the field of specialization.

To be of practical use, a classification of managers must be a compromise between the theoretically optimal and the practical solutions.

Senior management occupations (in major group 00) have been divided on the basis of industry of employment into six unit groups.

Middle and other management occupations are divided into three major groups, 18 minor groups and 42 unit groups on the basis of specialization (e.g., Purchasing managers) or industry of employment (e.g., Postal and courier services managers). In certain cases (e.g., Managers in transportation) groups defined by industry also contain managers in that specialization regardless of their industry of employment.

Supervisors

Supervisors and foremen/women have generally been classified in skill level B.

In most cases, professional and technical occupations are supervised by managerial or professional personnel respectively. However, where supervisors are identified for professional and technical groups, they are generally classified in the same unit groups as the occupations supervised.

Supervisors in the following occupational categories have been classified in supervisor unit groups or minor groups separate from the workers supervised:

  • administrative services occupations
  • nursing occupations
  • sales and service occupations
  • trades and transport and equipment operators
  • occupations in natural resources and agriculture
  • occupations in manufacturing and utilities.

Most minor and unit groups in the occupational categories listed above have a corresponding supervisory group. Occasionally, as in minor group 431, Occupations in front-line public protection services, supervision is provided by managers and there are no corresponding supervisory groups in major group 43.

Trades

All apprenticeable trades are included in skill level B. Their inclusion does not imply an exact equivalence of skill between all trades, but rather that they occupy a range that lies within the boundaries of this skill level category. Information on entry requirements is provided within each unit group description.

Inspectors, testers and graders

Generally, inspectors who require post-secondary education have been classified in separate unit groups in skill level B or with technicians and technologists, also in skill level B. Other non-technical inspectors, testers, graders and samplers have been included either in separate unit groups covering occupations in processing industries or in unit groups of assemblers and fabricators in manufacturing industries. This is reflective of patterns of employment found within industries and the increasing responsibility for quality control that is placed on manufacturing production workers.

Apprentices and trainees

Apprentices and trainees have been classified in the same unit groups as the occupations for which they are training. Similarly, interns, residents and articling students are classified with their respective professional groups.

This convention has been adopted of necessity to prevent a proliferation of unit groups of apprentices. It is not intended to imply equivalence or interchangeability of apprentices or trainees with fully qualified workers.

NOC 2011 coding system

As indicated previously, the first two digits of each code convey meaning with respect to the group's skill type and skill level category.

For all occupations, including management, the first digit of each code identifies the major, minor and unit group as belonging to one of the skill type categories. For all non-management occupations, the second digit of each code identifies the major, minor and unit group as belonging to one of the four skill level categories.

For management occupations, the first two digits also convey meaning. The first digit is always 0 to convey management, while the second digit conveys the skill type category in which the management occupation is found. All management occupations are included as part of skill level A.

The following charts summarize and illustrate the meanings embedded in the coding system.

Classification structure by the skill type category
The skill type category is... when the first digit is...
Management occupations 0
Business, finance and administration occupations 1
Natural and applied sciences and related occupations 2
Health occupations 3
Occupations in education, law and social, community and government services 4
Occupations in art, culture, recreation and sport 5
Sales and service occupations 6
Trades, transport and equipment operators and related occupations 7
Natural resources, agriculture and related production occupations 8
Occupations in manufacturing and utilities 9
Skill type category
The skill level category is... when the second digit is...
Skill Level A 0 or 1
Skill Level B 2 or 3
Skill Level C 4 or 5
Skill Level D 6 or 7

Important note: For management, the first digit is always 0. Senior managers in major group 00 are generally managers of middle managers, therefore the second digit is also 0. For middle management occupations, the second digit represents the skill type categories, from 1 to 9, as above. All management occupations are included in skill level A.

Examples of codes and their meaning
Code Meaning
9231 The first digit indicates skill type category 9, Occupations in manufacturing and utilities. The second digit indicates skill level category B.
6533 The first digit indicates skill type category 6, Sales and service occupations. The second digit indicates skill level category C.
0212 The first digit 0 always indicates a management occupation. All management occupations are part of skill level A. The second digit indicates management in skill type category 2, Natural and applied sciences and related occupations.

Variant for highly aggregated data

A variant of NOC 2011 has been developed jointly by Statistics Canada and Human Resources and Skills Development Canada. It is based on a review of actual practices in the analysis of highly aggregated occupational data, consideration of the highest aggregation level in the International Standard Classification of Occupations (ISCO) and consultation with potential users.

The variant consists of 10 groupings, from a. to j., that are a convenient and useful way to summarize and analyse more detailed classes. The first three classes are homogeneous on skill level. The remaining classes focus on skill type. All classes consist of entire major groups; no major group is split between classes of the variant.

Variant Aggregation Structure

Variant Aggregation Structure
Variant classes Major groups included
a. Management
  • 00 Senior management occupations
  • 01-05 Specialized middle management occupations
  • 06 Middle management occupations in retail and wholesale trade and customer services
  • 07-09 Middle management occupations in trades, transportation, production and utilities
b. Professional
  • 11 Professional occupations in business and finance
  • 21 Professional occupations in natural and applied sciences
  • 30 Professional occupations in nursing
  • 31 Professional occupations in health (except nursing)
  • 40 Professional occupations in education services
  • 41 Professional occupations in law and social, community and government services
  • 51 Professional occupations in art and culture
c. Technical and paraprofessional
  • 22 Technical occupations related to natural and applied sciences
  • 32 Technical occupations in health
  • 42 Paraprofessional occupations in legal, social, community and education services
  • 43 Occupations in front-line public protection services
  • 52 Technical occupations in art, culture, recreation and sport
d. Administration and administrative support
  • 12 Administrative and financial supervisors and administrative occupations
  • 13 Finance, insurance and related business administrative occupations
  • 14 Office support occupations
  • 15 Distribution, tracking and scheduling co-ordination occupations
e. Sales
  • 62 Retail sales supervisors and specialized sales occupations
  • 64 Sales representatives and salespersons - wholesale and retail trade
  • 66 Sales support occupations
f. Personal and customer information services
  • 63 Service supervisors and specialized service occupations
  • 65 Service representatives and other customer and personal services occupations
  • 67 Service support and other service occupations, n.e.c.
  • 34 Assisting occupations in support of health services
  • 44 Care providers and educational, legal and public protection support occupations
g. Industrial, construction and equipment operation trades
  • 72 Industrial, electrical and construction trades
  • 73 Maintenance and equipment operation trades
h. Workers and labourers in transport and construction
  • 74 Other installers, repairers and servicers and material handlers
  • 75 Transport and heavy equipment operation and related maintenance occupations
  • 76 Trades helpers, construction labourers and related occupations
i. Natural resources, agriculture and related production occupations
  • 82 Supervisors and technical occupations in natural resources, agricultural and related production
  • 84 Workers in natural resources, agriculture and related production
  • 86 Harvesting, landscaping and natural resources labourers
j. Occupations in manufacturing and utilities
  • 92 Processing, manufacturing and utilities supervisors and central control operators
  • 94 Processing and manufacturing machine operators and related production workers
  • 95 Assemblers in manufacturing
  • 96 Labourers in processing, manufacturing and utilities

Coding

The NOC provides an overall structure for classifying occupations according to kind of work performed. The lists of example titles are merely indicative of the types of occupations that fit within specific unit groups. The lists of example titles are not exhaustive nor are they intended to be.

When coding an occupation, all the relevant facts about the job and its environment should be obtained. These include the kind of work performed, the most important activities or duties, the job titles, the kind of business, industry or service, and the class of worker described earlier. The more complete and comprehensive the information the coder is able to assemble about the duties performed by a worker on a particular job, the easier it will be to determine the appropriate classification.

To code an occupation, it is possible to start with either the classification structure or the search tool.

Using the structure

When using the structure, it is best to exploit the hierarchical nature of the classification. First the broad occupational category (skill type) which seems most likely to contain the job should be identified. Next the most appropriate major group within the broad occupational category should be found. Skill level can also provide a guide to locating major groups by considering titles with terms such as "technical", "supervisor", "helper", and "labourer". The process should be continued to find the most appropriate minor group within the major group selected. Finally the most appropriate unit group within the minor group selected should be identified. The unit group definition should be read carefully before deciding if this unit group offers the best possible classification. In addition, the example titles listed for the unit group should be examined to ensure that the choice is actually the best.

Using the NOC search tool

  1. First search for the occupation. This can be done by searching using a key part of the occupation title and reviewing the search results to find the four-digit code that contains the occupation sought. Check whether the title appears in any other four-digit code listed. If it does, the corresponding industrial qualifiers should be checked and the one which relates most closely to the one stated by the respondent selected. Using this code, go to the unit group. Read its definition carefully as well as the list of example titles before deciding whether it is the most appropriate classification. Also consult the list of Exclusions for similar occupations that are classified elsewhere.
  2. If the occupation title cannot be found or if the definition appears inappropriate, enter another title in the search. Some suggestions are:
    1. Look for the noun form: answering the phone will be a Receptionist or Telephone clerk
    2. Shorten the title: Electronic data processor to Data processor
    3. Find a synonym: Aircraft mechanic for Aircraft maintenance technician
    4. If the title is inverted, look for it in its natural order e.g. Manager, store may be located using Store manager
  3. Also consider such factors as:
    1. Job location - tunnel worker; bridge keeper
    2. Kind of machines used - cement-mixer operator; hydraulic riveter
    3. Material used - concrete mason; leather handbag maker
    4. Subject matter - music cataloguer; press clipper
    5. Activity performed - locomotive inspector; body shop foreman/woman
    6. Job skills - surgical instrument repairer; tool machinist

Coding procedures for problem responses

The procedure described above assumes responses contain sufficient information for coding. Unfortunately, depending upon the survey methods used, some responses may be problematic. This occurs when the information in the response is either vague or contradictory. Experience at Statistics Canada suggests the following approaches to resolving such problems.

Coding vague responses

It is suggested that vague responses be coded only to the level within the classification that is possible. Of course, before doing so, any information that is available about the respondent should be consulted.

Using education in coding

This is especially useful in coding occupational responses that are vague. The most reliable way of using education is as an exclusionary edit. Certain occupations require a minimum education and it is possible to exclude vague responses from being coded to such occupations if the respondent does not have the minimum education required. Great care must be taken when using education in occupational coding and it should only be used as a last resort.

Coding when the response contains contradictory information

Sometimes the responses will give an occupational title and a description of work performed that are contradictory. A response "labourer, driving dump truck" is contradictory in terms of the classification, as driving a truck is not considered elemental work. This response should be coded as a truck driver in 7511 Transport truck drivers.

In general, it is best to let the description of the work performed predominate over occupational titles when coding.

Some occupational titles can be misleading. Titles that have manager as part of the title are sometimes not managers. For example, project managers and case managers are usually not managers and must be coded based on a description of their work. Special care must be given to responses that have manager, labourer, or consultant as part of the title as these terms have a variety of meanings in the workplace.

Coding responses containing two or more occupations

Where two or more occupations are reported in reply to a question on occupation, the first one mentioned should be coded unless there is additional information to suggest otherwise.


Classification rules

Managers

Managers are usually classified to the broad occupational category 0 Management Occupations. Within this category the senior managers that are the top of a management hierarchy as denoted by terms such as president, chief executive officer, etc. are classified in major group 00 Senior management occupations.

Managers with a management specialty, such as human resource management, are classified according to specialty in major group 01-05 Specialized middle management occupations. However, senior managers with a specialist responsibility would be classified with senior management in major group 00 Senior management occupations.

An attempt has been made to isolate many of the managers of small businesses by classifying managers of retail stores, restaurants, hotels and similar businesses in a separate major group 06 Middle management occupations in retail and wholesale trade.

All other managers are classified according to the type of business managed within major group 07-09 Middle management occupations in trades, transportation, production and utilities.

Proprietors

As a general rule, the class of worker status, that is, whether the respondent works for wages or is self-employed, is not considered for classification purposes. An exception is made for proprietors in retail trade, food and accommodation services and residential home building. These are classified as managers to the following unit groups:

0621
Retail and wholesale trade managers
0631
Restaurant and food service managers
0632
Accommodation service managers
0712
Home building and renovation managers

Contractors

Contractors are classified in several areas of the classification. General contractors in construction are classified in unit group 0711 Construction managers. Renovation contractors and home building contractors are classified in unit group 0712 Home building and renovation managers.

Contractors specializing in a specific trade such as plumbing, electrical, carpentry, etc., are classified together with supervisors to the appropriate unit group for that trade. That is, a plumbing contractor is classified to unit group 7203 Contractors and supervisors, pipefitting trades.

Supervisors and foremen/women

Supervisors are classified to separate unit groups for supervisors where they exist. These are found in the following minor groups for supervisors:

121
Administrative services supervisors
621
Retail sales supervisors
631
Service supervisors
720
Contractors and supervisors, industrial, electrical and construction trades and related workers
730
Contractors and supervisors, maintenance trades and heavy equipment and transport operators
821
Supervisors, logging and forestry
822
Contractors and supervisors, mining, oil and gas
825
Contractors and supervisors, agriculture, horticulture and related operations and services
921
Supervisors, processing and manufacturing occupations
922
Supervisors, assembly and fabrication

This unit group for supervisors is found outside of the supervisor minor groups:

3011
Nursing co-ordinators and supervisors

Where a separate unit group does not exist, supervisors are classified with the workers supervised. For example, in most professional major groups there are no separate unit groups for supervisors, the one exception being unit group 3011 Nursing co-ordinators and supervisors.

Technical occupations follow a similar rule and there are no separate unit groups for supervisors in this area.

Even where separate supervisory unit groups exist, "lead hands" are not classified to them as previous research has indicated that supervision is usually only a minor part of such jobs.

Apprentices

Apprentices are classified within the groups for tradesmen/women. For example an apprentice carpenter is classified to the appropriate trade group, unit group 7271 Carpenters.

Helpers

Helpers are usually considered as labourers. Most helpers will be found in the building trades such as carpenter's helper, mason's helper, roofer's helper, etc. These jobs are not to be confused with formal apprenticeships and are not classified as tradesmen/women but are classified to unit group 7611 Construction trades helpers and labourers.

Labourers

Labourers are classified in separate unit groups in the following major groups:

76
Trades helpers, construction labourers and related occupations
86
Harvesting, landscaping and natural resources labourers
96
Labourers in processing, manufacturing and utilities

Sample questions for obtaining occupation information

The following questions indicate the type of information and the format that could be used to obtain the facts necessary to classify an occupation.

  1. For whom did you work?
    • Name of firm, government agency, etc.
  2. What kind of business, industry or service was this?

    Please give details. For example: primary school, municipal police, wheat farm, shoe store.
  3. What was your work or occupation?

    Please be specific. For example: plumber, fishing guide, wood furniture assembler, secondary school teacher. (If in the armed forces, give rank).
  4. In this work, what were your main activities?

    Please give details. For example: installed residential plumbing, guided fishing parties, made wood furniture products, taught mathematics.
  5. In this job or business, were you mainly:
    • Working for wages, salary, tips or commission?
    • Working without pay for your spouse or another relative in a family farm or business?
    • Self-employed without paid help (alone or in a partnership)?
    • Self-employed with paid help (alone or in a partnership)?

More information on the NOC

For information on the National Occupational Classification (NOC) and its use for programs and services such as, immigrating to Canada, labour market information, job searches and working in Canada, please contact Human Resources and Skills Development Canada.

Footnotes

Footnote 1

This heading is used by Statistics Canada.

Return to footnote 1 referrer

Footnote 2

This heading is used by Human Resources and Skills Development Canada.

Return to first footnote 2 referrer

Notice of introduction of a new aggregation structure for the classification of imports and exports of goods

May 29, 2012 (Previous notice)

This is an information notice.

On August 8 2011, Statistics Canada announced its intention to introduce a new classification structure to present import and export statistics in various programs. The notice below revises the previous one as follows:

  • A few group and class titles are changed to better reflect their intended coverage
  • One class is eliminated
  • A few changes are made to code numbers
  • The implementation schedule has been updated

Introduction

Statistics Canada will introduce a new classification structure to organize and present import and export statistics in various programs. The new structure will replace the classification structures known as the summary import groups (SIG) and the summary export groups (SEG) that have been in use for several decades.

The new structure builds a bridge between the Canadian Export Classification (CEC), Customs Tariff (CT) and the Input-output commodity classification (IOCC). The main objectives of the new system are to better integrate import and export statistics in the System of National Accounts and update the presentation of import and export statistics.

The links below provide a description of the current practices regarding the classification of goods in the Canadian statistical system, of the new aggregation structure, of the advantages and limitations of the new system and, the implementation schedule.

The reader should note that the introduction of this aggregation structure is only a first step towards improved harmonization of commodity statistics. It launches a new approach that will be fully implemented in the 2012 Canadian version of the North American Product Classification System (NAPCS). The link below leads to more information on that project.

The current situation

Statistics on goods are based on several classification systems. In the domain of statistics on the supply and use of goods, some of the key classifications are the Annual Survey of Manufactures (ASM) - List of Goods, the Canadian Export Classification (CEC) and the Customs Tariff (CT). There is no standard system or aggregation structure integrating these classifications. The new system seeks to fill this gap.

In the Canadian statistical system, the input-output accounts integrate product statistics into a coherent system that describes the supply and use of goods, services and production factors in our economy. This framework underlies the new classification system.

The new classification system

The new aggregation structure for import and export statistics is a component of a new system of commodity classifications.

The new system has two elements, a standard classification structure and alternative aggregation structures or variants of the standard classification. At this time, only one variant has been developed to serve the needs of the merchandise import and export accounts, but the system is designed to accommodate as many as necessary.

The link below presents the first two levels of the standard classification structure.

At its most detailed level (five-digit class), there are 263 classes of goods. This level of the classification will be the basis for the commodity dimension of the input output tables with some minor differences to address data limitations. That said, this will be the most detailed level for which statistics on domestic production, imports and exports of goods will be harmonized.

The 263 detailed classes of the standard classification structure are then organized into 88 three-digit groups designed to publish selected statistics and used to define the higher level categories of variants.

Though not shown here, the standard classification embeds additional levels that integrate more detailed categories used in other parts of the statistical system. For instance, the five-digit classes of the standard classification have been defined in most cases on the basis of the Annual Survey of Manufactures (ASM) - List of Goods, a classification that has been in use for several years. The ASM list of goods is consequently well integrated into the new system.

As well, Statistics Canada is developing new goods classes for the measurement of producer prices, largely based on the Annual Survey of Manufactures (ASM) - List of Goods. The producer price classes will appear below the five-digit classes of the standard classification and above the ASM classes in the classification hierarchy, thereby enhancing the comparability of production and producer price statistics.

The relationship between the 263 five-digit classes of the standard classification and those of the Canadian Export Classification (CEC) and the Customs Tariff (CT) is defined by concordances. Each of the most detailed categories of those classifications will be assigned to one of the five-digit classes of the standard classification. This approach allows for the presentation of import and export statistics on the basis of two distinct systems; on the basis of the Harmonized System and derived Canadian versions (the CEC and CT) as required by law; and on the basis of the new classification system presented here.

As mentioned earlier, only one high level alternative aggregation structure or variant has been developed so far. It will replace the summary import groups and summary export groups that have been in use for several decades. The link below leads to the new aggregation structure for import and export statistics.

Though there is only one high-level aggregation structure at this time, the system is designed to add variants to serve other analytical needs. All variants will share two common features:

  • The aggregates will be defined in terms of the 3-digit categories of the standard classification;
  • The standard classification elements used to define these aggregates will retain the standard classification code.

The reader will note the alphanumeric codes of the two top levels of the variant for merchandise import and export accounts (codes beginning with the letter C) and the numeric codes of the two lower levels of the structure (those of the standard classification elements used to define the aggregates). This coding approach will be retained if additional variants are developed. The variants will be recognizable by the alpha numeric coding at the first two levels of the structure.

The nomenclature

The aggregation structure presented above has four levels named section, division, group and class.

The aggregation structures have four levels: section, division, group and class.
Level Name Number of digits Number of categories
1 Section 3-digit alpha numeric 11
2 Division 4-digit alpha numeric 33
3 Group 3-digit numeric 88
4 Class 5-digit numeric 263

The details below the class level (not shown here) will be known as NAPCS subclass and NAPCS detail when NAPCS Canada 2012 is introduced.

The advantages and limitations of the new system

The new system has the following advantages:

  • Promotes better integration of statistics on goods;
  • Promotes the publication of more coherent data on goods;
  • Facilitates data interpretation for users;
  • Facilitates the harmonization of the classification revision cycle for all programs that use the classification system.

The new system also has limits.

The most important is that its implementation depends on the integration of classifications that were developed independently from one another and do not always use the same criteria to distinguish products - the Annual Survey of Manufactures (ASM) - List of Goods, the Canadian Export Classification (CEC) and the Customs Tariff (CT). As a consequence, the concordances between the CEC and the standard classes and between the CT and the standard classes are less than perfect. This limitation cannot be entirely eliminated since the use of the CEC and CT is prescribed by administrative agreements and legal obligations.

However, the new system makes it possible to eliminate several inconsistencies between the basic classifications at the more aggregated levels.

Finally, it is important to note that the system presented here is not complete since it covers neither services, nor tangible or intangible assets. These components will be added in NAPCS Canada 2012.

Implementation schedule

The main users within Statistics Canada are planning to adopt the new classification system in 2012. The following table shows the plan for each program.

Revised on April 30, 2012

The following table shows the plans for each program.
Statistical program Variables First release and reference period
International merchandise trade Merchandise imports and exports (current dollars, constant dollars and related price indexes). October 18, 2012, Historical data released for January 1988 to August 2012 on a Balance of Payments and Customs based values

October 18, 2012, Historical data released for January 1997 to August 2012 on a Balance of Payments and Customs based Price and Volume Indexes

November 8, 2012, Regular data release for September 2012 reference month (Balance of Payments and Customs based current dollar, constant dollar and related price and volume indexes)

Balance of payments Merchandise imports and exports in current dollars. October 2012 for the data for the second quarter of 2012 and every previous quarter since the first quarter of 1981.
Income and expenditure account Annual and quarterly merchandise imports and exports (current dollars, constant dollars and related price indexes). October 2012 for the data for the second quarter of 2012 and every previous quarter since the first quarter of 1981.
Producer price indexes Producer price indexes. November 2013 based on the basket for 2010. The reference period remains to be determined.

The level of detail provided will differ depending on the program and variables. The following table provides the plans for each program with regard to the classification version used and the level of detail available.

The following table provides the plans for each program with regard to the classification version used and the level of detail available.
Statistical program Standard classification Variant: Merchandise import and export accounts
International merchandise trade At the group level (level 3 - 88 categories) in regular publications, and at the class level (level 4 - 263 categories) on request. At the section level (level 1 - 11 categories) and at the division level (level 2 - 33 categories) in regular publications.
Balance of payments   At the section level (level 1 - 11 categories) in regular publications.
Income and expenditure account   At the division level (level 2 - 33 categories) in regular publications.
Producer price indexes At the subclass level (level 5 -758 categories for the industry producer price index and raw material price index programs)  

North American Product Classification System (NAPCS) Canada 2012

The introduction of this system is a first step towards broader harmonization of commodity classifications and statistics. In the longer term, Statistics Canada intends to use a similar approach to integrate a variety of commodity classifications, in particular those used to collect value and price data on production, imports and exports of goods, services and intangible assets. This includes the classifications of agricultural, mining, manufacturing, trade and service commodities.

The full implementation of the system will begin with the release of the 2012 Canadian version of the North American Product Classification System (NAPCS) Canada 2012, scheduled for summer of 2012. NAPCS Canada 2012 will:

  • Embed significant revisions to the classifications of manufactured, retailed and wholesaled goods as a result of a project to harmonize commodity classifications in North America.
  • Provide a means to organize and present commodity statistics on the basis of a coherent system of standard classes, standard variant aggregations and standard concordances.

The implementation schedule of NAPCS Canada 2012 will vary by program. The schedule will be published with the release of the classification.

Notice of introduction of a new aggregation structure for the classification of imports and exports of goods

August 8, 2011

This is an information notice.

Statistics Canada will introduce a new classification structure to organize and present import and export statistics in various programs. The new structure will replace the classification structures known as the summary import groups (SIG) and the summary export groups (SEG) that have been in use for several decades.

The new structure builds a bridge between the Canadian Export Classification (CEC), Customs Tariff (CT) and the Input-output commodity classification (IOCC). The main objectives of the new system are to better integrate import and export statistics in the System of National Accounts and update the presentation of import and export statistics.

The links below provide a description of the current practices regarding the classification of goods in the Canadian statistical system, of the new aggregation structure, of the advantages and limitations of the new system and, the implementation schedule.

The reader should note that the introduction of this aggregation structure is only a first step towards improved harmonization of commodity statistics. It launches a new approach that will be fully implemented in the 2012 Canadian version of the North American Product Classification System (NAPCS). The link below leads to more information on that project.

The current situation

Statistics on goods are based on several classification systems. In the domain of statistics on the supply and use of goods, some of the key classifications are the Annual Survey of Manufactures (ASM) - List of Goods, the Canadian Export Classification (CEC) and the Customs Tariff (CT). There is no standard system or aggregation structure integrating these classifications. The new system seeks to fill this gap.

In the Canadian statistical system, the input-output accounts integrate product statistics into a coherent system that describes the supply and use of goods, services and production factors in our economy. This framework underlies the new classification system.

The new classification system

The new aggregation structure for import and export statistics is a component of a new system of commodity classifications.

The new system has two elements, a standard classification structure and alternative aggregation structures or variants of the standard classification. At this time, only one variant has been developed to serve the needs of the merchandise import and export accounts, but the system is designed to accommodate as many as necessary.

The link below presents the first two levels of the standard classification structure.

At its most detailed level (five-digit class), there are 264 classes of goods. This level of the classification will be the basis for the commodity dimension of the input output tables with some minor differences to address data limitations. That said, this will be the most detailed level for which statistics on domestic production, imports and exports of goods will be harmonized.

The 264 detailed classes of the standard classification structure are then organized into 88 three-digit groups designed to publish selected statistics and used to define the higher level categories of variants.

Though not shown here, the standard classification embeds additional levels that integrate more detailed categories used in other parts of the statistical system. For instance, the five-digit classes of the standard classification have been defined in most cases on the basis of the Annual Survey of Manufactures (ASM) - List of Goods, a classification that has been in use for several years. The ASM list of goods is consequently well integrated into the new system.

As well, Statistics Canada is developing new goods classes for the measurement of producer prices, largely based on the Annual Survey of Manufactures (ASM) - List of Goods. The producer price classes will appear below the five-digit classes of the standard classification and above the ASM classes in the classification hierarchy, thereby enhancing the comparability of production and producer price statistics.

The relationship between the 264 five-digit classes of the standard classification and those of the Canadian Export Classification (CEC) and the Customs Tariff (CT) is defined by concordances. Each of the most detailed categories of those classifications will be assigned to one of the five-digit classes of the standard classification. This approach allows for the presentation of import and exports statistics on the basis of two distinct systems; on the basis of Harmonized System and derived Canadian versions (the CEC and CT) as required by law; and on the basis the new classification system presented here.

As mentioned earlier, only one high level alternative aggregation structure or variant has been developed so far. It will replace the summary import groups and summary export groups that have been in use for several decades. The link below leads to the new aggregation structure for import and export statistics.

Though there is only one high-level aggregation structure at this time, the system is designed to add variants to serve other analytical needs. All variants will share two common features:

  • The aggregates will be defined in terms of the 3-digit categories of the standard classification;
  • The standard classification elements used to define these aggregates will retain the standard classification code.

The reader will note the alphanumeric codes of the two top levels of the variant for merchandise import and export accounts (codes beginning with the letter C) and the numeric codes of the two lower levels of the structure (those of the standard classification elements used to define the aggregates). This coding approach will be retained if additional variants are developed. The variants will be recognizable by the alpha numeric coding at the first two levels of the structure.

The nomenclature

The aggregation structure presented above has four levels named section, division, group and class.

The aggregation structures have four levels: section, division, group and class.
Level Name Number of digits Number of categories
1 Section 3-digit alpha numeric 11
2 Division 4-digit alpha numeric 33
3 Group 3-digit numeric 88
4 Class 5-digit numeric 264

The details below the class level (not shown here) will be known as NAPCS subclass and NAPCS detail when NAPCS Canada 2012 is introduced.

The advantages and limitations of the new system

The new system has the following advantages:

  • Promotes better integration of statistics on goods;
  • Promotes the publication of more coherent data on goods;
  • Facilitates data interpretation for users;
  • Facilitates the harmonization of the classification revision cycle for all programs that use the classification system.

The new system also has limits.

The most important is that its implementation depends on the integration of classifications that were developed independently from one another and do not always use the same criteria to distinguish products - the Annual Survey of Manufactures (ASM) - List of Goods, the Canadian Export Classification (CEC) and the Customs Tariff (CT). As a consequence, the concordances between the CEC and the standard classes and between the CT and the standard classes are less than perfect. This limitation cannot be entirely eliminated since the use of the CEC and CT is prescribed by administrative agreements and legal obligations.

However, the new system makes it possible to eliminate several inconsistencies between the basic classifications at the more aggregated levels.

Finally, it is important to note that the system presented here is not complete since it covers neither services, nor tangible or intangible assets. These components will be added in NAPCS Canada 2012.

Implementation schedule

The main users within Statistics Canada are planning to adopt the new classification system in 2012. The following table shows the plan for each program. The scope of the historical revision by each program remains to be determined.

The following table shows the plans for each program.
Statistical program Variables First release and reference period
International merchandise trade Merchandise imports and exports (current dollars, constant dollars and related price indexes). June 2012 for April 2012 data (based on the tariff standard and the Balance of Payments standard).
Balance of payments Merchandise imports and exports in current dollars. May 2012 for the data for the first quarter of 2012 and every previous quarter since the first quarter of 1981.
Income and expenditure account Annual and quarterly merchandise imports and exports (current dollars, constant dollars and related price indexes). May 2012 for data in the first quarter of 2012 and every previous quarter since the first quarter of 1981.
Producer price indexes Producer price indexes. November 2013 based on the basket for 2007. The reference period remains to be determined.

The level of detail provided will differ depending on the program and variables. The following table provides the plans for each program with regard to the classification version used and the level of detail available.

The following table provides the plans for each program with regard to the classification version used and the level of detail available.
Statistical program Standard classification Variant: Merchandise import and export accounts
International merchandise trade At the group level (level 3 - 88 categories) in regular publications, and at the class level (level 4 - 264 categories) on request. At the section level (level 1 - 11 categories) and at the division level (level 2 - 33 categories) in regular publications.
Balance of payments   At the section level (level 1 - 11 categories) in regular publications.
Income and expenditure account   At the division level (level 2 - 33 categories) in regular publications.
Producer price indexes At the group level (level 3 -88 categories) in regular publications and at the class level (level 4 - 264 categories) on request.  

North American Product Classification System (NAPCS) Canada 2012

The introduction of this system is a first step towards broader harmonization of commodity classifications and statistics. In the longer term, Statistics Canada intends to use a similar approach to integrate a variety of commodity classifications, in particular those used to collect value and price data on production, imports and exports of goods, services and intangible assets. This includes the classifications of agricultural, mining, manufacturing, trade and service commodities.

The full implementation of the system will begin with the release of the 2012 Canadian version of the North American Product Classification System (NAPCS) Canada 2012, scheduled for summer of 2012. NAPCS Canada 2012 will:

  • Embed significant revisions to the classifications of manufactured, retailed and wholesaled goods as a result of a project to harmonize commodity classifications in North America.
  • Provide a means to organize and present commodity statistics on the basis of a coherent system of standard classes, standard variant aggregations and standard concordances.

The implementation schedule of NAPCS Canada 2012 will vary by program. The schedule will be published with the release of the classification.