Handling Overtime Compensation

Objective

After completing this lesson, you will be able to handle overtime compensations.

Overtime Compensation with Time off in Lieu

Some companies choose time off in lieu of overtime compensation for employees who work extra time with an entitlement of paid leave in addition to the regular leave that employees are entitled regularly or annually. This type of compensation is a common compensation method in the U.S. where companies compensate employees for time worked in excess of their regular working time.

There are nine configuration steps to support Overtime Compensation with Time off in Lieu.

Flowchart outlining steps to implement Time Off in Lieu, including creating time account types, assigning profiles, and activating compensation variants.

Step 1: Create Time Account Type for Time off in Lieu (Time Off)

Creating a Time Account Type for Time in Lieu Of with details like external name, payout eligibility set to Not Eligible, and account creation type as Permanent.

To create a new time account type, follow these steps:

  1. Go to Manage Data and then create a time account type.

  2. Specify a unique External Name and External Code for the time account type.

  3. Set the Payout Eligibility to Not Eligible.

  4. Select Unit with Hours.

  5. Select Account Creation Type as Permanent.

Step 2: Create Time off in Lieu Time Accounts for Employees (Time Off)

New calendar creation screen titled TOIL NEW, with start date 01/01/2017, end date 12/31/2017, and time account type Time in Lieu Of.

After creating the new time account type for TOIL, create a new Time off in Lieu time accounts for all employees who are eligible for TOIL. In Time Off, go to the Manage Time Off CalendarsAccount CreationNew Calendar, and select Change Scenario with Account Creation and Account TypeTime Off in Lieu (TOIL).

Manage Time Off Calendars screen showing TOIL NEW calendar, valid from 01/01/2017 to 12/31/2017, with status Ready to Run and an option to Run.

Then select the new created job to Run.

Step 3: Create Time Types for Time off in Lieu

Time Type: Time in Lieu Of with external name Time in Lieu Of, unit Hour(s), and time account posting rule linked to Time in Lieu Of (TOIL_TAT).

To create a new time type, follow these steps:

  1. Go to Manage Data and then create the time type.

  2. Specify a unique External Name and External Code for the time type.

  3. Select Unit with Hours.

  4. Assign the new time account type created in step 1 under Time Account Type.

Step 4: Assign Time off in Lieu in Employee Time Profiles

Time Profile (TP_normal) showing Time Account Type for Time Off in Lieu as Time in Lieu Of (TOIL_TAT) and availability of Time in Lieu Of (TOIL_TT) in the time type list.

To change a time profile, follow these steps:

  1. Go to Manage DataTake ActionMake Correction, and then create a time type.

  2. Assign the new time account type created in step 1 under Time Account Type for Time Off in Lieu.

  3. Add the time type for Time Off in Lieu created in Step 3: Create Time Types for Time off in Lieu, in the Available Time Type section of the time profile.

Step 5: Create Time Type Groups for Overtime Compensation

To create the overtime and premium time type groups required to support the valuation of employee overtime compensation, follow these steps:

  1. Go to Manage Data, and then create a time type group.

  2. Assign Valuation Result Category as either Overtime Base or Overtime Premium.

    Note

    This field is required if you want to convert time valuation results for calculated overtime to time off in lieu overtime compensation. The Valuation Result Category field determines if the time type group holds overtime base or overtime premium. There's no conversion of calculated overtime to time off in lieu by the system is maintained and all overtime time valuation results are paid out to the employee.

  3. Assign a value to Valuation Result Factor.

    Note

    In this field, specify the factor used to convert time valuation results for calculated overtime to hours of time off in lieu, entering a positive value above zero and a basic hourly rate, requiring a 1:1 conversion.

Here are examples of the overtime and premium time type groups.

Time Type Group: OT Base with the valuation result category set to Overtime Base and time pay type as Yes.
Time Type Group: Overtime Premium 50% with the valuation result category set to Overtime Premium and a valuation result factor of 0.5.

Step 6: Create Time Valuations for Overtime Compensation

