2006 Metropolitan areas for:

New Housing Price Indexes

Statistical Methods for the Analysis of Data – Intermediate level (Course code 0428)

Purpose

To familiarize participants with basic and intermediate techniques for the statistical analysis of data. It is a theoretical course with exercises (with/without SAS), and hence is not a data analysis course.

Benefits to participants

The participants will be better able to determine the type of analytical work to undertake and to read research papers. They will also acquire familiarity with SAS results.

Target population

Employees with basic knowledge of mathematics and statistics who are called upon to solve problems of data exploration and analysis.

Course outline

  • Standard probability distributions and tables
  • Point estimation
  • Confidence intervals
  • Tests of hypothesis
  • Simple linear regression
  • *Analysis of residuals
  • Presentation of SAS.

   * time permitting

Prerequisites

Basic knowledge of mathematics and statistics.

Duration: 4 days

Registered Apprenticeship Information System (RAIS) Data Element Manual

Center for Education Statistics
Statistics Canada

General description

This manual describes the data elements to be included in the Registered Apprenticeship Information System (RAIS). The survey was designed to replace the Registered Apprenticeship Training Survey for the 1991 reporting year.

The data reported should consist of one record for every individual registered in the apprenticeship system during the reporting year. All data elements should be reported for registered apprentices. The required information for trade qualifiers (challengers) include several of the data elements, however, the ones not requested include data elements 28, 33 to 36 and 39 to 57.

For each data element, which is identified by name and element number, there is a complete description of the data required for the element, definitions of terms where appropriate and a complete listing of all of the possible codes that can be used. In addition, some specific examples are included where additional clarification is required to ensure consistent interpretation of the elements.

A total of 19 data elements have been identified as mandatory elements. These are considered as being the core information needed on registered apprenticeship programs and trade qualifiers in order to enable Statistics Canada to release annual statistics on registrations, completions and certifications. These mandatory elements are the following: data elements 1 to 3, 5, 20, 21, 29 to 36, 38, 39, 41, 58 and 59.

To facilitate the processing of the input data into the RAIS system, it is best that the reported data file be sent in a flat file format with a ".txt" extension. The data file should also not contain delimiters of any sort and have a record length of 752 bytes.

In addition to the data report, it would be appreciated if a separate file with the most recent list of trade codes and their description can also be made available.

Elements reserved for Statistics Canada

A total of nine elements are reserved for Statistics Canada; these are either elements that Statistics Canada will be deriving or elements that are meant to be used internally only.

Jurisdictions are not to report information for these elements. A list of these seven elements is available in the last section of this document (p. 66).

Data Elements
Element No. Description
Element No. 1: Reporting year1
Element No. 2: Jurisdiction1
Element No. 3: Identification number1
Element No. 4: Social Insurance Number (SIN)
Element No. 5: Apprentice or trade qualifier indicator1
Element No. 6: First name
Element No. 7: Middle name
Element No. 8: Last/Family name
Element No. 9: Address
Element No. 10: City name
Element No. 11: Jurisdiction of residence
Element No. 12: Postal code
Element No. 13: Area code of work phone
Element No. 14: Work phone number
Element No. 15:  Work phone number extension
Element No. 16: Area code of home phone
Element No. 17: Home phone number
Element No. 18: Area code of cell phone
Element No. 19: Cell phone number
Element No. 20: Gender1
Element No. 21: Date of birth1
Element No. 22: Aboriginal identity
Element No. 23: Disability or activity limitations
Element No. 24: Highest education level
Element No. 25: Previous apprenticeship training
Element No. 26: Previous apprenticeship training date
Element No. 27: Previous apprenticeship training jurisdiction
Element No. 28: Business number (BN)2
Element No. 29: Trade code1
Element No. 30: Trade code description1
Element No. 31: Level code1
Element No. 32: Level code description1
Element No. 33: Program duration1,2
Element No. 34: Duration in hours for duration based programs1,2
Element No. 35: Program duration units1,2
Element No. 36: Competency or duration based program1,2
Element No. 37: Compulsory or voluntary trade
Element No. 38: Registration status1,2
Element No. 39: Date of registration1,2
Element No. 40: Reinstatement date2
Element No. 41: Status at end of reporting period1,2
Element No. 42: Initial credits at registration2
Element No. 43: Type of initial credits at registration2
Element No. 44: Technical training credits at registration2
Element No. 45: Type of technical training credits at registration2
Element No. 46: On-the-job training credits at registration2
Element No. 47: Type of on-the-job training credits at registration2
Element No. 48: On-the-job hours completed to date for duration based programs2
Element No. 49: Competency based on-the-job levels completed to date2
Element No. 50: Competency based on-the-job levels required2
Element No. 51: Date of latest recording of hours completed to date2
Element No. 52: Technical levels or courses completed to date2
Element No. 53: Technical hours completed to date2
Element No. 54: Number of technical levels or courses required2
Element No. 55: Technical hours required2
Element No. 56: Method/Mode of institutional training2
Element No. 57: Full-time/Part-time status2
Element No. 58: Type of certificate of qualification granted1
Element No. 59: Date of certification1
Element No. 60: Prior trade certificate
Element No. 61: Filler
Elements reserved for Statistics Canada3
Element No. Description
STC Element No. 1: RAIS Trade code
STC Element No. 2: Red Seal or non-Red Seal indicator
STC Element No. 3: Red Seal or non-Red Seal endorsement
STC Element No. 4: Current year or period of the program
STC Element No. 5: Age in years
STC Element No. 6: Input type
STC Element No. 7: Certificate or registration indicator
STC Element No. 8: Previous apprenticeship training - RAIS Trade code
STC Element No. 9: Prior trade certificate - RAIS Trade code

Element No. 1: Reporting year

Description
The calendar year for which the reported data is valid and should consist of a complete calendar year from January 1 to December 31.

Report for the apprentice or trade qualifier (challenger).

Size of Field: 4 digits numeric

Codes
YYYY (Year)

Element No. 2: Jurisdiction

Description
Using the Statistics Canada province and territory codes, identify the jurisdiction submitting the data.

Report for the apprentice or trade qualifier (challenger).

Size of Field: 2 digits numeric.

Codes
10 – Newfoundland
11 – Prince Edward Island
12 – Nova Scotia
13 – New Brunswick
24 – Quebec
35 – Ontario
46 – Manitoba
47 – Saskatchewan
48 – Alberta
59 – British Columbia
60 – Yukon
61 – Northwest Territories
62 – Nunavut
99 – Unknown

Element No. 3: Identification number

Description
A unique identifier for each individual record and representing either an apprentice or trade qualifier (challenger). It should remain consistent from reporting year to reporting year.

Consistent reporting of the same unique identifier should be maintained for the same individual, across reporting periods. However, if a change should occur in your unique identifier, ensure Statistics Canada is informed of this change, and include concordance information in your next reporting to bridge this change.

In this element, report a unique identifier, (not the Social Insurance Number, S.I.N.) used by your jurisdiction, such as a registered apprenticeship registration number, client number, etc.

If the S.I.N. is also available, report using the next data element no. 4 - Social Insurance Number.

Size of Field: Maximum of 12 characters

Codes
Can be a combined character and numeric field.

Element No. 4: Social Insurance Number (SIN)

Description
The Social Insurance Number (SIN) of the apprentice or trade qualifier (challenger).

Size of Field: 9 digits numeric

Codes
9-digit SIN

Element No. 5: Apprentice or trade qualifier indicator

Description
In this element indicate if the individual is a registered apprentice or a trade qualifier (challenger).

Size of Field: 1 digit numeric

Codes
1 – Registered apprentice
2 – Trade qualifier (challenger)
9 – Unknown

Element No. 6: First name

Description
First name of the apprentice or trade qualifier (challenger).

Apprentice's or trade qualifier (challenger)'s first (given) name.

Size of Field: Maximum of 25 characters

Codes
N/A

Element No. 7: Middle name

Description
Middle name of the apprentice or trade qualifier (challenger).

Note: If you cannot report the first name and middle name as separate fields, enter both names in the previous element no. 6 - First name, and leave this element blank.

Size of Field: Maximum of 25 characters

Codes
N/A

Element No. 8: Last/Family name

Description
Family or last name of the apprentice or trade qualifier (challenger).

Apprentice's or trade qualifier (challenger)'s surname (last name).

Size of Field: Maximum of 30 characters

Codes
N/A

Element No. 9: Address

Description
The address number, apartment number (if applicable), street name, PO Box or RR route (if applicable) of the current residence of the apprentice or trade qualifier (challenger).

Report as one string the address information of the current residence of the apprentice or trade qualifier (challenger). In addition to the address number, apartment number, street name and PO Box/RR route number, also include in this element the street type and direction of street (if applicable).

For street type, the short form abbreviation can be reported, such as St. for Street, Ave. for Avenue, etc.

The direction of the street can also be in the abbreviated form of N for North, S for South, etc. (N, S, E, W, NE, NW, SE, SW).

Other address information, such as city name, province/territory of residence and postal code should be reported as separate elements in no. 10 - City name, no. 11 - Jurisdiction of residence and no. 12 - Postal code.

Size of Field: Maximum of 125 characters

Codes
N/A

Element No. 10: City name

Description
Name of city or town of the current residence of the apprentice or trade qualifier (challenger).

Size of Field: Maximum of 60 characters

Codes
N/A

Element No. 11: Jurisdiction of residence

Description
This element identifies the province or territory of residence of the apprentice or trade qualifier (challenger).

Report using the Statistics Canada province and territory codes previously identified in the element no. 2 - Jurisdiction.
 
Size of Field: 2 digits numeric

Codes
10 – Newfoundland
11 – Prince Edward Island
12 – Nova Scotia
13 – New Brunswick
24 – Quebec
35 – Ontario
46 – Manitoba
47 – Saskatchewan
48 – Alberta
59 – British Columbia
60 – Yukon
61 – Northwest Territories
62 – Nunavut
99 – Unknown

Element No. 12: Postal code

Description
Postal code of the current residence of the apprentice or trade qualifier (challenger).

Size of Field: Maximum of 6 characters

Codes
Report as one complete string without space between the digits - (CNCNCN).

Element No. 13: Area code of work phone

Description
3-digit area code of the work phone number of the apprentice or trade qualifier (challenger).

Size of Field: 3 digits numeric

Codes
N/A

Element No. 14: Work phone number

Description
Work phone number of the apprentice or trade qualifier (challenger).

Size of Field: 7 digits numeric

Codes
N/A

Element No. 15: Work phone number extension

Description
Work phone number extension (if applicable) of the apprentice or trade qualifier (challenger).

Size of Field: 5 digits numeric

Codes
N/A

Element No. 16: Area code of home phone

Description
3-digit area code of the home phone number of the apprentice or trade qualifier (challenger).

Size of Field: 3 digits numeric

Codes
N/A

Element No. 17: Home phone number

Description
Home phone number of the apprentice or trade qualifier (challenger).

Size of Field: 7 digits numeric

Codes
N/A

Element No. 18: Area code of cell phone

Description
3-digit area code of the cell phone number of the apprentice or trade qualifier (challenger).

Size of Field: 3 digits numeric

Codes
N/A

Element No. 19: Cell phone number

Description
Cell phone number of the apprentice or trade qualifier (challenger).

Size of Field: 7 digits numeric

Codes
N/A

Element No. 20: Gender

Description
The gender of the apprentice or trade qualifier (challenger).

Size of Field: 1 digit numeric

Codes
1 – Male
2 – Female
9 – Unknown

Element No. 21: Date of birth

Description
Date of birth of the apprentice or trade qualifier (challenger).

Note: For this data element do not report any empty spaces, dashes or backslashes. Each field in this data element should be filled with a character (e.g. 03061985).

If not available, leave blank.

Size of Field: 8 digits numeric

Codes
DDMMYYYY (DayMonthYear)

Element No. 22: Aboriginal identity

Description
This element identifies the Aboriginal identity of the apprentice or trade qualifier (challenger), if applicable.

A person with Aboriginal identity includes someone who is a North American Indian/First Nations, a Métis or an Inuit. North American Indians/First Nations, which include Status Indians, as well as non-Status Indians.

A person with non-Aboriginal identity should be reported as code = 5.

Size of Field: 1 digit numeric

Codes
1 – North American Indian / First Nations
2 – Métis
3 – Inuit
4 – Person identifying with more than one group
5 – Person who does not self-identify with one of the groups (not an Aboriginal person)
9 – Unknown

Element No. 23: Disability or activity limitations

Description
This element identifies whether the apprentice or trade qualifier (challenger) has any disabilities or activity limitations because of physical or health problems.

Size of Field: 1 digit numeric

Codes
1 – Hearing impaired
2 – Vision impaired
3 – Wheel chair access
4 – Person with a disability or activity limitation not listed in the above
5 – Person with more than one disability or activity limitation
6 – Person with no reported disabilities or activity limitations
9 – Unknown

Element No. 24: Highest education level

Description
The highest achieved level of education obtained prior to registration in the current trade program.

If information on the highest level of education is not available, please report as code = 99.

Also report for trade qualifier (challenger), if information on the highest achieved level of education is available.

Size of Field: 2 digits numeric

Codes
01 – Completed some elementary school
02 – Completed elementary school
03 – Grade 7
04 – Grade 8
05 – Grade 9
06 – Grade 10
07 – Grade 11
08 – Grade 12
09 – Grade 13 (if applicable)
10 – High school graduation certificate or equivalency certificate
11 – Registered apprenticeship certificate
12 – Other trade certificate or diploma
13 – College, technical, CEGEP or non-university certificate or diploma (includes pre-employment/pre-apprenticeship program)
14 – College, technical, CEGEP or non-university certificate or diploma
15 – University
16 – Other
99 – Unknown

Element No. 25: Previous apprenticeship training

Description
This element identifies the trade in which the most recent previous apprenticeship training was obtained prior to the trade the apprentice is now currently registered.

The previous apprenticeship training can be in any trade, not necessarily similar to the one the apprentice is currently registered.

Note: If a certificate was obtained for the completion of previous apprenticeship training, report the information in element no. 60 – Prior trade certificate.

If applicable, also report for trade qualifier (challenger).

The identifier for this trade is the trade code used by the reporting jurisdiction.

Size of Field: Maximum of 10 characters

Codes
N/A

Element No. 26: Previous apprenticeship training date

Description
This element identifies the end date of any previous apprenticeship training if reported in element no. 25 - Previous apprenticeship training.

If applicable, also report for trade qualifier (challenger).

Note: For this data element do not report any empty spaces, dashes or backslashes. Each field in this data element should be filled with a character (e.g. 061985).

If not available, leave blank.

Size of Field: 6 digits numeric

Codes
MMYYYY (MonthYear)

Element No. 27: Previous apprenticeship training jurisdiction

Description
In this element, identify the province or territory in which the apprentice was registered and obtained previous apprenticeship training, if reported in element no. 25 - Previous apprenticeship training.

Report using the Statistics Canada province and territory codes previous identified in the element no. 2 - Jurisdiction. An additional code has been added to the province and territory codes to include previous training outside of Canada.

If applicable, also report for trade qualifier (challenger).

Size of Field: 2 digits numeric

Codes
10 – Newfoundland
11 – Prince Edward Island
12 – Nova Scotia
13 – New Brunswick
24 – Quebec
35 – Ontario
46 – Manitoba
47 – Saskatchewan
48 – Alberta
59 – British Columbia
60 – Yukon
61 – Northwest Territories
62 – Nunavut
98 – Outside Canada
99 – Unknown

Element No. 28: Business number (BN)

Description
In this element report the Business Number (BN) of the employer that is providing the current training to the registered apprentice.

The Business Number (BN) is a unique identification number given to each enterprise/business entity by the Canada Revenue Agency (CRA).

The standard size of the Business Number is of 15-characters. However, only the first 9-characters are required by Statistics Canada; these first 9-characters identify the business and always remain unchanged.

Therefore, only the first 9-characters of the Business Number (BN) are to be reported in this element.

Size of Field: Maximum of 9 characters

Codes
N/A

Element No. 29: Trade code

Description
The trade in which the apprentice is registered or trade qualifier (challenger) is certified.

The identifier for this trade is the trade code used by the jurisdiction.

If the trade code includes additional digits to identify whether the trade has a level, class, category, etc., also include these additional digits in this data element.
 
Size of Field: Maximum of 10 characters

Codes
N/A

Element No. 30: Trade code description

Description
The name of the trade reported as a trade code in the previous element no. 29 – Trade code.

Report the complete name of the trade and do not include short form abbreviations.

Size of Field: Maximum of 80 characters

Codes
N/A

Element No. 31: Level code

Description
If the trade code reported in element no. 29 – Trade code, includes additional digits to identify whether the trade has a level, class, category, etc., in this element just report the actual code for the level, class, category, etc.

Report for the registered apprentice and trade qualifier (challenger).

If not available, leave blank.

Size of Field: Maximum of 8 characters

Codes
N/A

Element No. 32: Level code description

Description
The name of the level, class, category, etc., reported in the previous element no. 31 – Level code.

Report the complete name of the level, class, category, etc., and do not include short form abbreviations.

Report for the registered apprentice and trade qualifier (challenger).

If not available, leave blank.

Size of Field: Maximum of 80 characters

Codes
N/A

Element No. 33: Program duration

Description
This element identifies the normal length of time required to complete the entire program and is usually expressed in years, periods or skills/competency levels.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 3 digits numeric

Codes
N/A

Element No. 34: Duration in hours for duration based programs

Description
Identifies the total overall program duration in hours (e.g. 8000) reported in the previous element no. 33 - Program duration.

Note: The hours reported apply to the normal overall program length in hours and should have the same hours for all records with the same trade reported in the previous element no. 29 – Trade code.
 
Do not report for trade qualifier (challenger), leave blank.

Size of Field: 5 digits numeric

Codes
N/A

Element No. 35: Program duration units

Description
Identifies the type of unit used to measure the intervals over the duration of the program reported in element no. 33 - Program duration.

Do not report for trade qualifier (challenger); code as "0 – Not applicable".

Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – Years
2 – Periods
3 – Skills/Competency levels
4 – Program credits
9 – Unknown

