The Pay Summary by Location and Pay Date 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 and the pay category associated with the record. Information is organized by location and then by pay date. Managers and administrators can use this report to validate and audit employees’ pay and time for each location and pay date.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Location | Yes | Ascending | |
| Pay Date | Yes | Oldest to Newest | |
| Name Number | A to Z | ||
| Department | |||
| Job | |||
| Schedule In | |||
| Schedule Out | |||
| Actual In | |||
| Actual Out | |||
| Pay Code | |||
| Pay Category | |||
| Scheduled Hours | |||
| 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)
Actual Hours
The Actual Hours custom field displays the pay summary hours where the Premium checkbox isn’t selected. It uses the following expression:
CASE
WHEN EmployeePaySummary.IsPremium=0 THEN CAST(EmployeePaySummary.NetHours AS decimal(38, 3))
WHEN EmployeePaySummary.IsPremium=1 THEN 0.0
END
Filters
The template includes the following filters: