The Pay Summary With Payroll WFM Mapping report is a variation of the Pay Summary report. This variation contains your pay summary and indicates if any WFM-mapped pay codes contributed to earnings that are generated by features in the Dayforce Payroll module. The totals shown in the report for WFM-mapped pay codes aren't paid out to employees. The Dayforce pay rule engine evaluates these totals when calculating pay and they’re included in the report for informational purposes.
You configure WFM-mapped pay codes in the WFM Mapping tab of Pay Setup > Pay Group.
Note: To improve performance when generating the report, it's recommended that you don’t run the report for the top level of your organizational hierarchy. You should run the report for one location at a time.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee Number | Yes | A to Z | |
| Employee Name | Ascending | ||
| Pay Date | Oldest to Newest | ||
| Location | |||
| Department | |||
| Job | |||
| Actual In | |||
| Actual Out | |||
| Authorized Manager | |||
| Authorized Employee | |||
| Is Payroll To WFM Mapping | |||
| Pay Code | |||
| Pay Category | |||
| Normal | |||
| Other | |||
| Pay Amount |
Custom Fields
Actual In
The Actual In custom field shows 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 shows the end time of the pay summary report. It uses the following expression:
Cast(EmployeePaySummary.TimeEnd as Time)
Authorized Manager
The Authorized Manager custom field indicates if the manager authorized the record. It uses the following expression:
CASE WHEN EmployeePunch.ManagerAuthorized=1 THEN 'Yes' WHEN EmployeePayAdjust.ManagerAuthorized=1 THEN 'Yes' ELSE 'No' END
Authorized Employee
The Authorized Employee custom field indicates if the employee authorized the record. It uses the following expression:
CASE WHEN EmployeePunch.EmployeeAuthorized=1 THEN 'Yes' WHEN EmployeePayAdjust.EmployeeAuthorized=1 THEN 'Yes' ELSE 'No' END
Is Payroll To WFM Mapping
The Is Payroll To WFM Mapping custom field indicates if the record contains any payroll to WFM mapping. It uses the following expression:
CASE WHEN EmployeePaySummaryWithWFMReverseMapping.IsPayrollWFMMapping = 1 THEN 'Yes' ELSE 'No' END
Normal
The Normal custom field shows pay summary hours where the Premium checkbox is cleared. It uses the following expression:
CASE WHEN EmployeePaySummaryWithWFMReverseMapping.IsPremium=0 THEN CAST(EmployeePaySummaryWithWFMReverseMapping.NetHours as decimal(38,3)) WHEN EmployeePaySummaryWithWFMReverseMapping.IsPremium=1 THEN 0.0 END
Other
The Other custom field shows pay summary hours where the Premium checkbox is selected. It uses the following expression:
CASE WHEN EmployeePaySummaryWithWFMReverseMapping.IsPremium=1 THEN CAST(EmployeePaySummaryWithWFMReverseMapping.NetHours as decimal(38,3)) WHEN EmployeePaySummaryWithWFMReverseMapping.IsPremium=0 THEN 0.0 END
Filters
The template includes the following filters: