Create Calculated Fields for Custom Pay Result Reporting
Security:
Custom Field Management
domain in the System functional area. When creating calculated fields for custom reports, you can use the
Payroll Result
business object and the Lookup Field with Prompts
function to
return:- Deductions.
- Earnings.
- Pay accumulations.
- Pay component groups.
- Pay component-related calculations.
This combination enables you to create an unlimited number of custom report
fields.
- Access theCreate Calculated Fieldtask.
- SelectPayroll Resultfrom theBusiness Objectprompt.The business object associated with a calculated field controls the availability of fields.
- SelectLookup Field with Promptsfrom theFunctionprompt.
- On theCalculationtab, select aSource Fieldfrom the prompt:
- Payroll Result Amount for Pay Components: Select to build the calculated field on a specific pay component. Example:Base PayorBonus.
- Payroll Result Amount for Pay Component Group: Select to build the calculated field on a specific pay component group.
- Payroll Result Balances Amount for Pay Components: Select to build the calculated field on a specific pay component over a period. Example:YTD - Current Fiscal Year.
- Select aValuefor each prompt field.Workday returns results on the calculated field that uses your specified prompt values.
- (Optional) On theAdditional Infotab, select aCategoryfrom the prompt to help you find the appropriate field to use when creating a report.
To include bonuses for the current payroll period in a report, you can create a
custom calculated field on a specific pay component over a period. Select
Payroll
Result Balances Amount for Pay Components
as your Source
Field
.Select
Bonus
for your Payroll Components
and Current
Period
for your Balance Period
.
Prompt Field | Value |
|---|---|
Payroll Components
| Example: Bonus
|
Balance Period
| Example: Current Period
|
Add your calculated fields to custom reports using the
Create Custom
Report
task.You can copy a standard report, such as the
Pay Calculation Results for
Group of Workers
report, and customize it by adding your custom
calculated fields.