Map Fields for Custom Reporting of Pay Results
Security:
Set Up: Payroll (Reporting)
domain in the Core Payroll functional area.In addition to viewing payroll results in standard Workday reports, you can create custom reports using the Workday Report Writer. To report on earnings, deductions, pay component related calculations, or pay accumulations, you must map the components to Workday-provided report fields.
If you map more than 1 pay component to the same report field, Workday calculates the component values, then reports the total value in the report field.
- Access theMaintain Pay Results - Class Report Field Mappingtask.
- Select the tab for the type of results you want to display in the report:
- Pay Component Results: Use to map earnings, deductions, pay component related calculations, and pay accumulations to a report field. When you include the item in a custom report, the reported value represents a single gross-to-net result. Example: When reporting mapped overtime earnings to regular overtime pay, premium overtime pay, and double time overtime pay, Workday returns the sum of the pay components in the report field.Ensure each Class Report Field is mapped 1 time only and added to each custom report 1 time only.
- Pay Component Balance Results: Use to map earnings, deductions, pay component related calculations, and pay accumulations to a report field, and display the results over a specified balance period. Examples: month-to-date, quarter-to-date.
- Pay Component Group Results: Use to map pay component groups to a report field.
- As you complete the task consider:
Option Description Class Report FieldUse 1 of the Workday-provided placeholder report fields.The number of placeholder report fields used for Results, Balances, and Groups is limited. The number of dedicated report fields may change over time.LabelEnter a meaningful label that represents the mapped pay components for the report field in the Report Writer. Use a unique label that is clear for custom report users.Example: Base Pay for a field with these pay components:- Base Pay (Position)
- Base Pay by Project
Used in Custom ReportsView the list of reports that currently use a mapped report field. When a field is mapped for the first time, this is empty.Updating a label or changing pay component mapping may have unintended impacts on existing custom reports.Each row in the task must be complete, otherwise you can't save the task.
View the list of reports that use a mapped report field on the
Used in Custom Reports
field on the View Pay Results - Class Report Field Mapping
report.Access the
Create Custom Report
task to create a custom report.When creating a custom report, you must specify a data source. Select your mapped report fields from the
Payroll Processing/Results
prompt folder.