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