Return to Navigation

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:

Page Name

Definition Name

Navigation

Usage

Student Description Audit

RUNCTL_CAN_SDAUD

select Records and Enrollment, then select Government Reporting Canada, then select Reports, then select Student Description Audit, then select 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

select Records and Enrollment, then select Government Reporting Canada, then select Reports, then select Student Program Audit, then select 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

select Records and Enrollment, then select Government Reporting Canada, then select Reports, then select Student Course Audit, then select 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 (select Records and Enrollment, then select Government Reporting Canada, then select Reports, then select Student Description Audit, then select Student Description Audit).

Field or Control

Definition
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 (select Records and Enrollment, then select Government Reporting Canada, then select Reports, then select Student Program Audit, then select Student Program Audit).

Field or Control

Definition
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 (select Records and Enrollment, then select Government Reporting Canada, then select Reports, then select Student Course Audit, then select Student Course Audit).

Field or Control

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