Element No. 36: Competency or duration based program

Description
Identifies if the trade program is offered as a competency based program or a duration based program.

Do not report for trade qualifier (challenger); code as "0 – Not applicable".
 
Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – Duration based program
2 – Competency based program
3 – Duration and competency based program
9 – Unknown

Element No. 37: Compulsory or voluntary trade

Description
This element identifies if the trade is a compulsory certified trade or a voluntary certified trade.

Report for the registered apprentice and trade qualifier (challenger).

Size of Field: 1 digit numeric

Codes
1 – Compulsory
2 – Voluntary
3 – Compulsory and voluntary
9 – Unknown

Element No. 38: Registration status

Description
This element identifies the registration status of the apprentice at the beginning and during the reporting period.

Do not report for trade qualifier (challenger); code as "0 – Not applicable".

Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – Already registered (beginning of report period)
2 – New registration (during report period)
3 – Reinstatement (during report period)
9 – Unknown

Element No. 39: Date of registration

Description
This element identifies the date when the current contract or agreement of understanding between an apprentice and employer was registered with the jurisdiction.

Do not report for trade qualifier (challenger), leave blank.

Note: For this data element do not report any empty spaces, dashes or backslashes. Each field in this data element should be filled with a character (e.g. 03061985).

If not available, leave blank.

Size of Field: 8 digits numeric

Codes
DDMMYYYY (Day Month Year)

Element No. 40: Reinstatement date

Description
If a reinstatement has been reported for the apprentice in element no. 38 - Registration status, in this element identify the date of the reinstatement.

Do not report for trade qualifier (challenger), leave blank.

Note: For this data element do not report any empty spaces, dashes or backslashes. Each field in this data element should be filled with a character (e.g. 061985).

If not available, leave blank.

Size of Field: 6 digits numeric

Codes
MMYYYY (Month Year)

Element No. 41: Status at end of reporting period

Description
This element identifies the status of the apprentice during the reporting period and at the end of the reporting period.

When reporting information on apprentices that have successfully completed their programs and obtained their certificates, there can be a choice of three different types:

The first and most common, is identified below as a code = 2, and relates to the successful completion of an entire program, regardless of length, with a certificate granted after the entire program is completed.

The second and third types of successful completion are identified below by code = 3 and code = 4, and relate to certain programs which grant certificates after a segment of a longer extended program is completed. Examples of this type of completion are the Motor Vehicle Body Prepper and Motor Vehicle Body Refinisher programs, which are shorter in duration length, and designed as separate and partitioned programs of the extended Motor Vehicle Body Repairer program. These shorter programs usually allow an individual, after receiving their certificate, the choice of either continuing or not continuing their training in the extended program. Because of this choice, code = 4 is used to identify an individual who has decided to continue in the extended program of the trade, while code = 3 is used to identify an individual who has decided not to continue in the extended program of the trade.

Note: When reporting the successfully completed for programs which have been partitioned, do not relate this to the completion of an individual class or level found in some programs, which have divided their training into several classes or levels, such as the stationary engineer – 1st class, 2nd class, 3rd class, etc.

Do not report for trade qualifier (challenger); code as "0 – Not applicable".

Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – Continuing and still registered
2 – Successfully completed the entire program with a certificate granted
3 – Successfully completed a segment of an entire program with a certificate granted and not continuing in the trade
4 - Successfully completed a segment of an entire program with a certificate granted and still continuing in the trade
5 – Discontinued the program (cancelled, suspended, terminated, etc.)
6 – Transferred to another program
9 – Unknown

Element No. 42: Initial credits at registration

Description
In this element report the credits (either in hours, skill/competency levels or program credits) given for combined technical (in-class) training (obtained from colleges, high schools, commission scolaire or similar postsecondary and secondary institutions, etc.) and for on-the-job (work) training, prior to starting the apprenticeship program.

In the following element no. 43 – Type of initial credits at registration, report whether the credits are in hours, skill/competency levels or program credits.

Note: Only report this element if technical (in-class) training and on-the-job (work) training information cannot be reported separately as two elements in no. 44 - Technical training credits at registration and no. 46 - On-the-job training credits at registration.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 5 digits numeric

Codes
N/A

Element No. 43: Type of initial credits at registration

Description
Report the type of credits identified in the previous element no. 42 - Initial credits at registration.

Do not report for trade qualifier (challenger); code as "0 – Not applicable".

Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – Hours
2 – Skill/competency levels
3 – Program credits
9 – Unknown

Element No. 44: Technical training credits at registration

Description
In this element report the credits (either in hours, skill/competency levels or program credits) given for technical (in-class) training or courses prior to starting the apprenticeship program.

In the following element no. 45 – Type of technical training credits at registration, report whether the credits are in hours, skill/competency levels or program credits.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 5 digits numeric

Codes
N/A

Element No. 45: Type of technical training credits at registration

Description
Report the type of credits identified in the previous element no. 44 - Technical training credits at registration.

Do not report for trade qualifier (challenger); code as "0 – Not applicable".

Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – Hours
2 – Skill/competency levels
3 – Program credits
9 – Unknown

Element No. 46: On-the-job training credits at registration

Description
 In this element report the credits (either in hours, skill/competency levels or program credits) given for on-the-job (work) training prior to starting the apprenticeship program.

In the following element no. 47 – Type of on-the-job training credits at registration, report whether the credits are in hours, skill/competency levels or program credits.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 5 digits numeric

Codes
N/A

Element No. 47: Type of on-the-job training credits at registration

Description
Report the type of credits identified in the previous element no. 46 - On-the-job training credits at registration

Do not report for trade qualifier (challenger); code as "0 – Not applicable".

Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – Hours
2 – Skill/competency levels
3 – Program credits
9 – Unknown

Element No. 48: On-the-job hours completed to date for duration based programs

Description
If reporting levels or competencies for competency based programs, include this information in the next element no. 49 - Competency based on-the job levels completed to date.

In this element report the number of on-the-job (work) hours accumulated since the registration date. These completed hours should not include the on-the-job hours which may have been credited prior to registration and reported in the element no. 46 - On-the-job training credits at registration.

 Note: The hours completed should be up-dated every new reporting period.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 5 digits numeric

Codes
N/A

Element No. 49: Competency based on-the job levels completed to date

Description
The number of accumulated on-the-job levels or competencies completed to date for competency based programs.

Note: The levels or competencies completed should be up-dated every new reporting period.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 3 digits numeric

Codes
N/A

Element No. 50: Competency based on-the job levels required

Description
This element identifies the total number of on-the-job levels or competencies required to complete the competency based program, and is requested if element no. 49 - Competency based on-the job levels completed to date is reported.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 3 digits numeric

Codes
N/A

Element No. 51: Date of latest recording of hours or levels completed to date

Description
In this element report the date of the latest recording of on-the-job hours completed to date, if element no. 48 - On-the-job hours completed to date for duration based programs or element no. 49 - Competency based on-the-job levels completed to date is being reported.

Note: The date of the latest recording should be up-dated every new reporting period.

Do not report for trade qualifier (challenger), leave blank.

Note: For this data element do not report any empty spaces, dashes or backslashes. Each field in this data element should be filled with a character (e.g. 061985).

If not available, leave blank.

Size of Field: 6 digits numeric

Codes
MMYYYY (Month Year)

Element No. 52: Technical levels or courses completed to date

Description
This element identifies the total number of technical (in-class) levels or courses completed by the apprentice out of the total number of levels or courses required for the program. These completed technical in-class levels or courses should not include the technical training time which may have been credited prior to registration and reported in the element no. 44 - Technical training credits at registration.

Note: These completed levels or courses apply to both duration and competency based programs and should be up-dated every new reporting period.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 2 digits numeric

Codes
N/A

Element No. 53: Technical hours completed to date

Description
In this element report the equivalent hours, related to the technical levels or courses completed and reported in the previous element no. 52 - Technical levels or courses completed to date.

In this element report the total number of technical (in-class) hours completed by the apprentice out of the total number of hours required for the program.

Note: The hours completed apply to both duration and competency based programs and should be up-dated every new reporting period.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 5 digits numeric

Codes
N/A

Element No. 54: Number of technical levels or courses required

Description
This element identifies the total number of technical (in-class) levels or courses required to complete the program, and requested if element no. 52 - Technical levels or courses completed to date is reported.

Note: This element applies to both duration and competency based programs and should be up-dated every new reporting period.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 2 digits numeric

Codes
N/A

Element No. 55: Technical hours required

Description
Report the equivalent hours, if the number of technical levels or courses required was reported in the previous element no. 54 - Number of technical levels or courses required.

For this element report the total number of technical (in-class) hours required to complete the program.

Note: This element applies to both duration and competency based programs and, if required, should be up-dated every new reporting period.

Do not report for trade qualifier (challenger), leave blank.

Size of Field: 5 digits numeric

Codes
N/A

Element No. 56: Method/Mode of institutional training

Description
This element identifies the delivery type of technical training undertaken during the apprenticeship period being reported.

Do not report for trade qualifier (challenger); code as "00 – Not applicable".

Size of Field: 2 digits numeric