The time valuation rules are required for deriving time valuation results for all required components of overtime compensation, including all base pay and premium components that are applied to an employee's overtime.

Time Valuation: DUR-Pos & Neg OT TOIL - Get OT Base with valuation type Aggregate Input Groups and Splits and Time Type Group Above as OT Base (OTBase).

Create these time valuations as shown in the preceding figure and assign the time type groups created in the step 5 in these new time valuations.

Step 7: Create Time Recording Profiles for Overtime Compensation

Time Recording Profile: DUR-Positive Reg, OT, OT Premiums, TOIL highlighting DUR-Pos & Neg OT TOIL - Get OT Base in the time valuation section.

Create new time recording profiles and assign the time valuations for overtime compensation you created in Step 6 to these new time recording profiles.

Step 8: Activate Default Overtime Compensation Variant on Job Information

You must change role-based permission settings to grant users assigned to the Employee Self Service, Manager, and HR Role roles view or maintenance permissions for the Default Overtime Compensation Variant field within the Time Information section of the employee Job Information. Then, activate the Default Overtime Compensation Variant field within the employee Job Information. For detailed information, refer to the Configuring and Setting Up Time Sheets unit.

There are three options for Default Overtime Compensation Variant:

  • Payout: All time type groups of Valuation Result Category in either Overtime Base or Overtime Premium are converted into time pay types and are paid out through payroll to the employee.

  • Payout and Time Off: The time type groups of Valuation Result Category in Overtime Base are converted into time pay types and paid out. The time type groups of Valuation Result Category in Overtime Premium are converted to time off in lieu of overtime pay and posted to employees’ time off in lieu time account.

  • Time Off: All time type groups of Valuation Result Category in either Overtime Base or Overtime Premium are converted to time off in lieu of overtime pay and posted to employees’ time off in lieu time account.

Step 9: Maintain Relevant Fields for Employees Who are Eligible for Overtime Compensation with Time off in Lieu

For employees who are eligible for overtime compensation with Time Off in Lieu, update each employee’s Job Information by assigning time profile, time recording profile created in previous steps, and by maintaining the Default Overtime Compensation Variant.

Employees for whom the Default Compensation Variant are assigned with a Payout and Time Off or Time Off, can view Time off in lieu information through Time Sheet and Time Off.

Submit Time Sheet screen showing total hours for the week with a message indicating that 1:38 hours will be credited to the Time Off in Lieu account.

When employees submit their time sheet, the standard submission pop-up screen shows the number of hours of overtime for that time sheet week that is posted to their time off in lieu time account.

Time Information screen for Ian Grant showing Time in Lieu Of with 0:30 hours available, account type as Permanent Account, and account history by year.

In Manage Time Off, a time administrator has access to detailed information on time off in lieu time account postings.

Working Time Accounts

Working time accounts are used to record variations from an employee's standard working time and calculate the balance of time that employee worked in excess or short of the schedule time by comparing employee’s record working time with their work schedule. The balance of working time account is used to offset any difference when the employee works less than schedule hours.

Working Time Accounts: Example

An employee who works five days and eight hours per day, worked a total of 49.45 hours in the first week resulting in 9.5 hours being posted to the working time account.

Digital time sheet for Selma Miller, May 9-15, 2021. Planned: 40 hours, Recorded: 49 hours 45 minutes. Status: To be Submitted. May 14 details: 8 AM-5 PM, break 12-1 PM.

In the second week, Selma Miller recorded four hours of Minus Hours absence, taking four hours out from the working time account balance.

Sections: working times, on-call times, allowances, with no on-call times recorded.

The absence record in Time Off is shown in the preceding figure.

Selma also worked a total of 36 hours in the week. As a result, she was paid four hours of absence and 36 hours for the week.

The Time Collectors section is present, but contains no entries. Tabs include Days, Summary, Time Sheet Accounts, and Time Collectors.

In summary area, it shows 36 hours of regular pay, four hours of absence, and 5.45 hours as a working time account balance.

Configure Working Time Accounts

Steps

  1. Create a time account type that you can use to post data to a working time account. This time account type can't be a time account type you already use for time off in lieu (TOIL).

    Manage Data interface for Working Time Balance (WTDIFF).
  2. Create one or more time types that you want to use to post data to a working time account. The data is composed of the differences calculated as time valuation results for one or more Time Type Groups with the category Calculated Time. Employees can then use this time type to enter absence requests in Employee Central Time Off to deduct time from the balances on the working time account.

    Highlighted section shows Time Account Posting Rules with Working Time Balance (WTDIFF) selected.
  3. Create a Working Time Difference time type group that is used to store the calculated balance in a time sheet valuation. The instruction for the creation is described earlier under Define Time Type Groups.

    Time Type Group interface for Working Time Difference (WT_DIFF).
  4. Create a Paid Absence time type group that includes the absence time type deducting from working time account.

    The highlighted section in the image shows the Minus Hours (WTDIFF) time type within the Paid Absences group.
  5. Create time valuation by using the Valuation Type, Difference Between Threshold, that includes working time, overtime, paid holidays, and paid absence time type groups.

    Time Valuation configuration titled DUR - Pos & Neg - Get Working Time Difference (DUR-PN-WT_DIFF). Fields include external name, valuation type (difference between thresholds), threshold group (scheduled working time), and valuation method (value up to today).

    It's possible to schedule an automated periodic update of time accounts to process working time accounts automatically or time off in lieu accounts at the end of a configurable period. The update then carries out a specific predefined action without you having to do it manually. That way, at the end of the period, a time off in lieu account or working time account balance gets automatically capped.

    Selected time account type is Working Time Account (Flexitime) with a date of Feb 4, 2020.

    Managers or administrators can use the Review Periodic Time Account Updates page to check on balances for all employees for whom the periodic update has been performed. If necessary, they can also make corrections. For example, they can update the employee's timesheet or report an unpaid absence to trigger a salary recalculation.

Create New Work Schedule and Time Type Groups

Steps

  1. Create a Day Model.

    Times

    External Name8:00-5:00 8 Hour Day
    Time Recording VariantClock Times
    Planned Hours8
    Planned Hours and Minutes08:00
    External Code8-5_8_HOUR_DAY

    Segments

    Start TimeEnd TimeCategory
    08:00 AM05:00 PMScheduled Working Time
    12:00 PM0Scheduled Unpaid Break
    1. Navigate to Manage Time Off Structures.

    2. Create a new Work Schedule Day Model based on the tables.

  2. Create a Work Schedule.

    Work Schedule Details

    Is Individual Work Schedule?No
    ModelPeriod
    Time Recording VariantClock Times
    External Code8-5_CLOCK
    External Name8:00-5:00 5 Day Work Week
    Starting Date01/02/2017

    Work Schedule Days for Period Model

    DayCategoryDay Model
    1Day Model8:00-5:00 8 Hour Day (8-5_8_HOUR_DAY)
    2Day Model8:00-5:00 8 Hour Day (8-5_8_HOUR_DAY)
    3Day Model8:00-5:00 8 Hour Day (8-5_8_HOUR_DAY)
    4Day Model8:00-5:00 8 Hour Day (8-5_8_HOUR_DAY)
    5Day Model8:00-5:00 8 Hour Day (8-5_8_HOUR_DAY)
    6Non-Working Day 
    7Non-Working Day 
    1. Navigate to Manage Time Off Structures.

    2. Create a new Work Schedule based on the tables.

  3. Create Time Type Groups.

    Working Time Type Group

    External NameRecorded Work
    Time CategoryWorking Time
    Time Pay TypeNo
    UI ComponentNo
    Valuation Result Category–No Selection–
    Time Collector TypeNo
    External CodeREC_WORK
    Time TypeWorking Time
    Administrative Tasks
    Overtime

    On Call Time Type Group

    External NameOn Call
    Time CategoryOn-Call Time
    Time Pay TypeNo
    UI ComponentNo
    Valuation Result Category–No Selection–
    Time Collector TypeNo
    External CodeON_CALL
    Time TypeOn Call Duty

    Time Off Time Type Group

    External NamePaid Absence
    Time CategoryPaid Absences
    Time Pay TypeNo
    UI ComponentNo
    Valuation Result Category–No Selection–
    Time Collector TypeNo
    External CodePAIDAB
    Time TypeJury Duty U.S
    Vacation
    Sick Leave
    1. Navigate to Manage Data.

    2. Create a new Time Type Group and create new records based on the tables.

