Example: Create a Calculation for Periods to Exclude from Statutory Holiday Pay (UK)

Administrator Guide

This example illustrates how to create a calculation to identify periods to exclude.

You want to identify weeks where an employee has either partially paid or unpaid sickness to exclude those weeks from the statutory holiday pay assessment. You want to create a nested calculation to:

Determine whether the sum is greater than zero, and return a value of 1 if it is.

Sum the total time off of absence component related calculations for partially paid and unpaid time off.

Create 2 time offs for unpaid time off and partially unpaid time off, named GBR Sickness 0% Time Off,
and GBR Sickness 50% Time Off
.

Security:

Set Up: Payroll (Calculations - Generic)
domains in the Core Payroll functional area.

Set Up: Time Off (Calculations - Generic)
domain in the Time Off and Leave functional area.

Access the

Create Aggregate Calculation

task.

Enter these values:

Option	Description
Name	SUM of GBR Sickness Time Off 50% & 0% ACRCs
Category	Payroll

Add this row to the

Calculation

section:

Function	Operand
Sum	GBR Sickness 0% Time Off - Time Off Total GBR Sickness 50% Time Off - Time Off Total

Click

Access the

Create Value Comparison Calculation

task.

Enter these values:

Option	Description
Name	Sum Sickness 50% + 0% > 0
Category	Payroll

Add this row to the

Calculation

section:

1st Operand	Operator	2nd Operand
SUM of GBR Sickness Time Off 50% & 0% ACRCs	greater than	0

Click

Access the

Create Conditional Calculation

task.

Enter these values:

Option	Description
Name	Holiday Pay Sickness Exclude Flag
Category	Payroll

Add this row to the

Calculation

section:

Condition	Result
Sum Sickness 50% + 0% > 0	1

Click

Add the calculation to an exclusion earning for holiday pay.