Codes
00 – Not applicable
01 – Block release
02 – Modular training
03 – Course based
04 – Day release
05 – Distance education
06 – Employer training
07 – Level
08 – Mobile
09 – Competency based apprenticeship training (CBAT)
10 – Weekly apprenticeship training (WATS)
11 – Other
99 – Unknown

Element No. 57: Full-time/Part-time status

Description
This element is linked to the previous element no. 56 - Method/Mode of institutional training, and identifies whether the training was either full-time or part-time.

Full-time training can be identified with an extended period of training like block release.

Do not report for trade qualifier (challenger); code as "0 – Not applicable".

Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – Full-time
2 – Part-time
9 – Unknown

Element No. 58: Type of certificate of qualification granted

Description
This element identifies the type of certificate granted to the apprentice or trade qualifier (challenger).
 
Note: If the Certificate of Apprenticeship is the final certificate granted in the trade, and the Certificate of Qualification is not being granted, then report the Certificate of Apprenticeship. The granting of these certificates usually involves the completion and passing of a final exam.

Size of Field: 1 digit numeric

Codes
0 – Not applicable
1 – No certificate granted
2 – Certificate granted with a Red Seal endorsement to an apprentice (who has completed the final exam)
3 – Certificate granted without a Red Seal endorsement to an apprentice (who has completed the final exam)
4 – Certificate granted with a Red Seal endorsement to a trade qualifier (challenger)
5 – Certificate granted without a Red Seal endorsement to a trade qualifier (challenger)
6 – Certificate granted with a Red Seal endorsement to a journeyperson who previously completed an apprenticeship program and received a certificate without a Red Seal endorsement in the same trade
7 – Certificate granted with a Red Seal endorsement to a trade qualifier (challenger) who previously received a certificate without a Red Seal endorsement in the same trade
9 – Unknown

Element No. 59: Date of certification

Description
In this element report the date the certificate was granted to an apprentice or trade qualifier (challenger), if a certificate was reported in the previous element no. 58 - Type of certificate of qualification granted.

If a jurisdiction grants both a Certificate of Qualification and a Certificate of Apprenticeship, report only the Certificate of Qualification date in this element. However, if the Certificate of Apprenticeship is the final certificate granted in the trade, and the Certificate of Qualification is not being granted, then report the date the Certificate of Apprenticeship was granted.

Note: For this data element do not report any empty spaces, dashes or backslashes. Each field in this data element should be filled with a character (e.g. 03061985).

If not available, leave blank.

Size of Field: 8 digits numeric

Codes
DDMMYYYY (Day Month Year)

Element No. 60: Prior trade certificate

Description
This element identifies if the apprentice or trade qualifier (challenger) received a certificate in a previous trade, and granted in the current reporting jurisdiction or any other jurisdiction. The previous certification must be in a trade recognized in Canada.

If the apprentice or trade qualifier was certified in more than one trade, please report the latest trade in which they were certified.

The identifier for this previous trade is the trade code used by the jurisdiction.

Size of Field: Maximum of 10 characters

Codes
N/A

Element No. 61: Filler

Description
This element should be left empty and is for information which may be requested in the future.

Size of Field: Maximum of 100 characters

Codes
N/A

Elements Reserved for Statistics Canada

STC Element No. 1: RAIS Trade code

Description
This element is reserved for Statistics Canada to code and identify trades using a modified version of the National Occupational Classification (NOC) codes.

The trade code reported will be converted to the National Occupational Classification NOC+3 trade code (abcd.xx.yy.zz), where:

  • The four digit NOC code (abcd) identifies the major occupational category;
  • The first extension (xx) represents a distinct and separate trade;
  • The second extension (yy) identifies subtrades of the distinct trade and;
  • The third extension (zz) is used for further level/class/category distinctions within the trade.

Size of Field: 10 digits numeric

Codes
NOC+3

STC Element No. 2: Red Seal or non-Red Seal indicator

Description
Reserved for Statistics Canada to identify Red Seal or non-Red Seal trades.

The Red Seal trades are drawn from the list approved by the Canadian Council of Directors of Apprenticeship (CCDA).

Size of Field: 1 digit numeric

Codes
0 – Without inter-provincial standards
1 – Red Seal with inter-provincial standards

STC Element No. 3: Red Seal or non-Red Seal endorsement

Description
Used by Statistics Canada to identify if Red Seal or non-Red Seal endorsement is being granted by the jurisdictions.

This element will be derived by Statistics Canada using a combination of information from the data elements reported by the jurisdictions:

  • STC Element no. 1 – RAIS Trade code
  • Element no. 58 – Type of certificate of qualification granted

Size of Field: 1 digit numeric

Codes
1 – Only Red Seal endorsement granted
2 – Red Seal and non-Red Seal endorsement granted
3 – Only non-Red Seal endorsement granted
9 – Unknown

STC Element No. 4: Current year or period of the program

Description
Only for duration based programs, the current year or period of the program in which the apprentice is registered, based on the total accumulated technical and on-the-job training hours.

This element will be derived by Statistics Canada using a combination of information from the data elements reported by the jurisdictions:

    • Element no. 33 - Program duration (DURPGM)
    • Element no. 34 - Duration in hours for duration based program (DURHOURS)
    • Element no. 35 - Program duration units (DURUNITS)
    • Element no. 42 - Initial credits at registration (INICREDR)
    • Element no. 48 - On-the-job hours completed to date for duration based program (JOBHCOMP)
    • Element no. 53 - Technical hours completed to date (TECHCOMP)

Current year or period of the program =

[DURPGM] – [DURHOURSINICREDRJOBHCOMPTECHCOMP] * DURPGM / DURHOURS

Size of Field: 1 digit numeric BIRTHY

Codes
N/A

STC Element No. 5: Age in years

Description
Used by Statistics Canada to derive the age in years of the apprentice or trade qualifier (challenger).

This element will be derived by Statistics Canada using information reported by the jurisdictions:

  • Element no. 1 - Reporting year (REPYR)
  • Birth year (BIRTHY) from element no. 21 – Date of birth

Age in years = REPYR

Size of Field: 2 digits numeric

Codes
N/A

STC Element No. 6: Input type

Description
Used by Statistics Canada to identify whether the jurisdiction is reporting individual record data or aggregate information.

Size of Field: 1 digit numeric

Codes
1 – Individual
2 – Aggregate

STC Element No. 7: Certificate or registration indicator

Description
Used by Statistics Canada to identify whether a registration file or a certificate file.

Size of Field: 1 digit numeric

Codes
1 – Registration
2 – Certificate

STC Element No. 8: Previous apprenticeship training - RAIS Trade code

Description
This element is reserved for Statistics Canada to code and identify trades using a modified version of the National Occupational Classification (NOC) codes.

The trade code reported will be converted to the National Occupational Classification NOC+3 trade code (abcd.xx.yy.zz), where:

  • The four digit NOC code (abcd) identifies the major occupational category;
  • The first extension (xx) represents a distinct and separate trade;
  • The second extension (yy) identifies subtrades of the distinct trade and;
  • The third extension (zz) is used for further level/class/category distinctions within the trade.

Size of Field: 10 digits numeric

Codes
NOC+3

STC Element No. 9: Prior trade certificate - RAIS Trade code

Description
This element is reserved for Statistics Canada to code and identify trades using a modified version of the National Occupational Classification (NOC) codes.

The trade code reported will be converted to the National Occupational Classification NOC+3 trade code (abcd.xx.yy.zz), where:

  • The four digit NOC code (abcd) identifies the major occupational category;
  • The first extension (xx) represents a distinct and separate trade;
  • The second extension (yy) identifies subtrades of the distinct trade and;
  • The third extension (zz) is used for further level/class/category distinctions within the trade.

Size of Field: 10 digits numeric

Codes
NOC+3

Notes


  1. Mandatory elements
  2. Do not report for trade qualifiers (challengers)
  3. Jurisdictions are not asked to report these elements – reserved for Statistics Canada
  4. Element no. 42 – Initial credits at registration (INICREDR) will be substituted by both, element no. 44 - Technical training credits at registration
  5. (TECCREDR) and element no. 46 - On-the-job training credits at registration (JOBCREDR), if technical and on-the-job credits at registration can be reported separately by the jurisdictions.

Grains and Specialty Crops Survey

Purchased from Manitoba producers

  • Report for the month of

Confidential when completed. This survey is conducted under the authority of the Statistics Act, Revised Statutes of Canada, 1985, c. S-19. Completion of this questionnaire is a legal requirement under the Statistics Act.

The purpose of this survey is to collect reliable and up-to-date information on non-board grains and specialty crops in the province of Manitoba. These data are used to calculate farm cash receipts which measure agriculture contribution to the Canadian economy. The data are also used by producer organizations, government departments and others for policy and decision-making.

Please provide the information requested on non-board grains and specialty crops for the month specified.

  • tonnes purchased (dockage and shrinkage deducted)
  • gross receipts (only rail freight and elevation deducted)

In compiling average provincial prices to producers, your data will be aggregated with data received from other companies to protect the confidentiality.

