Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Create Calculated Fields for Custom Pay Result Reporting

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.
  1. Access the
    Create Calculated Field
    task.
  2. Select
    Payroll Result
    from the
    Business Object
    prompt.
    The business object associated with a calculated field controls the availability of fields.
  3. Select
    Lookup Field with Prompts
    from the
    Function
    prompt.
  4. On the
    Calculation
    tab, select a
    Source Field
    from the prompt:
    • Payroll Result Amount for Pay Components
      : Select to build the calculated field on a specific pay component. Example:
      Base Pay
      or
      Bonus
      .
    • 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
      .
  5. Select a
    Value
    for each prompt field.
    Workday returns results on the calculated field that uses your specified prompt values.
  6. (Optional) On the
    Additional Info
    tab, select a
    Category
    from 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.