Timesheet Hours Analysis Report | PowerSchool Atrieve

The Timesheet Hours Analysis Report allows you to report on timesheet hours for employees using a wide selection of reporting formats. This report lists an employee's hours compressed per day, pay code and salary with an optional pay code summary per employee. Employee detail that totals zero for a day will be suppressed although the hours and employee count is still included in the averaging.

You may define selective employees, statuses, locations, pay codes and employee types to be reported. The employee's type codes are as per the employee's master function line at report time.

This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30-character description.

On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.

Use Location & Salary Grid from Timesheet Records

Enter 'Y' to use the location code and salary grid from the DTE timesheets. When these fields are empty on the timesheet, the empty fields will be loaded from values from the employee's master. Overriding these fields will be noted in the report log.
Enter 'N' to use the location code and salary grid from the employee's master record for all timesheet entries.

Enter Starting Pay Period

Enter a pay period to define a range of pay periods to be reported.

Enter Ending Pay Period

Enter an ending pay period for a range of periods to be reported.

Enter Starting Date Range

To report all timesheets for the batches selected or enter a start date for a range of dates to be reported.

Enter Ending Date Range

To report all timesheets for the batches selected enter an ending date for a range of dates to be reported.

Report All or Selected Employees

When 'A'll or 'R'ange was selected:

Select Employee Statuses To Be Reported

The employee selection by employee status allows you to select one or more employee statuses to be included.

Enter 'A' to select Active employees.
Enter 'T' to select Terminated employees.
Enter 'O' to select On Leave employees.
Enter 'B' to select On Leave With Benefits employees.
Enter 'F' to select all employees.

Enter Pay Code Include/Exclude

Enter 'E' to indicate the following list of pay codes will be excluded from the report.
Enter 'I' to indicate the following list of pay codes will be included on the report.

Enter Pay Codes

Enter 1 to 25 pay codes to be included or excluded from the report.

Enter Employee Types for Employee Selection

Enter up to 25 employee type codes for employee selection. Only employees with one of these employee type codes on the master function line will be included on the report.

Enter Location Codes for Selection

Enter up to 15 location codes for timesheet/employee selection. Only timesheets with the selected location codes will be included. If the report has been set to load the location from the master location code, the master location will be used in making the timesheet selections.

Report Summary Only

Enter 'N' to omit the employee details and the hours per pay code information.
Enter 'Y' to produce a summary only report. Only the totals per main category of the report will be listed.

When Summary was Not selected:

Report Employee Details

Enter 'N' to omit reporting details per employee.
Enter 'Y' to include details per employee on the report. Employee's entries are compressed per date, pay code and salary grid.

When Report Details was selected:

Include Employee Pay Code Total

Enter 'N' to omit the summary by pay code per employee.
Enter 'Y' to include a summary per pay code per employee on the report.

Select Sort/Style of Report:

1. employee name
2. Location Description THEN Employee Name
3. Location Description, Employee Type THEN Employee Name
4. Location Code, Location Description THEN Employee Name
5. Location Code, Location Description, Employee Type THEN Employee Name
6. Employee Type THEN Employee Name
7. Employee Type THEN Location Code
8. Employee Type THEN Location with Page Break per Location

Using the up and down arrow keys, on the report sort/style to be created. These categories determine the sorting and sub totaling for the report.

The report details lists the following information:

Employee name, employee number
Salary grid
Timesheet date
Day of timesheet
Pay code and short description
Total hours per date, pay code and salary grid
Total hours per pay code per employee, when applicable
Total employees and hours with average hours per category
Total hours per pay code per category, when applicable
Grand total per pay code, employees selected, hours and average hours
Total employees reported