Please return your completed questionnaire by facsimile to (613) 951-3868. If you have any questions, please telephone Gail-Ann Breese (204) 983-3445. Thank you

  1. Tonnes Purchased
  2. $ Paid to Producers
  • Wheat
  • Oats
  • Barley for feed
  • Barley for malting
  • Rye
  • Flaxseed
  • Canola
  • Dry Field Peas
  • Buckwheat
  • Sunflower Seeds
  • Corn for grain
  • Canary seed
  • Fababeans
  • Lentils
  • Dry Beans
  • Triticale
  • Mustard Seed
  • Chickpeas
  • Soybeans

General information

Confidentiality

Your answers are confidential.

Statistics Canada is prohibited by law from releasing any information it collects which could identify any person, business, or organization, unless consent has been given by the respondent or as permitted by the Statistics Act. The confidentiality provisions of the Statistics Act are not affected by either the Access to Information Act or any other legislation. Therefore, for example, the Canada Revenue Agency cannot access identifiable survey records from Statistics Canada.

Information from this survey will be used for statistical purposes only and will be published in aggregate form only.

Record linkages

To enhance the data from this survey, Statistics Canada may combine it with information from other surveys or from administrative sources.

Data-sharing agreements

To avoid duplication of enquiry, Statistics Canada has entered into data-sharing agreements with provincial statistical agencies, which must keep the data confidential and use them only for statistical purposes. Statistics Canada will only share data from this survey with those organizations that have demonstrated a requirement to use the data.

Section 11 of the Statistics Act provides for the sharing of information with provincial statistical agencies that meet certain conditions. These agencies must have the legislative authority to collect the same information, on a mandatory basis, and the legislation must provide substantially the same provisions for confidentiality and penalties for disclosure of confidential information as the Statistics Act. Because these agencies have the legal authority to compel businesses to provide the same information, consent is not requested and farm operations may not object to the sharing of their data.

For this survey, there are Section 11 agreements with the provincial statistical agencies of Manitoba, Saskatchewan and Alberta.

The shared data will be limited to information pertaining to farm operations located within the jurisdiction of the respective province.

Fax or other electronic transmission disclosure

There could be a risk of disclosure during the facsimile or electronic transmission. However, upon receipt of your information, Statistics Canada will provide the level of protection afforded for all information collected under the authority of the Statistics Act.

Confidential when completed. This survey is conducted under the authority of the Statistics Act, Revised Statutes of Canada, 1985, c. S-19. Completion of this questionnaire is a legal requirement under the Statistics Act.

  • In Business - produces potatoes
  • In Business - doesn't produce potatoes
  • Out of Business
  • Change of Operator
  • No potato sales this month
  • No potato sales until the month of

If any information above is incorrect or missing, please make any necessary corrections below.

  • Farm Name (if applicable)
  • Surname or Family Name
  • Usual First Name and Initial
  • Area Code
  • Telephone
  • Cell phone
  • R.R.
  • Box No.
  • Number and Street Name
  • Postal Code
  • Post Office (name of city, town or village where mail is received)
  • Email Address (if applicable)
  • Partner's Name (if applicable)
  • Area Code
  • Telephone
  • Partner's Name (if applicable)
  • Area Code
  • Telephone
  • Corporation Name (if applicable)
  • Area Code
  • Telephone

Record of calls

  • Date
  • Time
  • Result

The purpose of this survey is to collect accurate, up-to-date information on farm prices received for potatoes. These prices are used to calculate farm cash receipts, to negotiate international trade agreements, to formulate income stabilization policies and to help farmers make informed management decisions.

What is the average price you received for potatoes you sold last month?

  • Please report the price received after any deductions or bonuses were made.
  • Please report an average price taking into account all grades.
  • Do not include the price you received for potatoes that you purchased for re-sale.

Note to interviewer: If you are making calls the first week of January, we are looking for the price received by producers for potatoes sold in the month of December. If the producer reports in a unit not shown, report it in other, but try and determine the weight of the unit they are selling in. Please explain any unusual prices in the comment section.

  1. Tablestock
  2. Seed
  3. Sold for processing under contract
  4. Sold for processing without contract

Unit of measure:

  • $/metric tonne (long - 2205 pounds)
  • $/cwt (100 pounds)
  • $/imperial ton (short - 2000 pounds)
  • $/barrel (165 pounds)
  • ¢/pound
  • ¢/kilogram
  • Other, please specify

General information

Confidentiality
 
Your answers are confidential.

Statistics Canada is prohibited by law from releasing any information it collects which could identify any person, business, or organization, unless consent has been given by the respondent or as permitted by the Statistics Act. The confidentiality provisions of the Statistics Act are not affected by either the Access to Information Act or any other legislation. Therefore, for example, the Canada Revenue Agency cannot access identifiable survey records from Statistics Canada.

Information from this survey will be used for statistical purposes only and will be published in aggregate form only.

Record linkages

To enhance the data from this survey, Statistics Canada may combine it with information from other surveys or from administrative sources.

Data-sharing agreements
 
New-Brunswick, Quebec, Ontario, Manitoba, Saskatchewan, Alberta And British Columbia resident:   

To avoid duplication of enquiry, Statistics Canada has entered into a data-sharing agreement with your provincial statistical agency under Section 11 of the Statistics Act. Your provincial agency has legislation similar to the Statistics Act to protect your data. Your data must be kept confidential and be used only for statistical purposes.

Note to interviewers: Because these statistical agencies have the legal authority to compel businesses to provide the same information, consent is not requested and farm operations may not object to the sharing of their data.

New Brunswick, Ontario, Manitoba And British Columbia Resident:

An agreement has also been signed under Section 12 of the Statistics Act with the New Brunswick Agriculture and Aquaculture department, the Ontario Ministry of Agriculture, Food and Rural Affairs, the Manitoba Department of Agriculture, Food and Rural Initiatives and the British Columbia Ministry of Agriculture and Lands. 

Do you agree to share your information with the organization of your province?

Yes
No

Prince Edward Island resident:

To avoid duplication of enquiry, Statistics Canada has entered into a data-sharing agreement with your provincial statistical agency under Section 12 of the Statistics Act. Your provincial agency must keep the data confidential and use it only for statistical purposes. 

Do you agree to share your information with the Prince Edward Island statistical agency?

Yes
No

Fax or other electronic transmission disclosure

There could be a risk of disclosure during the facsimile or electronic transmission. However, upon receipt of your information, Statistics Canada will provide the level of protection afforded for all information collected under the authority of the Statistics Act.

Comments

Confidential (when completed)

Collected under authority of the Statistics Act, Revised Statutes of Canada, 1985, Chapter S19.

Si vous préférez ce questionnaire en français, veuillez cocher ici.

Report for the month of:

If any information above is missing or incorrect please make the necessary changes directly on the label.

The purpose of this survey is to collect reliable and up-to-date information on grains and oil seeds in New Brunswick, Nova Scotia, and Prince Edward Island. These data are used to calculate farm cash receipts and are used by producers, organizations, government departments, and others for policy and decision making.

Please provide the quantity and the amount you paid to producers for any grains and oil seeds you purchased during the above month. Only report grains that you purchased directly from farmers. Do not report any grains that you purchased from other brokers or mills. Please report your purchases as to the province that the grain was grown in. If you did not purchase any grain from Atlantic sources in the month, would you kindly note that on the form.

In compiling average provincial prices to producers, your data will be aggregated with data received from other companies to protect confidentiality.

A postage- paid return envelope is enclosed for your convenience or if you prefer, your completed questionnaire may be faxed to us at (902) 895-7435. Your response by the 15th of the month is appreciated.

If you have any questions or wish further information please do not hesitate to call collect at 902 893-7251.

Thank you for your participation.

Grain or Oil Seeds
Purchased from Nova Scotia

  • Tonnes Purchased
  • $ Paid to Producers

Purchased from New Brunswick

  • Tonnes Purchased
  • $ Paid to Producers

Purchased from Prince Edward Island

  • Tonnes Purchased
  • $ Paid to Producers

a. Feed Wheat
b. Milling Wheat
c. Oats
d. Barley
e. Mixed Grain
f. Corn for Grain
g. Raw Soybeans
h. Roasted Soybeans
i. Sunflowers
j. Other (Please Specify)

A Brief Guide to the Business Register

Business Register Logo

July 2010

Introduction

The Business Register Division plays a vital role in Statistics Canada’s economic statistics program. The purpose of this paper is to give the reader a high-level understanding of how the division fulfils this role. It will outline the division’s products and services and describe the Business Register System (BRS) with its underlying concepts. Finally, it will summarize how the data content is maintained on the BR and the role played by quality throughout the process.

Role and Coverage of the Business Register

The Business Register (BR) is a frame that essentially includes all businesses operating within Canada as well as foreign businesses that have links with Canadian companies. It provides statisticians, engaged in the production and analysis of economic statistics, with the highest quality frame in terms of coverage and data elements.

The BR encompasses some of the fundamental concepts of the System of National Accounts and provides facilities to store, browse, maintain and retrieve frame information. It provides information regarding the composition of the population of businesses in Canada in terms of organisational structure, industrial activity, size and geography. The Register, upon request, generates survey questionnaire identifiers which is required for the survey data collection process. It monitors the level of response burden imposed upon individual Canadian businesses by Statistics Canada and provides relevant information to effectively manage response issues.

The BR also responds to the requirements of users other than the survey divisions. It provides the data and the expertise for understanding the industrial composition of various business communities. Data is disseminated in the form of standard products (Canadian Business Patterns CD-ROM) and custom requests to provincial and territorial statistical bodies, some federal departments, businesses and the general public.

As of July 1, 2010, the Business Register contained approximately 2.2 million active businesses of which 99% was composed of simple single unit businesses (see table 1). The remaining 1% of complex businesses (more than one operating entity) accounted for 52% of the Canadian economy.

Table 1 - Business Register Population Profile – July 2010
  # of Businesses (Enterprises) % of BR Population # of Operating Entities % Total Revenue
Simple (one operating entity) 2,192,872 99% 2,192,872 48%
Complex (multiple operating entities) 20,457 1% 169,988 52%

More than one hundred business surveys use the Register to support their activities which include establishing a survey frame, sampling, collecting and processing data, and producing estimates. More than 1,500 employees throughout the Department use the Register to carry out their day-to-day activities.

Concepts

The BR plays a key role in ensuring coherence between Statistics Canada's survey programs by providing a harmonized central frame and reinforcing the fundamental principles of the System of National Accounts (SNA). This includes such notions as enterprise/ establishment, SNA sectoring, and support of major Statistics Canada standards related to economic surveys such as the North American Industrial Classification System (NAICS) and the Standard Geographical Classification (SGC). BRD is also responsible for finding ways to implement these concepts within an operational mode such as through the efficient use of tax information. By mapping Generally Accepted Accounting Principles (GAAP) which are used in the business world, to SNA concepts, the Register represents the business world realities in a format that meets our statistical needs.

Although impossible to duplicate the real business world in its entirety, the Register tries to ensure that coverage is as complete as possible. The starting point is the list of legal entities produced by the Canada Revenue Agency (CRA). As part of the registration process, CRA collects information such as the legal name, business address and the major activity of the business. Once the legal entity is identified and added to the Register, ownership relationships and additional operating entities are derived, where appropriate, to obtain an integrated structure that corresponds to how the business is organized to conduct its business. The legal entity is the basis used by enterprises to establish their operations and carry on business within Canada and therefore is the central unit of the BR.

In order to be considered for an economic survey, a business must have been assigned a NAICS code and meet at least one of the following criteria:

  • be an employer (i.e., have employees),
  • be a corporate tax filer (T2),
  • be a GST registrant with sales greater than $0,
  • file an individual tax return (T1) showing business revenue greater than $0 and for which we can match the Business Number (BN) to the Social Insurance Number (SIN) and/or
  • show evidence (obtained via profiling activities) of size.
Figure 1 Simple and complex businesses
Description of Figure 1

The BPR integrates the:

  • BN Data
  • Payroll Deduction (PD) Data
  • T1 Unincorporated Data
  • T2 Incorporated Data
  • GST Data

BNs without an economic activity and/or classification code are Out of scope for surveys

Complex Businesses: approximately 20,000 Alive and Active Businesses

Simple Businesses: approximately 2,200,000 Alive and Active Businesses

Different types of organizations are defined as a business such as: a corporation, a self-employed individual, a government entity, a non-profit organization, a partnership, or a financial fund. Understanding the survey population will have an impact on the survey design and improve its effectiveness.

A business is viewed as an integrated structure composed of legal and non-legal operating units. It is the operating units of the integrated structure that are used for sampling purposes. A set of flags has been derived in order to define each unit’s statistical on the Register so as to determine which units should be in scope for a given survey. There are four statistical attributes that are derived for each business:

The statistical Enterprise corresponds to the legal unit in most cases. However, for families of legals that are consolidated, the rule is to select the highest Canadian parent in a hierarchy of legal entities linked by Common Ownership (only majority links considered). For pragmatic reasons a Consolidation may be broken into several Enterprises upon agreement between BRD and the stakeholder survey programs.

The statistical Company is the lowest level of investment centres. This refers to the lowest level where operating profit can be calculated, and that has assets and liability elements to measure capital employed.

The statistical Establishment is, in most cases, equivalent to a profit centre and provides data on the value of output, the cost of inputs and labour. This supplies sufficient data to calculate value added (profit and salary & wages).

The statistical Location is equivalent to the lowest entities within the integrated structure and provides employment and/or revenue data.

The BR is also responsible for maintaining the ownership relationships between legal entities and to record foreign ownership and foreign holdings of Canadian Businesses. This work is performed in close collaboration with other divisions within Statistics Canada.

Business Register System (BRS)

The Business Register System (BRS) is a Microsoft Windows application installed on a client PC. There are five major components comprising the BRS which was developed using a Service Oriented Architecture (SOA). The first component, VB.Net, is the programming language for the Windows Forms User Interface, the business layer and the data layer. The SQL Server 2005 is the underlying database that both stores and manipulates the data. SAS is used to crunch and manipulate input data from external sources. The BRS is a message based system which uses BIZTALK for routing the messages. Finally, Web Services are used to manage both security and access to the data.

All users access the Register by means of the same common interface with a privilege administration tool as the control mechanism to manage this access. The Register includes information on legal and operating entities and their structural relationships. It maintains a journal/log of all updates applied to these entities as well as to stratification variables and information on collection entities. Various modules within the Register manage different aspects of this information.

Browser Module

The Browser Module allows the user to browse and search for information on a given enterprise. It displays information such as the business structure, collection entities, the response burden, and the history of updates contained in the Register (Journal and Log).

The Log contains all of the updates performed on a given variable. The Journal records significant events (e.g., amalgamation, dissolution) concerning a given business.

Update Module

This component serves to control and manage all updates, both manual and batch, that need to be applied to the database.  The BR receives requests or signals for updates from various sources such as subject matter, collection and external administrative sources (e.g., CRA). Although each follows a slightly different process, in general the request is vetted to determine if human intervention is required (the Interceptor and/or Workload) and if accepted, it is applied to the database. Whether a request is rejected or accepted, the systems will send out notification to ensure that the affected parties are aware of the status of the request. The diagram below illustrates the flow of an update request.

Figure 2 Update process
Description of Figure 2

The figure details the workflow of an update request.

Structure Manager Module

The Structure Manager Module is used to show complex structures on the Browser. It manages these enterprise structures and the links that exist between production entities. It manages and controls the parent-child links, propagates attributes within the structure and checks the coherence of the structure once changes have been made.

Collection Entity Module

This module is responsible for generating and updating collection entities based on the information contained in a survey control file received from the survey’s sampling process. It also manages the manual customization of collection entities that is performed by survey managers based on pre-established business rules.

When an edit or change signal arrives at the BR and requires manual processing, the Update Module will generate a signal to the Workload area for purposes of review by an analyst/profiler. The Workload manages, prioritizes and assigns the signals to the analyst/profiler. After a manual review of the signal, the analyst/profiler either implements or cancels the change request.

Survey Interface Module

The function of this module is to produce two key Register products that are necessary to our partners in conducting their surveys: the Generic Survey Universe File (G-SUF) and the Generic Survey Interface File (G-SIF). The monthly standardized G-SUF is the result of extracting all units that comprise the total business population. It contains a list of all units of production with their tombstone information, the industrial classification, the detail geographical code, the size variables (such as revenue and employees), and other information to satisfy sampling procedures. Survey methodologists use this file primarily for the generation of survey samples. It is also used by subject matter divisions as an input to their edit, imputation and estimation system. From the units selected for a given survey by survey methodologists, the BR provides the G-SIF to collection staff. This file contains the information required in order to carry out data collection, such as the contact name, address and telephone number.

Response Burden Module

This module presents all information relating to respondent burden for economic surveys conducted at Statistics Canada. It displays information on all contact that Statistics Canada has had with a given enterprise. The response burden tool displays this information by survey, enterprise, contact name and questionnaire. Finally, it provides extractions concerning exclusion orders and cases that require specialized treatment. A central frame used by the entire economic survey program means a truly comprehensive view of response burden and thus facilitates its management.

Reports and Analysis Tools

These tools produce the reports needed to manage survey operations and analyse sub-populations. The Survey Frame Assessment (SFA) tool extracts and presents changes that have occurred in a survey’s population between two reference points. It includes changes to NAICS code, births, deaths and size indicators such as revenue. The SFA tool can dynamically display all changes that occurred as of the previous day for selected characteristics by operating entity. This is of particular importance as changes can be reviewed immediately prior to the production of the monthly G-SUF. Other tools include the analysis of updates on the Register and demographic analysis of the business population.

Maintaining the Content of the BR

The Register must be updated on an ongoing basis to ensure the continued quality and appropriateness of its information which is essential for designing and implementing effective surveys. Updates to the data content of the BR are based upon several sources of information but primarily upon administrative data from the Canada Revenue Agency (CRA), feedback from client surveys and information collected during the profiling of businesses. The largest complex enterprises are administered under the Enterprise Portfolio Manager (EPM) program, with BRD being responsible for everything else.

Administrative Data

Canada’s statistical system is heavily dependent upon administrative data for the regular production of statistics. The computerization of administrative programs in the 1960s and 1970s made it possible to increase usage of the resulting data files for statistical purposes. In recent years, further technological advances have facilitated and reduced the cost of manipulating large administrative files and have encouraged the increased use of administrative data.

