PowerSchool ERP Payroll and Human Resources
PowerSchool ERP Payroll and Human Resources
Breadcrumbs

Timesheet Audit Trail Report

Use the Timesheet Audit Trail Report page to search and view a log of all changes made to Employee Timesheet records, showing what was changed, when it was changed, who made the change, and the old and new values.

From the Human Resources menu, select Reports. From the Employee Timesheets menu, select Timesheet Audit Trail Report.

Security

The Timesheet Audit Trail report requires the following security resource (package HRM, subpackage ETS):

Function 5112: MAY RUN ETS AUDIT TRAIL LOG

Users with the SUPER USER FOR ETS (5100) or PACKAGE SUPERVISOR FOR ETS (5101) resources also have access by virtue of their elevated privilege levels.

Search criteria

Some search criteria fields are consistent for multiple audit trail reports. Key fields are specific to the Timesheet Audit Trail Report and include:

  • Employee Name

  • Employee Number: For a range, enter employee numbers in both the From and To fields.

  • Department: For a range, enter department codes in both the From and To fields.

  • Pay Period: The period for which the time is entered in Timesheets, defined in ETS. For a range, enter pay periods in both the From and To fields.

  • Status: Select a status from the list to refine search results. This field is not displayed for the Table Name: Clocked Time.

Search results

Audit records based on search criteria are displayed. Each column change creates an audit trail record, which includes the key columns for the table and the following details about the change:

  • Date and time of the change

  • Change note entered by the user

  • Column that was changed, previous value, and new value

  • Type of change:

    • A - Added value

    • U - Updated value

    • D - Deleted value

  • The user who made the change

  1. On the Timesheet Audit Trail Report page, enter or select the search criteria to find audit records. You must select a Table Name. Other criteria are optional.

  2. Select Search.

  3. Select Print.

  4. Select a Destination:

    • Select File to create the report in .rpt format. The default file name is ETS_audit.rpt. You can change the default file name.

    • Select Screen to download the report in .pdf format. The default file name is ETS_audit_<#####>.pdf.

    • Select Excel to download the report in .xlsx format. Select the required Excel Options. The default file name is ETS_auditrpt3753_19748.xlsx.

      • Select OK.

        • Download the .rpt file from the View Files page.

        • Save the .pdf or .xlsx file.
          For more information about the Print option, refer to Print Reports.

Field descriptions

The following table describes the fields in the Audit Entry Details section of the Timesheet Audit Trail Report page.

Field

Description

Package Code

Read-only field displays ETS.

Table Name

Selected table:

  • wet_clock_time - Clocked Time

  • wet_detail - Other Time and Daily Time

  • wet_input_days - Attendance

  • wet_app_time - Submit and Approvals

Change Date

Date of activity.

Change Time

Time of activity.

Change Type

The type of the change:

  • Added value

  • Updated value

  • Deleted value

Change Note

Change note entered by the user who made the change.

Column Name

Column names in the list depend on the selected Table Name. Each column change generates a record.

Old Value

Original or previous value of a change that was made.

New Value

Edited or new value of a change that was made.

Changed By

Employee ID of the employee or supervisor who made the change.

Employee Name

Employee whose data was changed.

Employee Number

The employee number of the employee whose data was changed.

In the Search Criteria, enter a single employee number in the From field to search for that employee. To search for a range of employees, enter a different employee number in the To field.

Department

Department of employees whose data was changed.

In the Search Criteria, enter a department in the From field to search for one department. To search across multiple departments, enter a different department in the To field.

Pay Period

Pay period for which data was changed.

In the Search Criteria, enter a pay period in the From field to search for one pay period. To search for a range of pay periods, enter a different pay period in the To field.

Status

Status of the changed record:

  • A - Approved

  • P - Posted

  • S - Submitted

  • N - Not Submitted

  • D - Denied

  • E - Errors Found

This field does not appear when the Table Name selected is Clocked Time.

Clock In/Out Date

Only appears in Audit Entry Details from search results.

In / Out

Only appears in Audit Entry Details from search results.