The Earnings and Hours by Range report uses the Payroll Register by Date Range topic to display date range sums of hours and earnings by primary work assignment. Administrators can use this report to review employees’ YTD and date range totals for selected hours and earnings, with totals for each location.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Pay Group | Yes | Ascending | |
| Legal Entity | Yes | Ascending | |
| Location | Yes | Ascending | |
| Employee | A to Z | ||
| Record Category | |||
| Record Code | |||
| Date Range Hours | Column: Sum | ||
| Date Range Earnings | Column: Sum | ||
| YTD Hours | Column: Sum | ||
| YTD Earnings | Column: Sum |
Custom Fields
Date Range Hours
The Date Range Hours custom field displays current hours used with the rate to derive earnings. It uses the following expression:
CASE
WHEN PRPayRunRegisterPeriod.IsPremiumEarning = 'True' THEN 0.00
ELSE PRPayRunRegisterPeriod.Hours
END
YTD Hours
The YTD Hours custom field displays the date range YTD hours. It uses the following expression:
CASE
WHEN PRPayRunRegisterPeriod.IsPremiumEarning = 'True' THEN 0.00
ELSE PRPayRunRegisterPeriod.HoursYTD
END
Filters
The template includes the following filters: