Example: Calculate the Carryover Limit for a Time Off Plan
This example illustrates 1 way to calculate carryover-limit amounts and includes these calculations:
- Conditional
- Instance Set Comparison
Global Modern Services (GMS) wants to change their US vacation time off plan to enable workers to carryover different amounts, depending on their location. Example: When their primary work state is California, GMS wants to change the carryover limit from 80 units to 120 units. For all other states, the carryover limit will remain at 80 units.
Ben is a California employee whose carryover balance will change from 80 units to 120 units over the carryover period, based on a new effective date of 12-31-2018 for the time off plan. Jeremy works in Atlanta so his carryover limit of 80 won't change.
Create a time off plan for US vacation that tracks balances.
Security: These domains in the Time Off and Leave functional area:
- Set Up: Time Off (Calculations - Absence Specific)
- Worker Data: Time Off (Time Off Balances)
- Create calculations.
- Access theCreate Instance Set Comparison Calculationtask.
- Enter or select these values:FieldValueNamePrimary Work State = CaliforniaCategoryAbsenceandPayrollSource FieldPrimary Work State as of Period End DateRelational Operatorin the selection listTarget InstanceCalifornia
- ClickOKandDone.
- Access theCreate Conditional Calculationtask.
- Enter or select these values:FieldValueNameHourly Vacation CarryoverCategoryAbsence
- In theConditional Calculationsgrid, add a row with these values:FieldValueOrderaConditionPrimary Work State = CaliforniaResult120
- From theDefault Responseprompt, select80.
- ClickOKandDone
- Access theEdit Time Off Plantask.
- Select the time off plan. Example:USA Vacation Plan (Hourly).
- On theBalancetab, in theCarryoversection, enter these values:FieldValueDateFirst Period of Balance Period Start DateLimitHourly Vacation Carryover
- ClickOk.
The conditional calculation returns true for workers with a primary work location of California as of the period end date, and Workday enables eligible workers to carryover 120 units of time. Otherwise, workers have a carryover limit of 80. To verify the calculations and that the changes take effect:
- Access theFind Workersreport to identify workers by location.
- Select as a related action on the worker profile for workers based in California and another state such as Georgia.
- Select different balance periods on either side of the effective date to identify how many units the worker carried over each year. Select the last period of the previous year, the first and last periods of the next year, and so on. Example:
- 2017> 12/18/2017-12/31/2017 (Bi-weekly (Mon-Sun))
- 2018>01/01/2018-01/14/2018 (Bi-weekly (Mon-Sun))
- 2018>12/31/2018-01/13/2019 (Bi-weekly (Mon-Sun))
- 2019>01/14/2019-01/27/2019 (Bi-weekly (Mon-Sun))