Create a Time Valuation: Scenario 1

In this exercise, you'll create a Time Valuation to raise an error message when employees try to add more than 12 working hours a day on their Timesheet.

Steps

  1. Create a Calculated Time Type Group for Threshold Above.

    External NameTTG Over 12 per Day
    Time CategoryCalculated Time
    Time Pay TypeNo
    UI ComponentNo
    Valuation Result CategoryNo Selection
    Time Collector TypeNo
    External CodeTTG_O12

    Note

    You can't add Time Types to Time Type Groups with the Category: Calculated Time.

    1. Navigate to Manage Data.

    2. Create a new Time Type Group and then create a new record based on the preceding table.

  2. Create a Time Valuation for the error.

    Time Valuation

    External NameError More than 12 Working Hours
    Valuation TypeAggregate Input Groups and Split
    Message TextYou Cannot record more than 12 working hours per day
    Message TypeError
    Time Type Group AboveTTG Over 12 per Day
    Valuation MethodValuate Per Day
    Threshold TypeFixed Value
    Threshold Value12
    Message FlagRaise Message on Time Type Group Above
    External CodeError_Over_12

    Input Time Type Group

    Time Type GroupReverse SignFactorExternal Code
    Recorded WorkNo 1
    1. Navigate to Manage Data.

    2. Create a new Time Valuation and then create a new record based on the preceding two tables.

Create a Time Valuation: Scenario 2

In this exercise, you'll create a Time Valuation to raise an error message when employees try to add more than 60 working hours a week on their Timesheet.

Steps

  1. Create a Calculated Time Type Group for Threshold Above.

    External NameWeekly Hour Cap
    Time CategoryCalculated Time
    Time Pay TypeNo
    UI ComponentNo
    Valuation Result CategoryNo Selection
    Time Collector TypeNo
    External CodeWEEK_TIME_CAP
    1. Navigate to Manage Data.

    2. Create a new Time Type Group and then create a new record based on the preceding table.

  2. Create a Time Valuation for your Error.

    External NameError Over 60 Hour Work Week
    Valuation TypeAggregate Input Groups and Split
    Message TextYou cannot record more than 60 working hours per week
    Message TypeError
    Time Type Group AboveWeekly Hour Cap
    Valuation MethodValuate Whole Sheet or Period
    Threshold TypeFixed Value
    Threshold Value60
    Message FlagRaise Message on Time Type Group Above
    External CodeERROR_OVER_60

    Input Time Type Group

    Time Type GroupReverse SignFactorExternal Code
    Recorded WorkNo 1
    Paid AbsenceNo 2
    1. Navigate to Manage Data.

    2. Create a new Time Valuation and create a new record based on the preceding two tables.

Create a Time Valuation: Scenario 3

In this exercise, you'll create a Time Valuation to raise an error message when employees attempt to add more than two On Call times per week.

