The Payroll Register History topic contains periodic details over a date range; users can retrieve data such as hours, earnings and deduction register information. Reports based on this topic return results based on the population of qualified employees at every point in the date range rather than an aggregation of the data for employees who are qualified at the end of the date range. The change in qualified employees over time is reflected in reports based on this topic. This topic allows you to report on all of the same fields found in the other Payroll Register topics, but with period totals instead of a pre-aggregated total for a date range.
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 History 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.
Payroll Register Report Parameters - Best Practice
It’s recommended that you follow best practices to maintain acceptable performance when running payroll register ad hoc reports.
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.