Verifying Report Results and Viewing the Audit Reports

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

Student Description Audit

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.

Student Program Audit

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.

Student Course Audit

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.

See Reviewing Report Data.

Access the Student Description Audit page (Records and Enrollment > Government Reporting Canada > Reports > Student Description Audit > Student Description Audit).

Field or Control

Description

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).

Field or Control

Description

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).

Field or Control

Description

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.