The Payroll Register by Date Range topic contains payroll data summed over a date range; users can retrieve data such as cumulative hours, earnings and deduction register information. Administrators can use this topic to view payroll register data for a specified date range.
To fulfill auditing requirements, data in this topic only 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 Date Range 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.
Payroll Register Record Type Field
This topic includes the Record Type field, which displays one of the following types for each record:
- Earning
- Deduction
- Garnishment
- Tax
- Net
- Earning Grouping
- Deduction Grouping
- Deduction Arrears
Dayforce includes all of these types of records in reports by default, except for earning groupings and deduction groupings. To include grouping type records in reports, an administrator must select the Include in Payroll Register checkbox in the Reporting Options section of the Earning Groupings tab in Payroll Setup > Groupings. See the Payroll Administrator Guide.
Further, there are several fields in this topic that are specific to certain record types. These fields will be null for records of other types. For example, the Earning Generated Flag field is specific to Earning type records. In Earning type records, the column displays “True” or “False”, while in other types of records, the column is empty.
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.