The Register uses the Business number (BN) as the basis by which to identify businesses on the frame. The other administrative sources such as the individual tax return (T1), the corporate tax return (T2), the good and services tax (GST) and the payroll deduction account (PD) are used to complement the BN data with size variables. We use the BN master file from CRA to create and update tombstone data and to identify potential new businesses. CRA also produces a monthly file on amalgamated BNs with the successor BN. This process is fully automated and it permits us to inactivate amalgamated BNs.

The BR is responsible for assigning a code based upon the North American Industrial Classification System (NAICS) to each business. This work is performed by processing the description of the activity gathered by Canadian Revenue Agency (CRA). Fifty percent of these descriptions are classified automatically by the system once a month and the other fifty percent are classified by Statistics Canada employees. Once these businesses are added to the frame, the BR relies upon CRA data and survey feedback to update the information.

Survey Feedback

Surveys are required to provide feedback to BRD on any frame changes to the business and contact information that comes to light while collecting survey data. Changes are transmitted to BRD via an electronic form which in turn runs as a batch job in the survey feedback processing system.  These changes then progress through the update cycle as described earlier.

Profiling

Complex businesses (i.e., businesses that have more than one operating entity) represent less than 1% of the total businesses but contribute to more than 50% of the total revenue in Canada. Although the Business Register uses data from CRA to identify the top legal entity, it is primarily the profiling activities and survey feedback that maintain this population. Data from financial statements and information about the business from their web site are valuable sources of information to delineate the operating entities that form an enterprise. In many cases, contact with the business is required in order to collect more detailed information such as the industrial activity of each operating entity and their accounting practices.

Enterprise Portfolio Management (EPM)

The Enterprise Portfolio Management (EPM) program is under the responsibility of the Enterprise Statistics Division. This team has been assigned roughly 350 of the largest enterprises on the Register. They are responsible for developing and maintaining productive relationships between Statistics Canada and each of the contacts within their portfolios. In essence, the EPMs perform three key functions. They act as focal points for businesses to assist the respondent with the many data demands placed upon them. They also profile business structures in order to gain a clear understanding of how a company’s business and accounting structures relate to their reporting capabilities and to ensure that the Register accurately represents their corporate structures. Finally, the EPMs are responsible for the response management of these large enterprises by coordinating and assisting the collection process for the survey programs.

Quality

The survey frame is at the foundation of every survey program. The quality of the frame is therefore crucial to ensure the production of high quality estimates from each survey. There are millions of changes applied to businesses on the Business Register every year. The majority of these changes are made automatically through the use of administrative data and survey feedback. These are routine updates such as updating the revenue values from the latest income tax return or a change of address for the contact person of a given survey. The remaining updates require review by persons with specialised knowledge (in the Workload module of the BRS). These could include changes in a NAICS code, changes to the status of a business (deathing, birthing) or perhaps an amalgamation. Because these changes could have a significant impact upon our economic survey program, the BR monitors this group closely so users can be informed of any significant change in a timely fashion.

The Quality Assurance Survey (QAS) is a monthly telephone survey of approximately 600 establishments carried out by BRD. Its purpose is to measure the quality of NAICS coding for all establishments on the Register, while at the same time determining the proportion of dead units. Taking this approach provides on-going quality indicators and regular feedback on the impact of changes made to improve these indicators. The QAS results are used to identify problem areas in NAICS coding so that training can be improved. The results will also be used by methodology and subject matter divisions to identify weak areas in the industrial classification process and make any adjustments required to their sampling strategies to compensate for these errors.

Numerous changes occur on the survey frame from one month to the next. Subject matter divisions are interested in understanding both the importance and source of these changes. A large increase or decrease in the number of establishments and any large change in the total revenue requires Methodology and Subject matter specialists to review the change and determine how it should be incorporated within their specific survey program.

To this end, we have developed two features to help provide this information. Firstly, we provide the effective date of the change which records the date of the event.   For example, if the business closed an operation, we have the ability to store the effective date of this event as well as the date when the change was applied to the frame. Secondly, we have developed an analytical tool that displays all changes to the survey frame including the source and the nature of the update. This tool accesses the list of all micro records that brought about these changes. The analysis is performed just before the release of the monthly G-SUF by BRD staff. This is to ensure that the largest contributors to the change from one month to the next are either identified as legitimate change or action is taken to remedy the problem. This analysis also provides us with some indication of the quality of work being performed by the people making updates to the frame. In the cases where errors are found, this analysis allows us to provide constructive feedback to the appropriate individuals. It also gives a good indication of any additional training that may be required.

Conclusion

The BR is a central frame database that supports the sampling and collection process for the economic survey programs. It provides a user friendly environment through which Statistics Canada employees may easily browse and update business structures on a real time basis. Built to accommodate the many varying requirements of different survey programs, the BR gives a comprehensive and accurate picture of businesses in Canada.

Business Special Surveys and Technology Statistics Division
Survey of Intellectual Property
Commercialization in the
Higher Education Sector, 2008

General Information
Identifying Intellectual Property
Protecting Intellectual Property
Exploitation of Intellectual Property by the Institution
Spin-off companies

Electronic questionnaire

A form-fillable PDF questionnaire will be available shortly after the mail-out of the paper questionnaire. To receive a copy, please e-mail your request to Education.oid@statcan.ca.

Instructions for hospitals

Hospitals will receive a one page screening questionnaire in addition to the main (11 page) questionnaire. Hospitals are asked to complete the screening questionnaire first to determine whether they are also being asked to complete the 11 page questionnaire.

If the hospital meets the screening criteria, please proceed to Section 1 - General information – of the questionnaire. Section 1 concerns intellectual property (IP) policies at the hospital.  This will be applicable to your hospital even if IP is commercialized through an affiliated university.

If researchers report IP to your hospital, complete Section 2 as well.

If IP is managed (e.g., patented, licensed, commercialized) by your hospital, complete Sections 3 to 5 as applicable.

If IP developed at your hospital is commercialized by a different institution (e.g., a university technology transfer office), indicate this in the “Comments” section (Question 6.2) and complete only the questions in Sections 3 to 6 that relate to activities at your institution.

Instructions for liberal arts universities and divinity colleges

This survey applies to all members of the Association of Universities and Colleges of Canada (AUCC), including liberal arts universities and divinity colleges. Even if the institution has no invention disclosures or patents, information is still required on other types of intellectual property, such as “educational materials” and “other materials” (e.g., literary works) and on other issues, such as faculty consulting.

You are therefore asked to complete all relevant questions on the questionnaire. The relevant questions are most likely 1.1, 1.2, 1.3a, 1.4, 1.5, 2.1, 3.1 and 3.2.

General instructions

Complete all sections of the questionnaire that are relevant to your institution.

If you don’t have all the information requested, please complete as much as you can. If exact numbers are not readily available, please provide estimates with a note indicating this. Since we plan to ask many of these questions in future surveys, it may be helpful for your institution to set up an information system now to track the information requested for future surveys.

Please do not leave any question blank.If the value is known to be zero, enter the digit "0". If the information is not available, write "not available" in place of the answer. In cases where the question is not applicable, please enter "n/a".

Report all dollar amounts in thousands of Canadian dollars.

If using the paper questionnaire, please type or legibly write your answers to the survey in ink.

Please keep a copy of the completed questionnaire for your own future reference and in case we require further details.

Survey contact: Please include your e-mail address so that we can automatically send you the aggregated results of this survey when available.

Section 1. General Information

1.1
Please provide information for fiscal or business year ending in 2008. If the information provided on this form does not refer to 2008, please note the year to which the data do refer.

1.2
a. Intellectual property management includes intellectual property identification (reporting, patent disclosures), protection (patenting, registration of industrial designs, etc.), promotion (market studies, business plans, prototypes, etc.) or commercialization (licensing, research contracts, consulting, and spin-off investment).

b. Please provide the name of all affiliated institutions included in your figures, and whether those institutions are engaged in intellectual property management activities or not. Affiliated institutions may include universities and research hospitals.

c. Some institutions that create intellectual property may not have the facilities to manage it. For instance, their intellectual property may be managed through another institution.

1.3
a.Intellectual property management” is to be interpreted in the broadest sense. If refers to the activities of an institution's University-Industry Liaison Office, Office of Research, Technology Transfer Office, Software Licensing Office, etc.

b. Please estimate the components of operational expenditures. The components should add to the "total operational expenditures for intellectual property management." If information on the components is not available, provide an estimate of total operational expenditures.

Expenditures should be estimated to correspond to the portion of the office dedicated to intellectual property management as opposed to the research contracts or other functions.

For “employees engaged in intellectual property management”, include both professional and administrative support staff (the portion of their time dedicated to IP management only).  Include persons involved in the negotiation of material transfer and confidentiality agreements but not clinical trial agreements.

c. This question requests information on the sources of funds that were used for intellectual property management in the reference year.

d. For this question, include both professional and administrative support staff.

f. A start-up is a company established to license the institution’s technology.

1.4b
Intellectual property includes:

