A School or District Administrator can review the activity of user accounts on a PowerSchool SMS system. This is made possible by PowerSchool SMS’s Database Audit Log, which contains a time-stamped record of any action that changes the information stored in the system [Figure 93].
Figure 93: Database Audit Log sample records
| A | Date: The date and time of the change. |
In general, changes to information are recorded while changes to system setup, such as modifications to the grading structure, are not. The Database Audit Log includes records of user-made changes to the following:
| = | Student academic plans [>>], including notes |
| = | Academic plan setup [>>], including assigned courses, eligibility rules, groups and plan versions |
| = | Attendance [>>] |
| = | Grade level transfers and any resulting attendance reassignments |
| = | Modifications to daily code calculation rules, including rule priority changes |
| = | Student health records |
| = | Student historical transcript records [>>] |
| = | Gradebook task and server errors |
| = | GPA and honor roll definitions during Year-End Processing [>>] |
| = | Grading calculation overrides, including GPA, credit, honor roll, and class rank overrides |
| = | Student enrollment [>>] |
| = | cTools fields [>>] of the following type: Alphanumeric, Numeric, Date, Yes/No, Setup List (not Memo or File). The cTools field must be on a schema that has been enabled for auditing. You can enable any schema you create in cTools for auditing via the Add/Edit Page page associated with any new grid. |
| = |
|
| = | Attendance change reasons [>>] |
The Database Audit Log also records the following:
| = | Course deletions from a student’s Academic Plan [>>] as a result of a course deletion from the district Planning Calendar course catalog made by PowerSchool SMS during Year-End Processing [>>]. |
| = | Online Course Recommendations: All course recommendation modifications and deletions [>>]. |
| = | Online Course Requests [>>] |
PowerSchool SMS logs some changes immediately and others during an overnight auditing process. The default time at which PowerSchool SMS conducts its audit is 8:00 pm. Note: If PowerSchool SMSfails or times out in an attempt to audit a particular feature during its overnight process, it records the failure in the Database Log as a "Task Manager Event" and alerts [>>] the District Administrator with the message "Audit log tasks could not be completed".
You can view the Database Audit Log’s records according to date range, district, school, student, user account, and functional area of the system. You also have the option of clearing the log of the records you view.
Table 25: Permissions pertaining to the Audit Log
|
To |
You need this permission |
Set to |
|
|
View the Audit Log |
School Setup > View Audit Log |
Yes |
|
|
Print an Audit Log report |
School Setup > View Audit Log |
Yes |
|
|
Clear the Audit Log |
School Setup > Purge Audit Log |
Yes |
Pearson
Always Learning
www.pearsonschoolsystems.com
Tel: 866-434-6276
Email: psstechsupp@pearson.com
