The Pay Summary by Department and Employee report is a variation of the Pay Summary report. This variation uses the Pay Summary topic to display pay data for employees, such as how much employees earned, overtime hours, and other pay categories. Information is organized by department, location, and then by employee. Managers and administrators can use this report to validate and audit employees’ pay and time for each department and each employee.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Department | Yes | Ascending | |
| Location | Yes | Ascending | |
| Name Number | Yes | A to Z | |
| Pay Date | Oldest to Newest | ||
| Job | |||
| Schedule In | |||
| Schedule Out | |||
| Actual In | |||
| Actual Out | |||
| Pay Code | |||
| Pay Category | |||
| Schedule Hours | Column total: Sum | ||
| Actual Hours | Column total: Sum | ||
| Pay Amount | Column total: Sum |
Custom Fields
Actual In
The Actual In custom field displays the start time of the pay summary report. It uses the following expression:
Cast(EmployeePaySummary.TimeStart as Time)
Actual Out
The Actual Out custom field displays the end time of the pay summary report. It uses the following expression:
Cast(EmployeePaySummary.TimeEnd as Time)
Filters
The template includes the following filters: