Compare Reported Time with Assigned Public Holidays

The WFM_TCR_HOLIDAY_THRESHOLD_PREMIUM_AP formula, which uses array processing, compares the reported time with a specific category of public holidays attached to the person's assigned schedule.

If the reported time is on a qualifying holiday, the person gets a holiday premium payroll time type. This fast formula isn't associated with any delivered time calculation rule templates.

Note: If the person should also receive a premium for hours worked over some defined threshold value, you need to use a separate threshold premium rule.

Parameters

Name	Type	Description
WORKED_TIME_CONDITION	Time category	Time category that identifies the time entries to compare with the public holiday category of entries associated with the person's schedule
OVRD_PUB_HOLIDAY_CATEGORY	Value set	Category of public holiday entries associated with the person's schedule to compare with the time entries identified by the specified time category

Outputs

Name	Output Group	Time Attribute	Description
OUT_MEASURE_ARY_below	1	Measure	Calculated hours that aren't on a public holiday
OUT_MEASURE_ARY_OVER	2	Measure	Calculated hours that are on a public holiday

Function

This formula gets a list of holidays for the given public holiday category and time card period. It assigns all time entries that don't match a public holiday date to the OUT_MEASURE_ARY_UNDER measure. It assigns any time entries that do match to the measure OUT_MEASURE_ARY_OVER measure.

Example

Scenario: You don't include a payroll time type for calculated hours below the threshold because you want to use those of the reported time entries. You add a payroll time type output for calculated hours over the threshold to use instead of the reported time type.

Example: You create a rule with your template where the time category is All Pay Time Types. For calculated hours over the threshold, the payroll time type is Overtime. Thursday and Friday are public holidays (PH).

Day	Payroll Time Type	Reported Time	Calculated Time
Mon	Regular	8h	8h
Tue	Regular	8h	8h
Wed	Regular	9h	8h
	Overtime	NA	1h
Thu (PH)	Regular	8h	0h
	Overtime	NA	8h
Fri (PH)	Regular	8h	0h
	Overtime	NA	8h
Sat	Regular	8h	8h