Example: Configure an Accrual Adjustment for Parental Leave
This example Illustrates how to configure a series of nested calculations for an accrual calculation value to adjust the balance for a time off plan for parental leave. This top-level arithmetic calculation (
Parental Leave Adjustment
) enables Workday to subtract the plan balance as of the prior calendar month from the parental leave upper limit as an accrual adjustment.You'll create 8 separate calculations that together feed into the final result for the top-level calculation. These calculations include 2 scheduling rules that adjust the accrual for periods in which a worker's entitlement reduces. The adjustment occurs when the worker's time off plan balance, as of the end of the prior period, is above the upper limit that they're entitled to, as of the current period start date. In these instances, the accrual awards a negative value to bring the balance down to the upper limit of the time off plan:
Example: Create an Absence Balance
Security:
Set Up: Time Off (Calculations - Absence Specific)
domain in the Time Off and Leave functional area.- Prior Period End DateCreate a calculation to determine the end date of the prior period, using a Workday-owned instance value calculation (IVC).
- Access theCreate Date Increment/Decrement Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNamePrior Period End DateCategoryAbsenceStart DatePeriod: Period Start DateDay-1
- Dependent Age at Prior Period End DateCreate a calculation to return the dependent's age at the end of the prior period, using an IVC and the result of the previous calculation.
- Access theCreate Date Difference Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Age at Prior Period End DateCategoryAbsenceIntervalYearStart DateDependent: Date of BirthEnd DatePrior Period End Date
- Dependent Age < 4 as of Prior Period End DateCreate a calculation to determine whether the dependent's age is less than 4 as of the end of the prior period, using the result of the previous calculation.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Age < 4 as of Prior Period End DateCategoryAbsence1st OperandDependent Age at Prior Period End DateOperatorless than2nd Operand4
- Dependent Age is GTE 0 and < 4 as of Prior Period EndCreate a calculation to determine whether the dependent's age is greater than or equal to zero and less than 4 as of the period end date.
- Access theCreate Logic Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Age is GTE 0 and < 4 as of Prior Period EndCategoryAbsenceOperatorANDCalculationDependent Age < 4 as of Prior Period End DateDependent Date of Birth Exists in Period or Prior Period
- CC Dependent Age < 4 as of Prior Period End DateCreate a calculation to check that the dependent's age is under 4 as of the prior period end date, using the previous calculation as a condition, and returning a result if the condition is true.
- Access theCreate Conditional Calculationtask.
- Enter or select these values:FieldValueNameCC Dependent Age < 4 as of Prior Period End DateCategoryAbsenceOrderaConditionDependent Age is GTE 0 and < 4 as of Prior Period EndResult1Default Response0
- Number of Dependents Under 4 as of Period End DateCreate a calculation to determine the number of dependents under the age of 4 as of the end of the period by aggregating the results of the previous calculation.
- Access theCreate Aggregate Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameNumber of Dependents Under 4 as of Period End DateCategoryAbsenceFunctionSumOperandCC Dependent Age < 4 as of Period End DateInstances for Operand CalculationDependents
- Number of Dependents Under 4 as of Prior Period End DateCreate a calculation to determine the number of dependents under the age of 4 as of the end of the prior period by aggregating the result of the previous calculation.
- Access theCreate Aggregate Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameNumber of Dependents Under 4 as of Prior Period End DateCategoryAbsenceFunctionSumOperandCC Dependent Age < 4 as of Prior Period End DateInstances for Operand CalculationDependents
- Number of Dependents Under 4 as of Period End Date < Prior Period ValueCreate a calculation for the scheduling rule for the accrual adjustment that checks whether the number of dependents under the age of 4 as of the period end date is less than the prior period.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameNumber of Dependents Under 4 as of Period End Date < Prior Period ValueCategoryAbsence1st OperandNumber of Dependents Under 4 as of Period End DateOperatorless than2nd OperandNumber of Dependents Under 4 as of Prior Period End Date
- Parental Leave Time Off Plan Balance as of Prior Calendar Month > Upper Limit ValueCreate another calculation for the scheduling rule for the accrual adjustment. The rule determines whether the balance of the time off plan as of the prior period is greater than the time off plan's upper limit.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameParental Leave Time Off Plan Balance as of Prior Calendar Month > Upper Limit ValueCategoryAbsence1st OperandParental Leave Time Off Plan Balance as of Prior Calendar MonthOperatorgreater than2nd OperandParental Leave Upper Limit
- Parental Leave AdjustmentYou can now create the top-level calculation for the accrualCalculationvalue using the previous calculation that ties all of the results together.
- Access theCreate Arithmetic Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameParental Leave Adjustment CalculationCategoryAbsence1st OperandParental Leave Upper LimitOperatorSubtract2nd OperandParental Leave Time Off Plan Balance as of Prior Calendar Month