Inventions: Any patentable product, process, machine, manufacture or composition of matter, or any new and useful improvement of any of these, such as new uses of known compounds (Canadian University Intellectual Property Group, 1998). Some inventions are patentable in some jurisdictions but not in others; these include novel genetically-engineered life forms, new microbial life forms, methods of medical treatment and computer software.

In the event of multiple possibilities (for example, computer software that is patented and copyrighted), count the item only once and preferably in the category most appropriate for Canadian intellectual property legislation.

Computer software or databases: As noted above, computer software can be patented but normally it is protected by copyright. Databases may also be copyrighted.

Educational materials: This category includes special materials that may be copyrighted but are not necessarily in the form of printed books. This could include broadcast lessons, Internet pages, booklets, posters or computer files, among others.

Other materials protected by copyright: This category includes any copyrightable works other than computer software and databases and special educational materials as noted above. For example, it includes literary, artistic, dramatic or musical works, books and papers.

Industrial designs: These are original shapes, patterns or ornamentations applied to a manufactured article. Industrial designs are protected by registration with the Canadian Intellectual Property Office.

Trade-marks and official marks: These are words, symbols, designs, or combinations thereof used to distinguish your wares or services from someone else’s. Trade-marks and official marks are registered with the Canadian Intellectual Property Office.

New plant varieties: Certain plant varieties that are new, different, uniform and stable may be protected by registration with the Canadian Intellectual Property Office.

Other intellectual property includes:

Integrated circuit topographies: This is a three-dimensional configuration of the electronic circuits used in microchips and semiconductor chips. Integrated circuit topographies can be protected by registration with the Canadian Intellectual Property Office.

Know-how is practical knowledge, technique or expertise. For example, certain information is codified in the patent application but a researcher's know-how may be valuable for commercial optimization of the product. Know-how can be licensed independently of the terms of a related patent.

If your institution deals with a type of intellectual property not listed, please indicate it under "Other".

The owner of intellectual property refers to the initial owner of an invention, or the holder of the copyright or the registration of other intellectual property.

1.5 
Faculty consulting activities” refers to paid or unpaid professional activities that are beyond normal academic and collegial duties, for the benefit of clients outside the institution. Unpaid consulting could include advising a non-governmental organization.

1.6
Research contracts
are arrangements under which the institution, or an individual within the institution, agrees to undertake a research project on a specified problem, using the institution's facilities and/or personnel, for a sponsor that provides funds to meet all or part of the costs of the project.

A Canadian business is any business that is incorporated in a Canadian jurisdiction. A foreign business is any business that is not incorporated in a Canadian jurisdiction. Foreign includes the United States. A multinational would be classified as a Canadian business if it has an operation incorporated in a Canadian jurisdiction.

In the case of multiple sponsors, if possible, create a group under "other" that specifies the category of sponsors (e.g., "federal and provincial government"). The sums of the number and value of contracts should correspond to the totals.”

Canadian and foreign “organizations”: include research contracts with not for profit organizations and associations.

“Other” research contracts: include those with other universities and hospitals, institutes, foundations and individuals.

Section 2. Identifying Intellectual Property

2.1
The types of intellectual property are defined under Section 1.4. If, to the best of your knowledge, these forms of intellectual property have never been created at this institution, answer "n/a".

Section 3. Protecting Intellectual Property

3.1
The mechanisms for protecting intellectual property do not exactly parallel the forms of intellectual property.  One invention, for example, may result in several patents, copyrights, trade-marks and confidentiality agreements. The mechanisms for protection are:

Filing of patent applications: A patentable invention (see description under Section 1.4 above) to be protected, requires a patent application with the government of the countries in which protection is sought. A patent application may be preceded by an invention disclosure to the institution.

Registration of copyright: This is intended to cover new copyright registrations only, not those copyrights that are obtained automatically. The kinds of works covered include:

  • computer software and databases
  • educational materials (e.g., broadcast lessons, Internet pages, booklets, posters)
  • books, maps, lyrics, musical scores, sculptures, paintings, photographs, films and tapes.

A copyright means that the owner is the only person who may copy his or her work or permit someone else to do so. You obtain copyright automatically in Canada when you create an original work. It is not necessary to register copyrights with the federal Copyright Office but doing so can be a proof of ownership.

Registration of industrial designs gives the owner exclusive rights to use the design. The design must be an original shape, pattern or ornamentation applied to a manufactured article.

Registration of trade-marks or official marks gives the owner exclusive rights to words, symbols and designs, or combinations of these, that distinguish one's wares or services from those of someone else. Trade-marks and official marks are registered through Canada's Trade-Marks Office. Normally, trade-marks and official marks do not need to be registered, however, doing so gives the owner exclusive rights throughout Canada.

Registration of integrated circuit topographies gives the owner exclusive rights to use the design. Protection can extend to the layout design as well as to the finished product.

Filing of applications for plant breeders' rights gives the holder exclusive rights to new varieties of some plant species. To be protected, the varieties must be new, different, uniform and stable. A claim for protection is preceded by publication of a description of the plant variety in the Plant Varieties Journal.

Executing of non-disclosure or confidentiality agreements: Non-disclosure is an alternative to patenting. A non-disclosure agreement does not constitute a property right although the IP can be protected by contract. Parties to a non-disclosure contract agree not to divulge valuable technical knowledge and can be prohibited from doing so.

A Material Transfer Agreement (MTA) is a contract that governs the transfer of one or more materials from the owner or authorized licensee to another party for research purposes. Materials may include cultures, cell lines, plasmids, nucleotides, proteins, bacteria, transgenic animals, pharmaceuticals and other chemicals. (AUTM Educational Series: Material Transfer Agreements, 1998)

An MTA outbound is one in which the materials originate with the institution.

An MTA inbound is one in which the materials are received by the institution. 

3.2
Number of instances of intellectual property that resulted in protection activity:

Report the number of instances of intellectual property (see definitions in Section 1.4 above) that resulted in a protection activity (see definitions in Section 3.1 above) initiated during the reference year. Do not include patent renewals or other maintenance files.

For copyrighted IP, include only those instances for which a copyright was registered. Do not include copyrights that were obtained automatically.

For each type of IP, the number that resulted in protection activity and the number declined for protection by the institution will not necessarily add up to the number of reports and disclosures in Question 2.1 due to timing differences.

3.3
Patents applications and patents issued

Patent applications” refers to all patent applications completed during the reference year, regardless of country of application.

Patents issued” refers to new patents issued during the reference year. If national and regional applications result in patents issued in multiple countries, count each patent issued in each country.
b. “Total number of patents held by the institution, including patents issued this year” refers to all patents in effect in Canada, the United States and other countries.

Section 4. Exploitation of Intellectual Property by the Institution

4.1
New licenses executed” refers to the completion of an agreement with a client to use the institution’s intellectual property for a fee or other consideration (such as equity in the company).

An option is a right to negotiate for a license.

See Section 1.6a for definitions of Canadian and foreign

 “Sole licenses” are agreements allowing only one client the right to use the intellectual property. 

Exclusive license” refers to one granted that is exclusive for a territory, for a field of use worldwide or otherwise. Hence, there may be multiple exclusive licenses for a single patent. 

In most cases, the number of new licenses recorded in the table (questions 4.1 a and b) should be included in the corresponding cells for number of active licenses (questions 4.1 c and d).

The total number of new licenses/options and the total number of active licenses/options in this (the Statistics Canada) survey should correspond to the same fields on the AUTM Licensing Survey if the two reporting periods are the same.  

4.2 
This question was adapted from one in the AUTM Licensing Survey. The answers to the two questions should correspond if the reference period for the two surveys is the same.

4.3 
Running royalties are those based on the sale of products.

Milestone payments are those made by a licensee at predetermined points in the commercialization process.

Regarding item 3 - one time sales of IP in exchange for a single or several payments - include income from assignments to commercial exploiters.

Other income received from intellectual property: For example, if a potential licensee contributes the funds to apply for the patent, this could be considered another source of income. Please list all items whether or not figures are available.

In some instances, the revenues received from disposition of equity holdings, options and warrants in a spin-off company may be interpreted as a royalty. If possible, please exclude these values from the total and report them under Question 5.3. If this is not possible, please note that the value includes revenues from disposition of equity.

Section 5. Spin-off companies

5.1
This survey attempts to track all spin-offs created to date, including those that are now inactive, closed, merged, etc. If your institution has not previously sent in a list of all spin-offs created to date, we would appreciate receiving such a list now.

Legal name is the name used by the company on official documents, such as incorporation papers or tax forms. It is important to be as accurate as possible since the name permits us to obtain further information from our business records.

Institutional link refers to the nature of the relationship between the institution and the company: licensing, R&D and/or service. There may be one or several institutional links for a given company. If there are other institutional links, please note them.

5.2
For spin-off companies in which the institution holds equity, please report any cash dividends received during the reference year. 

5.3
In cases where equity holdings, options or warrants in spin-off companies have been sold, please report the amount received from these sales. 

5.4
Remaining equity held by the institution” refers to the market value of shares in publicly traded spin-off companies at the end of the fiscal year.  The remaining value of equity reported should be reduced by any cost to acquire it.

5-5300-483.3 2009-05-30  STC/SAT-465-75141