The Payroll Register by Pay Run topic contains cumulative payroll data. You can use this topic to report on data such as cumulative hours, earnings, and deduction register information. To fulfill auditing requirements, data in this topic reflect what was actually committed in pay runs. The data displayed in a payroll register report is determined by the persisted status of the latest pay run included in the report.
The topic contains fields under the following entities:
- Deduction
- Department
- Earning
- Employee Garnishment
- Employment Status
- Employment Status Group
- Job
- Job Assignment
- Legal Entity
- Location
- Location Hierarchy
- Pay Class
- Pay Group
- Pay Type
- Pay Type Group
- Payroll Register by Pay Run Custom
- Payroll Tax
Note: Many of the fields in this topic are protected by the Payroll Pay Run Result option in the Authorizations tab of System Admin > Roles. For more information on access authorization requirements for individual fields, see the Reporting Data Dictionary tab of the Reporting Reference Guide.
Totals in Payroll Register Reports
In this topic, there are two different types of fields with to-dates (month-to-date, quarter-to-date, and year-to-date): check fields and period fields. You can't apply sum totals to check fields because they contain iterative cumulative amounts. Applying a sum to a check field would result in an overstated total. Period fields might be summed because they’re not iterative. For more information, see the Payroll Administrator Guide.
Best Practices for Payroll Register Reporting
You should follow the best practices outlined below for best performance in payroll register ad hoc reports.
Payroll Register Report Topics
Use the Payroll Register by Pay Run topic whenever possible, especially if you’re reporting on large groups of employees (5,000 or more employees). Only use the Payroll Register by Date Range topic in the following cases:
- To report across multiple pay groups.
- To generate a summation over time periods other than the standard MTD, QTD and YTD totals (for example, plan year, fiscal year, or accounting quarter).
Payroll Register Report Parameters
Use the parameters in the payroll register report topics to refine the data that Dayforce requests from the Payroll module when you generate the report. For example, if you’re reporting on deductions only, select Deduction as the value for the Record Type parameter. That way, when you generate the report, Dayforce only requests deduction records from the Payroll module. If you don’t take this step, it could take longer to generate the report because Dayforce requests all record types from the Payroll module.