Example: Configure an Accrual for Parental Leave
This example illustrates how to configure a series of nested calculations for an accrual calculation value that adds to the balance for a time off plan for parental leave. This top-level arithmetic calculation (
Parental Leave Entitlement Based on Birthdays in Current Period
) enables Workday to calculate an accrual of 5 days for a worker in a period when at least 1 of their dependents has a birthday. The accrual starts from the child's date of birth, and repeats on their first, second, and third birthdays.You'll create 18 separate calculations that together feed into the final result for a top-level accrual calculation, a calculation for a scheduling rule that starts the accrual for a worker when their child is born in the current period, and an accrual where you'll add the top-level calculation and the scheduling rule:
Security:
- Set Up: Calculations - Genericdomain in the Core Payroll functional area.
- Set Up: Time OffandSet Up: Time Off (Calculations - Generic)domains in the Time Off and Leave functional area.
- Dependent Date of Birth LTE Period End DateCreate a calculation to determine whether the dependent's date of birth occurs on or before the end of the period, using the result of 2 Workday-owned IVCs as the operands.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth LTE Period End DateCategoryAbsence1st OperandDependent: Date of BirthOperatorless than or equal too2nd OperandPeriod: Period End Date
- Dependent Date of Birth GTE Period Start DateCreate a calculation to determine whether the dependent's date of birth occurs on or after the start of the period, using the result of 2 Workday-owned IVCs as the operands.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth GTE Period Start DateCategoryAbsence1st OperandDependent: Date of BirthOperatorgreater than or equal too2nd OperandPeriod: Period Start Date
- Dependent Date of Birth in Current PeriodCreate a calculation to determine whether the dependent's date of birth is in the current period using the results of the previous calculations.
- Access theCreate Logic Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth in Current PeriodCategoryAbsenceOperatorANDCalculationDependent Date of Birth GTE Period Start DateDependent Date of Birth LTE Period End Date
- Dependent Date of Birth + 1 YearCreate a calculation to determine the date of the first birthday for the dependent, using a Workday-owned IVC.
- Access theCreate Date Increment/Decrement Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 1 YearCategoryAbsenceStart DateDependent: Date of BirthYear1
- Dependent Date of Birth + 1 Year LTE Period End DateCreate a calculation to determine whether the dependent's first birthday occurs on or or before the end of the period, using the result of the previous calculation.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 1 Year LTE Period End DateCategoryAbsence1st OperandDependent Date of Birth + 1 YearOperatorless than or equal to2nd OperandPeriod: Period End Date
- Dependent Date of Birth + 1 Year GTE Period Start DateCreate a calculation to determine whether the dependent's first birthday occurs on or after the start of the period, using the result of the previous calculation.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 1 Year GTE Period Start DateCategoryAbsence1st OperandDependent Date of Birth + 1 YearOperatorgreater than or equal to2nd OperandPeriod: Period Start Date
- Dependent Date of Birth + 2 YearsCreate a calculation to determine the date of the second birthday for the dependent, using a Workday-owned IVC.
- Access theCreate Date Increment/Decrement Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 2 YearsCategoryAbsenceStart DateDependent: Date of BirthYear2
- Dependent Date of Birth + 2 Years LTE Period End DateCreate a calculation to determine whether the dependent's second birthday occurs on or before the end of the period, using the result of the previous calculation.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 2 Years LTE Period End DateCategoryAbsence1st OperandDependent Date of Birth + 2 YearsOperatorless than or equal to2nd OperandPeriod: Period End Date
- Dependent Date of Birth + 2 Years GTE Period Start DateCreate a calculation to determine whether the dependent's second birthday occurs on or after the start of the period, using the result of the previous calculation.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 2 Years GTE Period Start DateCategoryAbsence1st OperandDependent Date of Birth + 2 YearsOperatorgreater than or equal to2nd OperandPeriod: Period Start Date
- Dependent Date of Birth + 3 YearsCreate a calculation to determine the date of the third birthday for the dependent, using a Workday-owned IVC.
- Access theCreate Date Increment/Decrement Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 3 YearsCategoryAbsenceStart DateDependent: Date of BirthYear3
- Dependent Date of Birth + 3 Years LTE Period End DateCreate a calculation to determine whether the dependent's third birthday occurs on or or before the end of the period, using the result of the previous calculation.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 3 Years LTE Period End DateCategoryAbsence1st OperandDependent Date of Birth + 3 YearsOperatorless than or equal to2nd OperandPeriod: Period End Date
- Dependent Date of Birth + 3 Years GTE Period Start DateCreate a calculation to determine whether the dependent's third birthday occurs on or after the start of the period, using the result of the previous calculation.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent Date of Birth + 3 Years GTE Period Start DateCategoryAbsence1st OperandDependent Date of Birth + 3 YearsOperatorgreater than or equal to2nd OperandPeriod: Period Start Date
- Dependent 1st Birthday in Current PeriodCreate a calculation to determine whether the dependent's first birthday is in the current period.
- Access theCreate Logic Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent 1st Birthday in Current PeriodCategoryAbsenceOperatorANDCalculationDependent Date of Birth + 1 Year GTE Period Start DateDependent Date of Birth + 1 Year LTE Period End Date
- Dependent 2nd Birthday in Current PeriodCreate a calculation to determine whether the dependent's second birthday is in the current period.
- Access theCreate Logic Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent 2nd Birthday in Current PeriodCategoryAbsenceOperatorANDCalculationDependent Date of Birth + 2 Years GTE Period Start DateDependent Date of Birth + 2 Years LTE Period End Date
- Dependent 3rd Birthday in Current PeriodCreate a calculation to determine whether the dependent's third birthday is in the current period.
- Access theCreate Logic Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameDependent 3rd Birthday in Current PeriodCategoryAbsenceOperatorANDCalculationDependent Date of Birth+ 3 Years GTE Period Start DateDependent Date of Birth + 3 Years LTE Period End Date
- Dependents Born with Birthdays in Current PeriodCreate a calculation to check that the worker has dependent's who are born or have birthdays in the current period, using the previous calculations, and return a result for each condition if true.
- Access theCreate Conditional Calculationtask.
- Enter or select these values:FieldValueNameDependents Born with Birthdays in Current PeriodCategoryAbsenceDefault Response0
- Add 4 rows in theConditional Calculationsgrid:OrderConditionResultaDependent Date of Birth in Current Period1bDependent 1st Birthday in Current Period1cDependent 2nd Birthday in Current Period1dDependent 3rd Birthday in Current Period1
- ClickOKandDone.
- Number of Dependents Born in Current PeriodCreate a calculation to determine the number of dependents born in the current period using the results of the previous calculation.
- Access theCreate Aggregate Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameNumber of Dependents Born in Current PeriodCategoryAbsenceFunctionSumOperandDependents Born with Birthdays in Current PeriodInstances for Operand CalculationDependents
- Parental Leave Entitlement Based on Birthdays in Current PeriodCreate a calculation for the parental leave accrual entitlement based on birthdays in the current period. This is the top-level calculation for the accrual.
- Access theCreate Arithmetic Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameParental Leave Entitlement Based on Birthdays Current PeriodCategoryAbsence1st OperandNumber of Dependents Born in Current PeriodOperatorMultiply2nd Operand5
- Worker Has Dependent Born in Current PeriodCreate a calculation for the scheduling rule for the accrual.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values and clickOKandDone.FieldValueNameWorker Has Dependent Born in Current PeriodCategoryAbsence1st OperandNumber of Dependents Born in Current PeriodOperatorgreater than or equal to2nd Operand1
- Create an accrual for parental leave.
- Access theCreate Accrualtask.
- Enter or select these values and clickOKandDone.FieldValueNameParental Leave AccrualCodeparental_leave_accrualCalculationParental Leave Entitlement Based on Birthdays Current PeriodPriority2OptionsNone
- In theSchedulinggrid, add a row and selectWorker Has Dependent Born in Current Period
- ClickOK.