Steps

  1. Create a Counted Events Time Type Group for holding the count of On Call Events.

    External NameOn Call Counter
    Time CategoryCounted Events
    Time Pay TypeNo
    UI ComponentNo
    Valuation Result CategoryNo Selection
    Time Collector TypeNo
    External CodeON_CALL_COUNT
    1. Navigate to Manage Data.

    2. Create a new Time Type Group and then create a new record based on the preceding table.

  2. Create a Time Valuation to compare On Call Counter to a Threshold.

    External NameOn Call Count
    Valuation TypeCompare Threshold with Input Groups and Count Events
    Time Type Group AboveOn Call Counter
    Valuation MethodValuate Per Day
    Threshold TypeFixed Value
    Threshold Value0
    Message FlagDon't Raise Message
    External CodeON_CALL_COUNT_VAL

    Input Time Type Group

    Time Type GroupReverse SignFactorExternal Code
    On CallNo 1
    1. Navigate to Manage Data.

    2. Create a new Time Valuation and then create a new record based on the data given in the above table.

  3. Create a Counted Events Time Type Group for hold the count of On Call Events for the entire time sheet.

    External NameWeekly On Call Count
    Time CategoryCounted Events
    Time Pay TypeNo
    UI ComponentNo
    Valuation Result CategoryNo Selection
    Time Collector TypeNo
    External CodeWEEKLY_ON_CALL_COUNT
    1. Navigate to Manage Data.

    2. Create a new Time Type Group and then create a new record based on the preceding table.

  4. Create a Time Valuation to error when adding more than two On Call events in a week.

    External NameError More than 2 On Calls per Week
    Valuation TypeAggregate Input Groups and Split
    Time Type Group AboveWeekly On Call Count
    Valuation MethodValuate Whole Sheet or Period
    Threshold TypeFixed Value
    Threshold Value2
    Message FlagRaise Message on Time Type Group Above
    Message TextYou cannot add more than 2 On Call times per week
    Message TypeError
    External CodeON_CALL_WEEKLY_CAP

    Input Time Type Group

    Time Type GroupReverse SignFactorExternal Code
    On Call CounterNo 1
    1. Navigate to Manage Data.

    2. Create a new Time Valuation and then create a new record based on the preceding two tables.

Add Time Valuations to a Time Recording Profile

Steps

  1. Add the following Time Valuations to Default Time Recording Profile (DEF_TIME_REC).

    • Error More than 12 Working Hours (ERROR_OVER_12)

    • Error Over 60 Hour Work Week (ERROR_OVER_60)

    • Error More than 2 On Calls Per Week (ON_CALL_WEEKLY_CAP)

    • On Call Count (ON_CALL_COUNT_VAL)

    1. Navigate to Manage Data.

    2. Search: Time Recording ProfileDefault Time Recording (DEF_TIME_REC).

    3. Choose Take ActionMake Correction.

    4. Add the Time Valuations given above to the selected time recording profile.

Assign Time Pieces to Employee

Steps

  1. Assign Time Information to Penny Welsh.

    1. Search for Penny Welsh and select to Time Management category.

    2. Select Edit icon on the Time Information card.

    3. Select JJanuary 1, 2025, as the date the changes take effect.

    4. Set the following values, in the Time Information section of the Job Information.

      • Work Schedule: 8:00-5:00 5 Day Work Week (8-5_CLOCK)

      • Time Profile: Default Profile (DEFAULT_PROF)

      • Holiday Calendar Code: US Holidays (HOLIDAY_US)

      • Time Recording Profile: Default Time Recording (DEF_TIME_REC)

      • Time Recording Variant: Clock Times

      • Time Recording Admissibility: 4 Week Rolling Period (4WEEKROLL)

      • Default Overtime Compensation: Payout

    5. Choose Save.

      Note

      A workflow is triggered to all users of the dynamic group Talent Approval.

      Proxy in as Alex Anderson (a member of the group). In the Home Page, under the Approvals section, locate the approval request for Data Change for Penny Welsh and then choose Approve. Then choose Become Self to return to your login user home page.

  2. Confirm Role Based Permissions.

    1. Navigate to Manage Permission Roles.

    2. Select System Admin.

    3. Navigate to Time Management Permissions in the Permissions section and ensure that the box next to Time Sheet is checked.

    4. Check all boxes in the Manage Time and Manage Time Off sections.

    5. Save your role and log out and log back in again to see your changes.

  3. Explore the Time Sheet.

    1. Navigate to Penny Welsh’s profile and view the Time Off section.

      Note

      This information is typically found at the bottom of the profile, but can be moved up by using the Configure People Profile tool.

    2. Select Go To Time Sheet.

    3. Experiment with entering time worked, recording on call or overtime hours, and marking absences. Try to trigger your new Time Valuation Errors to test if all errors appear as expected.