Show Messages for Time Entries on Public Holidays

The WFM_TER_COMPARE_WRKR_HOLIDAY_TO_REPORTED_HOURS_AP formula, which use array processing, is associated with the delivered Holiday Reported Hours Template rule template.

The fast formula compares the person's assigned public holidays to the reported time entries for the day that the time category identified. If the reported time is on a public holiday, the defined message appears. If no message is defined, the default message appears. The message severity is an output value associated with the displayed message.

Parameters

Name	Data Type	Description
WORKED_TIME_CONDITION	Time category	Time category that identifies the reported time entries to compare with the public holiday
OVERRIDE_MESSAGE_CODE	Message	Message overriding the default one that appears if time entries matching the time category conditions are reported on the public holiday
OVRD_PUBLIC_HOLIDAY_CATEGORY	Fixed text	Optional holiday classification to compare with the reported time entries

Output

Name	Message Severity
OUT_MSG	Specify whether the output message is informational, warning, or error

Function

This formula compares the person's assigned public holiday defined in the lookup type PER_CAL_EVENT_CATEGORY to the reported time for the day that matches the time category conditions. If the reported time is on a public holiday, the defined message appears. If no message is defined, the default message appears.

Example

The rule compares Regular time entries for each day with the person's assigned public holidays.

Day	Payroll Time Type	Reported Time	Output
1	Regular	8a to 5p	None
2	Regular	8a to 5p	None
3	Regular	8a to 5p	The rule message for the message severity appears because this day is a public holiday for the worker.
4	Regular	8a to 5p	None
5	Regular	8a to 5p	None