Running Official Languages Reports
Canadian federal institutions are required to report on the official languages used in their departments in accordance with the Official Languages Act (OLA). Human Resources provides the Canadian Official Language Data File report and the Canadian Official Languages reports.
These topics provide overviews of the Canadian Official Language Data File report and the Canadian Official Language reports.
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
Official Language Requirements Page |
RUNCNTL_PER102CN |
Run the Canadian Official Languages Data File SQR (PER102CN), which creates an import file to report official languages information. |
The Canadian Official Language Data File report (PER102CN) creates an import file used by the Official Languages Information System (OLIS II) software, which is required under the OLA to report official language information. The report captures information about permanent employees and temporary employees who work for periods of six months or more.
The following table lists the field names in the report, the fields in PeopleSoft HCM from which the report retrieves the data, and the tables where the fields are located:
|
OLA Report Field Name |
PeopleSoft Field |
PeopleSoft Table |
Notes |
|---|---|---|---|
|
Institution Code |
Institution Code |
COMPANY_TBL |
None |
|
Record ID |
Employee ID |
PERSONAL_DATA |
None |
|
First Official Language |
Preferred Language |
PERSONAL_DATA |
None |
|
Occupational Category |
Occupational Category |
JOBCODE_TBL |
Based on the job code in the employee job record, the report uses the occupational category associated with the job code in the JOBCODE_TBL table. |
|
Language of Service to Public |
Pub Svc Lng Can (public service language Canada) |
PERS_OFFLNG_CAN |
None |
|
Language of Internal Service to NCR |
Intrl Ncr Lng Can (internal National Capital Region language Canada |
PERS_OFFLNG_CAN |
None |
|
Language of Internal Service to Ontario North and East |
Intrl On Lng Can (internal Ontario language Canada) |
PERS_OFFLNG_CAN |
None |
|
Language of Internal Service to Montreal |
Intrl Mnt Lng Can (internal Montreal language Canada) |
PERS_OFFLNG_CAN |
None |
|
Language of Internal Service to Bilingual Quebec-Other |
Intrl Qc Lng Can (internal Quebec language Canada) |
PERS_OFFLNG_CAN |
None |
|
Language of Internal Service to New Brunswick |
Intrl NB Lng Can (internal New Brunswick language Canada) |
PERS_OFFLNG_CAN |
None |
|
Bilingualism Code |
Bilingualism Code |
PERSONAL_DATA |
None |
|
Comm Req Supervision to NCR |
Supr Comm Ncr Can (communication requirements - supervision to National Capital Region Canada) |
PERS_OFFLNG_CAN |
Identifies whether or not the employee is required to provide bilingual supervision to employees located in the NCR. |
|
Comm Req Supervision to Ontario North & East |
Supr Comm On Can (communication requirements - supervision to Ontario North & East Canada) |
PERS_OFFLNG_CAN |
The same as above, except applies to supervision of employees in the bilingual region of Ontario North & East. |
|
Comm Req Supervision to Montreal |
Supr Comm Mnt Can (communication requirements - supervision to Montreal Canada) |
PERS_OFFLNG_CAN |
The same as above, except applies to supervision of employees in the bilingual region of Montreal. |
|
Comm Req Supervision to Bilingual Quebec-Other |
Supr Comm Qc Can (communication requirements - supervision to Quebec and other Canada) |
PERS_OFFLNG_CAN |
The same as above, except applies to supervision of employees in the bilingual region of Quebec - other. |
|
Comm Req Supervision to New Brunswick |
Supr Comm Nb Can (communication requirements - supervision to New Brunswick Canada) |
PERS_OFFLNG_CAN |
The same as above, except applies to supervision of employees in the bilingual region of New Brunswick. |
|
TBS Office Code |
Office Cd Can (office code Canada) |
LOCATION_TBL |
This designates a point of service. The values should correspond to the office codes established by the TBS (Treasury Board Secretariat). |
The Canadian Official Language reports (PER108CN) provide summary information that is required by the OLA. The reports assume an as of date of December 31 of the current year, unless another date is specified.
There are five summary reports that are produced in a print format:
Participation by Province.
Participation by Occupational Category.
Service to Public by Bilingual Office/Point of Service.
Internal Service to Bilingual Regions.
Supervision in Bilingual Regions.
Participation by Province
The Participation by Province summary report includes individuals whose most recent job record has a REG_REGION value equal to CAN and an EMPL_STATUS value equal to A, L, P, or S.
The following table lists the report field names, the fields in PeopleSoft HCM from which the reports retrieve the data, and the tables where the fields are located:
|
OLA Summary Report Field Name |
PeopleSoft Field |
PeopleSoft Table |
Notes |
|---|---|---|---|
|
Province |
JOB..LOCATION_CODE |
JOBCODE_TBL |
Displays the location code based on the employee JOB location code as indicated in the employee job code record. |
|
Total # of Employees (total number of employees) |
JOB.LOCATION_CD |
JOBCODE_TBL |
Displays the total number of employees for each province based on their JOB.LOCATION_CD. When an employee's JOB.LOCATION_CD is equal to the National Capital Region (NCR), that employee is included in the NCR count, not in the provincial count. |
|
Total # of Employees First Official Languages English |
LANGUAGE_CD |
PERSONAL_DATA |
The count of selected employees in the selected group who have a language code that isn't equal to CFR or FR. If the employee's language isn't French, then the report uses English. |
|
Total # of Employees First Official Languages French |
LANGUAGE_CD |
PERSONAL_DATA |
The count of selected employees in a selected group who have a language code that is equal to CFR or FR. |
Participation by Occupational Category
The Participation by Occupational Category summary report includes individuals whose most recent job record has a REG_REGION value equal to CAN and an EMPL_STATUS value equal to A, L, P, or S.
The following table lists the report field names, the fields in PeopleSoft HCM from which the reports retrieve the data, and the tables where the fields are located:
|
OLA Summary Report Field Name |
PeopleSoft Field |
PeopleSoft Table |
Notes |
|---|---|---|---|
|
Occupational Category |
CAN_NOC_CD |
JOBCODE_TBL |
The Occupational Category field displays one of five occupational categories that corresponds to the CAN_NOC_CD code in the JOBCODE_TBL table. The categories are:
|
|
Total # of Employees (total number of employees) |
CAN_NOC_CD |
JOBCODE_TBL |
The count of selected employees with that occupational category. |
|
Total # of Employees First Official Languages English |
LANGUAGE_CD |
PERSONAL_DATA |
The count of selected employees in the selected group who have a language code that isn't equal to CFR or FR. If the employee's language isn't French, then the report uses English. |
|
Total # of Employees First Official Languages French |
LANGUAGE_CD |
PERSONAL_DATA |
The count of selected employees in a selected group who have a language code that is equal to CFR or FR. |
Service to Public by Bilingual Office/Point of Service
The Service to Public by Bilingual Office/Point of Service summary report includes individuals whose most recent job record has an EMPL_STATUS value equal to A, L, P, or S and whose OFF_LNG_RQMT_CAN record has a PUB_SVC_LNG_CAN value of either French, English, or Bilingual.
Employees with a Bilingual value in the PUB_SVC_LNG_CAN field are counted in both the French and English columns, resulting in values that may total more than the value in theResources Serving the Public field. This is according to the OLIS II guidelines.
The following table lists the report field names, the fields in PeopleSoft HCM from which the reports retrieve the data, and the tables where the fields are located:
|
OLA Summary Report Field Name |
PeopleSoft Field |
PeopleSoft Table |
Notes |
|---|---|---|---|
|
Province |
LOCATION_DESCR |
LOCATION_TBL |
None |
|
Location |
STATE_TBL.DESCR |
STATE_TBL |
None |
|
Office Code |
LOCATION_TBL.TBS_ OFFICE_CD_CAN |
LOCATION_TBL |
None |
|
Resources Servicing the Public |
PUB_SVC_LNG_CAN |
OFF_LNG_RQMT_CAN |
The count of selected employees at that location. |
|
Resources Serving in English |
PUB_SVC_LNG_CAN |
OFF_LNG_RQMT_CAN |
The count of selected employees at that location with a PUB_SVC_LNG_CAN value of either English or Bilingual. |
|
Resources Serving in French |
PUB_SVC_LNG_CAN |
OFF_LNG_RQMT_CAN |
The count of selected employees at that location with a PUB_SVC_LNG_CAN value of either French or Bilingual. |
Internal Services to Bilingual Regions
The Internal Services to Bilingual Regions summary report includes individuals whose most recent job record has a REG_REGION value equal to CAN and an EMPL_STATUS value equal to A, L, P, or S.
Individuals must also have a value of either English, French, or Bilingual in any of the following fields on the OFF_LNG_RQMT_CAN page:
INTRL_ON_LNG_CAN
INTRL_NCR_LNG_CAN
INTRL_MNT_LNG_CAN
INTRL_QC_LNG_CAN
INTRL_NB_LNG_CAN
Employees with a Bilingual value in any of these internal services fields are counted in both the French and English columns, resulting in values that may total more than the value in theInternal Services to Bilingual Regions field. This is according to the OLIS II guidelines.
The following table lists the report field names, the fields in PeopleSoft HCM from which the reports retrieve the data, and the tables where the fields are located.
|
OLA Summary Report Field Name |
PeopleSoft Field |
PeopleSoft Table |
Notes |
|---|---|---|---|
|
Internal Services to Employees In:
|
INTRL_NCR_LNG_CAN INTRL_ON_LNG_CAN INTRL_MNT_LNG_CAN INTRL_QC_LNG_CAN INTRL_NB_LNG_CAN |
OFF_LNG_RQMT_CAN |
None |
|
Resources Providing Internal Services |
INTRL_NCR_LNG_CAN INTRL_ON_LNG_CAN INTRL_MNT_LNG_CAN INTRL_QC_LNG_CAN INTRL_NB_LNG_CAN |
OFF_LNG_RQMT_CAN |
Displays the count of employees who have a value of English, French, or Bilingual in theInternal Languages field for each region. |
|
Resources Serving in English |
INTRL_NCR_LNG_CAN INTRL_ON_LNG_CAN INTRL_MNT_LNG_CAN INTRL_QC_LNG_CAN INTRL_NB_LNG_CAN |
OFF_LNG_RQMT_CAN |
Displays the count of employees who have a value of English or Bilingual in theInternal Languages field for each region. |
|
Resources Serving in French |
INTRL_NCR_LNG_CAN INTRL_ON_LNG_CAN INTRL_MNT_LNG_CAN INTRL_QC_LNG_CAN INTRL_NB_LNG_CAN |
OFF_LNG_RQMT_CAN |
Displays the count of employees who have a value of French or Bilingual in theInternal Languages field for each region. |
Supervision in Bilingual Regions
The Supervision in Bilingual Regions summary report includes individuals whose most recent job record has a REG_REGION value equal to CAN and an EMPL_STATUS value equal to A, L, P, or S.
Individuals must also have a value of either English, French, or Bilingual in any of the following fields on the OFF_LNG_RQMT_CAN page:
SUPR_COMM_ON_CAN
SUPR_COMM_NCR_CAN
SUPR_COMM_MNT_CAN
SUPR_COMM_QC_CAN
SUPR_COMM_NB_CAN
The following table lists the report field names, the fields in PeopleSoft HCM from which the reports retrieve the data, and the tables where the fields are located:
|
OLA Summary Report Field Name |
PeopleSoft Field |
PeopleSoft Table |
Notes |
|---|---|---|---|
|
Bilingual Supervision:
|
SUPR_COMM_NCR_CAN SUPR_COMM_ON_CAN SUPR_COMM_MNT_CAN SUPR_COMM_QC_CAN SUPR_COMM_NB_CAN |
OFF_LNG_RQMT_CAN |
None |
|
The Number of Supervisors Required to Be Bilingual |
SUPR_COMM_NCR_CAN SUPR_COMM_ON_CAN SUPR_COMM_MNT_CAN SUPR_COMM_QC_CAN SUPR_COMM_NB_CAN |
OFF_LNG_RQMT_CAN |
Displays the count of employees who have a value of Bilingual in theSupervisors Required field for each region. |
|
Of These, the Number Qualified to Carry Out Their Duties in Both Official Languages |
SUPR_COMM_NCR_CAN SUPR_COMM_ON_CAN SUPR_COMM_MNT_CAN SUPR_COMM_QC_CAN SUPR_COMM_NB_CAN |
PERSONAL_DATA |
None |