This chapter provides an overview of Canadian Government report generation, lists prerequisites, and discusses how to:
(Optional) Generate a report of selected students.
(Optional) Freeze a student list.
Run the PSIS extract process.
Run the USISE extract process.
Run the CIS extract process.
Run the MET extract process.
Run the OUAC extract process.
Verify report results and view the audit report.
Review report data.
(Optional) Correct reporting data.
Archive extract table data.
See Also
(CAN) Setting Up Government Reporting
Generating Canadian government reports is a multiple step process. An overview of the process is as follows:
Set up all of your government reporting data and populate the Student List table.
(Optional) Generate a report of students.
(Optional) Freeze the student list.
Run the extract process.
Review the report data.
(Optional) Correct the source pages or online pages and rerun the extract process.
Or, correct the data directly in the extract table.
Generate the flat file.
Deliver the flat file to the federal or provincial government.
Archive the extract data table file.
These steps are discussed in the following sections.
Before you can generate extract reports and flat files you must:
Set up your system for Canadian Government reporting.
Populate the Student List.
See Also
(CAN) Setting Up Government Reporting
The Student Selection report contains a list of students that correspond to those on the Student List page. You can generate the report before you run the reports extract program.
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_SRSTSEL |
Records and Enrollment, Government Reporting Canada, Reports, Selected Student Report, Selected Student Report |
Define run parameters for the Student Selection report (SRSTSEL). |
Access the Selected Student Report page (Records and Enrollment, Government Reporting Canada, Reports, Selected Student Report, Selected Student Report).
Academic Institution |
Enter the institution for which you want to generate a student selection report. |
Report Type |
Select the report type for which you want to generate a student selection report. |
Report Period |
Enter the report period for which you want to generate a student selection report. This field prompts against the report period table. |
Click Run to run this request. PeopleSoft Process Scheduler runs the SRSTSEL process at user-defined intervals.
The PeopleSoft system provides you with the ability to "freeze" the student list.
Running the freeze process is optional. As a result of running the freeze process, the system prevents you from making changes or additions to the CAN_STDNT_LST table after the freeze date you specify. You can change key information after you run the freeze process. The business processes of your institution determine the timing of this process.
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_FRZE |
Records and Enrollment, Government Reporting Canada, Processes, Freeze Student List, Freeze Student List |
Define run parameters for the Student ID Freeze report (SRFREEZE). |
Access the Freeze Student List page (Records and Enrollment, Government Reporting Canada, Processes, Freeze Student List, Freeze Student List).
Academic Institution |
Enter the institution for which you want to freeze a student list. |
Report Type |
Select the report type for which you want to freeze a student list. |
Report Period |
Enter the report period for which you want to freeze a student list. This field prompts against the report period table. |
Student ID Freeze Date |
Enter the date on which you want to freeze student list records. |
Click Run to run this request. PeopleSoft Process Scheduler runs the SRFREEZE process at user-defined intervals.
This section discusses how to:
Run the PSIS Institution process.
Run the PSIS Student process.
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_ESIS_I |
Records and Enrollment, Government Reporting Canada, Processes, PSIS Institution Process, PSIS Institution Process |
Define run parameters for the Create Extract for PSIS Instit process (SRXTRESI) and the Create Flat file for PSIS Inst process (SRCRFESI). |
|
RUNCTL_CAN_ESIS_S |
Records and Enrollment, Government Reporting Canada, Processes, PSIS Student Process, PSIS Student Process |
Define run parameters for the Create Extract for PSIS Stdnt process (SRXTRESS) and the Create Flat file for PSIS Std process (SRCRFESS). |
Access the PSIS Institution Process page (Records and Enrollment, Government Reporting Canada, Processes, PSIS Institution Process, PSIS Institution Process).
The PSIS Institution flat file process generates the following three flat files:
The PSIS ID (institution description) file lists all unique terms and sessions in the term group table.
The PSIS IP (institution program) file lists all the plans and programs mapped in the Canadian Program and Plan mapping tables.
The PSIS IC (institution course) file lists all the courses for which classes have been scheduled during the terms and sessions included in the term group table, for the selected reporting period.
Academic Institution |
Enter the institution for which you are running the process. |
Report Period |
Select the period for which you are running the process. This field prompts against the report period table. |
File Path |
To send the extract output to a file directory, enter a valid directory path that maps to a folder with appropriate read/write permission. If you cannot locate such a folder, consult your system administrator. Note. The file path must have a "\" (backslash symbol) at the end of the path (for example, c:\temp\). |
Click Run to run this request and select Create Extract for PSIS Instit. Click OK. After the extract process finishes, return to the Process Scheduler Request page and select Create Flat file for PSIS Inst. Click OK.
Access the PSIS Student Process page (Records and Enrollment, Government Reporting Canada, Processes, PSIS Student Process, PSIS Student Process).
Academic Institution |
Enter the institution for which you are running the process. |
Report Period |
Select the period for which you are running the process. This field prompts against the report period table. |
File Path |
To send the extract output to a file directory, enter a valid directory path that maps to a folder with appropriate read/write permission. If you cannot locate such a folder, consult your system administrator. Note. The file path must have a "\" (slash symbol) at the end of the path (for example, c:\temp\). |
Student Selection |
To define the group of students that you want to process, select one of the following options: Process All Students: Select to generate the extract and flat file for all students in the student list table. Process Selected Students: Select this option in conjunction with using the Select check box on the Student List Table page. The reports extract process adds data for a new student or replaces reporting data for an existing student. The reporting information for the students who do not have the Select check box selected remains unchanged by the process. |
Click Run to run this request and select Create Extract for PSIS Std. Click OK. After the extract process finishes, return to the Process Scheduler Request page and select Create Flat file for PSIS Stdnt. Click OK.
This section discusses how to run the USISE extract process and generate a corresponding flat file. Run the USISE extract process if you submit your reporting file directly to the federal government.
Follow these steps to run the USISE extract process and flat file generation for all provinces except Ontario:
Access the USISE Extract Process page and run the USISE extract process.
Access the USISE Extract Process page and run the USISE flat file process.
Note. For Ontario Fall USISE reporting, where the FALL USIS Enrollment reporting submission includes the OUAC elements, running the extract process is a two-step process.
Follow these steps to run the USISE extract process for Ontario Fall USISE reporting:
Access the MET Extract Process page and run the MET extract process.
Access the OUAC Extract Process page and run the OUAC extract process.
Access the OUAC Extract Process page and run the OUAC flat file process.
When you run the OUAC flat file generation process, the system generates two files. One file contains only OUAC elements. The second file is a combined file that contains the USISE, MET, and OUAC elements.
To run the USISE extract process for Ontario USISE reporting not in Fall:
Access the MET Extract Process page and run the MET extract process.
Access the MET Extract Process page and run the MET flat file process.
See Also
Running the MET Extract Process
Running the OUAC Extract Process
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_USE |
Records and Enrollment, Government Reporting Canada, Processes, USISE Report Process, USISE Report Process |
Define run parameters for the Create Extract for USISE process (SRXTRUSE) and the Create Flat file for USISE process (SRCRFUSE). |
Access the USISE Extract Process page (Records and Enrollment, Government Reporting Canada, Processes, USISE Report Process, USISE Report Process).
Academic Institution |
Enter the institution for which you are running the process. |
Report Period |
Select the period for which you are running the process. This field prompts against the report period table. |
File Path |
To send the extract output to a file directory, enter a valid directory path that maps to a folder with appropriate read/write permission. If you cannot locate such a folder, consult your system administrator. Note. The file path must have a "\" (slash symbol) at the end of the path (for example, c:\temp\). |
Student Selection |
To define the group of students that you want to process, select one of the following options: Process All Students: Select to generate the extract and flat file for all students in the student list table. Process Selected Students: Select this option in conjunction with using the Select check box on the Student List Table page. The reports extract process adds data for a new student or replaces reporting data for an existing student. The reporting information for the students who do not have the Select check box selected remains unchanged by the process. |
Data Type |
Enter the DATYPE element. |
Reporting Type |
Enter the INSTYP element. |
Click Run to run this request and select Create Extract for USISE. Click OK. After the extract process finishes, return to the Process Scheduler Request page and select Create Flat file for USISE. Click OK.
This section discusses how to run the CIS extract process and generate a corresponding flat file. Run the CIS extract process if you submit your reporting file directly to the federal government.
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_CIS |
Records and Enrollment, Government Reporting Canada, Processes, CIS Report Process, CIS Extract Process |
Define run parameters for the Create Extract for CIS process (SRXTRCIS) and the Create Flat file for CIS process (SRCRFCIS). |
Access the CIS Extract Process page (Records and Enrollment, Government Reporting Canada, Processes, CIS Report Process, CIS Extract Process).
Academic Institution |
Enter the institution for which you are running the process. |
Report Period |
Select the period for which you are running the process. This field prompts against the report period table. |
File Path |
To send the extract output to a file directory, enter a valid directory path that maps to a folder with appropriate read/write permission. If you cannot locate such a folder, consult your system administrator. Note. The file path must have a "\" (slash symbol) at the end of the path (for example, c:\temp\). |
Student Selection |
To define the group of students that you want to process, select one of the following options: Process All Students: Select to generate the extract and flat file for all students in the student list table. Process Selected Students: Select this option in conjunction with using the Select check box on the Student List Table page. The reports extract process adds data for a new student or replaces reporting data for an existing student. The reporting information for the students who do not have the Select check box selected remains unchanged by the process. |
Click Run to run this request and select Create Extract for CIS. Click OK. After the extract process finishes, return to the Process Scheduler Request page and select Create Flat file for CIS. Click OK.
This section discusses how to run the MET extract process and generate a corresponding flat file.
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_MET |
Records and Enrollment, Government Reporting Canada, Processes, MET Report Process, MET Extract Process |
Define run parameters for the Create Extract for MET process (SRXTRMET) and the Create Flat file for MET process (SRCRFMET). |
Access the MET Extract Process page (Records and Enrollment, Government Reporting Canada, Processes, MET Report Process, MET Extract Process).
Academic Institution |
Enter the institution for which you are running the process. |
Report Period |
Select the period for which you are running the process. This field prompts against the report period table. |
File Path |
To send the extract output to a file directory, enter a valid directory path that maps to a folder with appropriate read/write permission. If you cannot locate such a folder, consult your system administrator. Note. The file path must have a "\" (slash symbol) at the end of the path (for example, c:\temp\). |
Student Selection |
To define the group of students that you want to process, select one of the following options: Process All Students: Select to generate the extract and flat file for all students in the student list table. Process Selected Students: Select this option in conjunction with using the Select check box on the Student List Table page. The reports extract process adds data for a new student or replaces reporting data for an existing student. The reporting information for the students who do not have the Select check box selected remains unchanged by the process. |
Data Type |
Enter the DATYPE element. |
Reporting Type |
Enter the INSTYP element. |
Click Run to run this request and select Create Extract for MET. Click OK. After the extract process finishes, return to the Process Scheduler Request page and select Create Flat file for MET. Click OK.
In Ontario, running the MET extract process and generating the MET flat file will satisfy most of your reporting.
However, in Ontario, where the FALL USIS Enrollment reporting submission includes the OUAC elements, the process is more complex.
Follow these steps to generate the OUAC report for Ontario Fall USIS Enrollment reporting:
Run the MET extract process.
Run the OUAC extract process.
Run the OUAC flat file generation process.
When you run the flat file process for OUAC, it generates two files. One file contains just the OUAC elements, and the second file is a combined file that contains the USISE, MET, and OUAC elements.
See Also
Running the MET Extract Process
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_OUAC |
Records and Enrollment, Government Reporting Canada, Processes, OUAC Report Process, OUAC Extract Process |
Define run parameters for the Create Extract for OUAC process (SRXTROUC) and the Create Flat file for OUAC process (SRCRFOUC). |
Access the OUAC Extract Process page (Records and Enrollment, Government Reporting Canada, Processes, OUAC Report Process, OUAC Extract Process).
Academic Institution |
Enter the institution for which you are running the process. |
Report Period |
Select the period for which you are running the process. This field prompts against the report period table. |
File Path |
To send the extract output to a file directory, enter a valid directory path that maps to a folder with appropriate read/write permission. If you cannot locate such a folder, consult your system administrator. Note. The file path must have a "\" (slash symbol) at the end of the path (for example, c:\temp\). |
Student Selection |
To define the group of students that you want to process, select one of the following options: Process All Students: Select to generate the extract and flat file for all students in the student list table. Process Selected Students: Select this option in conjunction with using the Select check box on the Student List Table page. The reports extract process adds data for a new student or replaces reporting data for an existing student. The reporting information for the students who do not have the Select check box selected remains unchanged by the process. |
Click Run to run this request and select Create Extract for OUAC. Click OK. After the extract process finishes, return to the Process Scheduler Request page and select Create Flat file for OUAC. Click OK.
After you run the extract process, you can run a number of audit reports to verify that the system generated reporting data for all students in the student list table. This section discusses how to:
Run the Student Description Audit.
Run the Student Program Audit.
Run the Student Course Audit.
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_SDAUD |
Records and Enrollment, Government Reporting Canada, Reports, Student Description Audit, Student Description Audit |
PSIS: Verify that the system reported all students in the student list table. This report compares the students reported in the SD file to each unique student ID in the CAN_STDNT_LST table and reports the differences. |
|
RUNCTL_CAN_SPAUD |
Records and Enrollment, Government Reporting Canada, Reports, Student Program Audit, Student Program Audit |
PSIS: Verify that there is a corresponding record in the CAN_RPT_ESIS_SP table for all entries in the CAN_STDNT_LST table. Specifically, verify that the career, program, and plan entered for the student in the student list table are valid. If they are not, then the extract program does not produce a record on the SP, SC, and ST files. Invalid students will also be included in the report if the career, program, or plan entered for the student is not valid. CIS, MET, OUAC, USISE: Verify report discrepancies such as an invalid EMPLID, career, program, or plan. |
|
RUNCTL_CAN_SCAUD |
Records and Enrollment, Government Reporting Canada, Reports, Student Course Audit, Student Course Audit |
PSIS: Identify students who are enrolled in duplicate course IDs during the reporting period. If you find duplicate course IDs, you must manually delete one of the classes from the Student Course 1 page, as this condition will fail the Stats Canada audit. |
Access the Student Description Audit page (Records and Enrollment, Government Reporting Canada, Reports, Student Description Audit, Student Description Audit).
Academic Institution |
Enter the institution for which you want to audit. |
Report Period |
Select the report period for which you want to audit. |
Click Run to run the SRSDAUD report using PeopleSoft Process Scheduler.
Access the Student Program Audit page (Records and Enrollment, Government Reporting Canada, Reports, Student Program Audit, Student Program Audit).
Academic Institution |
Enter the institution that you want to audit. |
Report Type |
Select the report type that you want to audit. |
Report Period |
Select the report period that you want to audit. |
Click Run to run the SRSPAUD report using PeopleSoft Process Scheduler.
Access the Student Course Audit page (Records and Enrollment, Government Reporting Canada, Reports, Student Course Audit, Student Course Audit).
Academic Institution |
Enter the institution that you want to audit. |
Report Period |
Select the report period that you want to audit. |
Click Run to run the SRSCAUD report using PeopleSoft Process Scheduler.
After you run the extract process, you can view and edit the results by navigating to online pages that display the extract report results. However, you cannot add a new row of information for a student. If you need to add a row of data, you must add another line in the CAN_STDNT_LST table with its associated key field values and rerun the extract report.
Page Name |
Definition Name |
Navigation |
Usage |
CAN_RPT_ESIS_ID |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Institution Description, PSIS Institution Description |
PSIS: Review institution term data. |
|
CAN_RPT_ESIS_IP |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Institution Program, Institution Program 1 |
PSIS: Review institution and program code data. |
|
CAN_RPT_ESIS_IP3 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Institution Program, Institution Program 2 |
PSIS: Review additional institution and program code data. |
|
CAN_RPT_ESIS_IC |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Institution Course, PSIS Institution Course |
PSIS: Review additional institution and program code data. |
|
CAN_RPT_ESIS_SD |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Description, Student Descr 1 |
PSIS: Review descriptive data for a student. |
|
CAN_RPT_ESIS_SD2 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Description, Student Descr 2 |
PSIS: Review additional descriptive data for a student. |
|
CAN_RPT_ESIS_SD1 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Description, Student Descr 3 |
PSIS: Review additional descriptive data for a student. |
|
CAN_RPT_ESIS_SD3 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Description, Student Descr 4 |
PSIS: Review additional descriptive data for a student. |
|
CAN_RPT_ESIS_SD6 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Description, Student Descr 5 |
PSIS: Review additional descriptive data for a student. |
|
CAN_RPT_ESIS_SP |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Program, Student Program 1 |
PSIS: Review program related data for a student. |
|
CAN_RPT_ESIS_SP2 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Program, Student Program 2 |
PSIS: Review additional program related data for a student. |
|
CAN_RPT_ESIS_SP3 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Program, Student Program 3 |
PSIS: Review additional program related data for a student. |
|
CAN_RPT_ESIS_SP4 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Program, Student Program 4 |
PSIS: Review additional program related data for a student. |
|
CAN_RPT_ESIS_SC |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Course, Student Course 1 |
PSIS: Review course related data for a student. |
|
CAN_RPT_ESIS_SC2 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Course, Student Course 2 |
PSIS: Review additional course related data for a student. |
|
CAN_RPT_ESIS_SC3 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Course, Student Course 3 |
PSIS: Review additional course related data for a student. |
|
CAN_RPT_ESIS_ST |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Transfer Credits, Student Trans Cred 1 |
PSIS: Review receiving institution transfer coursework for a student. |
|
CAN_RPT_ESIS_ST2 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, PSIS Student Transfer Credits, Student Trans Cred 2 |
PSIS: Review external institution transfer coursework for a student. |
|
CAN_USISE |
Records and Enrollment, Government Reporting Canada, Suspense Tables, USISE Elements, USISE Elements 1 |
USISE: Review USISE elements data for a student. |
|
CAN_USISE_2 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, USISE Elements, USISE Elements 2 |
USISE: Review additional USISE elements data for a student. |
|
CAN_CIS |
Records and Enrollment, Government Reporting Canada, Suspense Tables, CIS Elements, CIS Elements 1 |
CIS: Review CIS elements for a student. |
|
CAN_CIS2 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, CIS Elements, CIS Elements 2 |
CIS: Review additional CIS elements for a student. |
|
CAN_CIS1 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, CIS Elements, CIS Elements 3 |
CIS: Review additional CIS elements for a student. |
|
CAN_USMET |
Records and Enrollment, Government Reporting Canada, Suspense Tables, MET Elements, MET Elements 1 |
MET: Review MET elements for a student. |
|
CAN_USMET_2 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, MET Elements, MET Elements 2 |
MET: Review additional MET elements for a student. |
|
CAN_USMET1 |
Records and Enrollment, Government Reporting Canada, Suspense Tables, MET Elements, MET Elements 3 |
MET: Review additional MET elements for a student. |
|
CAN_OUAC |
Records and Enrollment, Government Reporting Canada, Suspense Tables, OUAC Elements, OUAC Elements |
OUAC: Review OUAC Elements for a student. |
Before you send your report to the government, you may want to correct the reporting data. You can correct reporting data in one of two ways:
PeopleSoft source pages (student data or setup data).
Report data pages (for example, the Student Course 1 page).
When you rerun the report, the system reprocesses any changes that you make using method one, as long as the effective date of the change is less than or equal to the value in the Report Due Date field on the Can Report Period page. This implies that you must rerun the extract program. If you do not enter a date in the Report Due Date field, the system references the system date to determine what to include in the report.
Note. You will make most corrections using method number one. You should correct data using method two only if you are certain that you will not be required to rerun the reports extract program. The extract program will overwrite any corrections you make in method two when you rerun the process. Changes made through method two are best used for updating the flat file.
See Also
(CAN) Generating Canadian Government Reports
After you submit the flat files to the government, you can archive the data in the reports extract archive tables. This process takes the data in the extract tables and saves it to archive tables. The report date acts as an effective date; so you can store multiple report periods in the applicable archive tables. After you run the archive process for a particular report and report period, you cannot run the archive process again. If you attempt to do so, the archive program writes a message in the log file.
The system archives your data in the following tables:
CAN_ARC_ESIS_IC
CAN_ARC_ESIS_ID
CAN_ARC_ESIS_IP
CAN_ARC_ESIS_SC
CAN_ARC_ESIS_SD
CAN_ARC_ESIS_SP
CAN_ARC_ESIS_ST
CAN_ARCH_USISE
CAN_ARCH_USMET
CAN_ARCH_CIS
CAN_ARCH_OUAC
Page Name |
Definition Name |
Navigation |
Usage |
RUNCTL_CAN_ARCHIVE |
Records and Enrollment, Government Reporting Canada, Processes, Archive Extract File, Archive Extract File |
All: Define run parameters for the Canada Report Archive process (SRARCH). |
Access the Archive Extract File page (Records and Enrollment, Government Reporting Canada, Processes, Archive Extract File, Archive Extract File).
Academic Institution |
Enter the institution that you want to archive. |
Report Type |
Enter the report type that you want to archive. |
Report Period |
Enter the report period that you want to archive. |
Click Run to run the SRARCH report using PeopleSoft Process Scheduler.