Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-03-08
Example: Calculate Location-Based Overtime

Example: Calculate Location-Based Overtime

This example illustrates how to combine calculated fields and time calculations to support location-based overtime requirements.
Nonresidents working in XYZ State, USA are eligible for XYZ State double time. Workers in XYZ State are paid double time after 12 hours of work in a day, whether they're residents of the state or not.
Security:
  • Custom Field Management
     domain in the System functional area.
  • Set Up: Time Calculations
     domain in the Time Tracking Calculations functional area.
  1. Access the
    Create Calculated Field
     task to create calculated fields that build on each other. You'll use the final calculated field in this step in the time block conditional calculation.
    1. Create a calculated field that returns a worker's default state.
      Field
      Value
      Field Name
      Worker's Default State for a Time Block
      Business Object
      Time Block
      Function
      Lookup Related Value
    2. Click
      OK
      .
    3. In the
      Calculation
       tab, specify these values:
      Field
      Value
      Lookup Field
      Worker
      Select the
      Worker
       option with the Time Block business object. View the related actions menu to verify the business object associated with a Worker option.
      Return Value
      Primary Address - State/Province
    4. Click
      OK
      .
    5. Click
      Create Another Calculation
      .
    6. Create a calculated field that returns a worker's default state as of the time block date.
      Field
      Value
      Field Name
      Worker's Default State for a Time Block as of Time Block Date
      Business Object
      Time Block
      Function
      Lookup Value as of Date
    7. Click
      OK
      .
    8. In the
      Calculation
       tab, specify these values:
      Field
      Value
      Source Field
      Worker's Default State for a Time Block
      Effective Date
      Calculated Date
    9. Click
      OK
      .
    10. Click
      Create Another Calculation
      .
    11. Create a calculated field that returns the state for the time block if a worker overrides the default state for the time block.
      Field
      Value
      Field Name
      Override State for a Time Block
      Business Object
      Time Block
      Function
      Lookup Related Value
    12. Click
      OK
      .
    13. In the
      Calculation
       tab, specify these values:
      Field
      Value
      Lookup Field
      Location
      Return Value
      Primary Address - State/Province
    14. Click
      OK
      .
    15. Click
      Create Another Calculation
      .
    16. Create a calculated field that returns true if a worker's default location is in XYZ State or if a worker specifies the location for the time block as XYZ State.
      Field
      Value
      Field Name
      Time Block Worked in XYZ State
      Business Object
      Time Block
      Function
      True/False Condition
    17. Click
      OK
      .
    18. In the
      Calculation
       tab, create the true/false condition. Add these rows to the grid:
      And/Or
      (
      Field
      Operator
      Comparison Type
      Comparison Value
      )
      And
      (
      Override State for a Time Block
      is blank
      And
      Worker's Default State for a Time Block as of Time Block Date
      equal to
      Value specified in this filter
      XYZ State
      )
      Or
      Override State for a Time Block
      equal to
      Value specified in this filter
      XYZ State
    19. Click
      OK
       and
      Done
      .
  2. Create a time block conditional calculation using the calculated field
    Time Block Worked in XYZ State
     that you defined in the previous step. This calculation tags all time blocks worked in XYZ State with an
    XYZ State
     calculation tag.
    1. Access the
      Create Time Calculation
       task.
    2. In the
      Name
       field, enter
      XYZ State Time
      .
    3. From the
      Calculation Type
       prompt, select
      Time Block Conditional Calculation
      .
    4. Click
      OK
      .
    5. In the
      Criteria
       section, from the
      Time Block Conditions
       prompt, select
      Time Block Worked in XYZ State
      .
    6. In the
      Results
       section, from the
      Add Tags
       prompt, create an
      XYZ State
       time calculation tag.
    7. In the
      Groups
       tab, specify time calculation groups so that all workers are eligible for this calculation, not just XYZ State residents. Add a row to the grid with these values:
      Field
      Value
      Time Calculation Group
      USA - Overtime Calculations
      Effective Date
      Current Snapshot
    8. Click
      OK
      .
  3. Access the
    Maintain Time Calculation Priorities
     task, and assign this calculation a priority of 080.
  4. Click
    OK
     and
    Done
    .
  5. Create an overtime calculation that calculates double time if a worker works more than 12 hours in a day, for both XYZ State residents and nonresidents who worked in XYZ State.
    1. Access the
      Create Time Calculation
       task.
    2. In the
      Name
       field, enter
      XYZ State Double Time
      .
    3. From the
      Calculation Type
       prompt, select
      Standard Overtime Calculation
      .
    4. Click
      OK
      .
    5. In the
      General Options
       tab, specify the
      Criteria
      :
      Field
      Value
      Period
      Daily
      Replace Hours Greater than (value)
      12
      Time Calculation Tags
      XYZ State
    6. Specify the
      Results
      :
      Field
      Value
      Add Tags
      Double Time
      Remove Tags
      Regular
      Time Day Based On
      Calculated Date
    7. In the
      Groups
       tab, specify time calculation groups so that all workers are eligible for this calculation, not just XYZ State residents. Add a row to the grid with these values:
      Field
      Value
      Time Calculation Group
      USA - Overtime Calculations
      Effective Date
      Current Snapshot
    8. Click
      OK
      .
  6. Access the
    Maintain Time Calculation Priorities
     task to assign this calculation priority 085 so that it executes after the time block conditional calculation.
  7. Click
    OK
     and
    Done
    .
When nonresidents work in XYZ State, they must specify which time blocks they worked in XYZ State so that Workday includes the time blocks in the double time calculations.