Auditing Grade Changes
This section provides an overview of grade change audits and discusses how to enter grade change audit search parameters.
PeopleSoft Campus Solutions provides grade change audit functionality that captures and displays detailed information about grade changes made through online pages, batch processes, and SQL. Specifically, the system tracks and writes an audit record to the grade change audit table for each of these changes:
Online and self-service changes to the GRADE_INPUT field.
Batch changes to the GRADE_INPUT field on the Grade Lapse Process page.
SQL changes to the Grade Input field.
The grade change audit table captures the entire PS_STDNT_ENRL record and stores an image of the record before and after any changes. The system dates and time stamps and also marks each record in the audit table as a before or after image.
Complete these steps to audit grade changes:
Enter the parameters that define your audit group on the Grade Change Audit page.
Select the View Changes Only check box to see only changes to original grades.
Clear the View Changes Only check box to see both original grades and subsequent grade changes.
Click the Search button to retrieve your results.
Review the results of your search on the Change Detail, Units and GPA, and Miscellaneous Details tabs.
To record the grade changes that the Grade Change Audit functionality audits, your IT team must first install and execute delivered SQL trigger files.
|
Page Name |
Definition Name |
Navigation |
Usage |
|---|---|---|---|
|
Grade Change Audit |
GRADE_AUDIT |
|
Specify grade change audit search parameters and review detailed information about grade changes that match the selection criteria. |
Access the Grade Change Audit page ().
Note: Multiple views of this page are available by clicking the tabs in the scroll area. We document fields that are common to all views first.
Field or Control |
Description |
|---|---|
ID |
The ID of the student to audit. Leave this field blank to have the system retrieve all values for this field (wildcard). |
User ID |
The ID of the user to audit. Leave this field blank to have the system retrieve all values for this field (wildcard). |
Start Date |
Enter the earliest date to audit. Leave this field blank to have the system retrieve all values for this field (wildcard). |
End Date |
Enter the latest date to audit. Leave this field blank to have the system retrieve all values for this field (wildcard). |
View Changes Only |
Select this check box to have the system return only those records with an action of After. Clear this check box to have the system return records with an action of Before and After. |
Search |
Click to retrieve audit data. To refresh the data that the system returns, update the selection criteria and click the button again. Note: After you click the Search button, the retrieval process begins. If the system finds records in the GRADE_AUDIT table within your search criteria, the system refreshes the data on the Change Detail tab. If the process returns no changes, the fields on the Change Detail tab remain blank. |
User ID |
Displays the ID of the individual who made changes to the PS_STDNT_ENRL record. |
ID |
Displays the ID of the student whose grade changed. |
Date/Time |
Displays when a user made changes to the PS_STDNT_ENRL record. |
Action |
Displays the state of the change record. Values are: Before: The image of the record before it was updated. After: The image of the record after it was updated. |
All remaining columns on the Units and GPA tab and the Miscellaneous Detail tab display a subset of columns from the Grade Audit table, which stores a snapshot of the student's record in the PS_STDNT_ENRL table.