Wiki: TIME_SHEET_HOLIDAY

Time Sheet Holiday Processing
Overview
Holiday Definition
Determining Paid Holiday Hours
Holiday Time rules
Paid Holiday
Worked Holiday
OT Holiday
Offset Paid Holiday

Time Sheet Holiday Processing#

Overview#

The Generate Timesheets(UEGTS) program will generate timesheets and entries based on the given parameters and filters as well as employees work rules.

Holidays in time sheets are generated using similar guide lines as that of UPTG with only a few differences. With Time Sheet Holiday processing the UPTG rule of part time employee holiday hours are generated up to a maximum of the assignment hours per day can be overridden by the use of the Paid Holiday time rules. The other difference is that holiday hours can be adjusted if the holiday hours in the holiday calendar is less than one, in the case of the holiday being only a half day (i.e. Christmas Eve, New Years Eve). Holiday paid time in time sheets is generated in hours by one of two methods:

UEGTS based on the set up in the Work Calendar for projected time
Paid Holiday Time rule based on actual time worked from Time Scheduling or Event Scheduling

Holiday time is generated when all of the following conditions exist:

The day is identified on the Holiday Calendar
The 'Generate Time' toggle is ON for the day on the Holiday Calendar
The 'Add Holidays' toggle is ON for the Work Rule Status rule
A Holiday Calendar is defined on the Work Rule.

Holiday Definition#

Holidays are defined on the Holiday Calendar screen
Multiple Holiday Calendars are supported
The Work Rule identifies which Holiday Calendar will be used for a given employee

Determining Paid Holiday Hours#

The hours that are used for a paid holiday depend on the setting of the Holidays Use Schedule Hrs toggle on the Work Rules. This toggle indicates whether the Work Schedule dictates the holiday hours. If hours are specified on the Holiday Calendar, they are ALWAYS USED and this toggle is not used.

The Holidays Use Scheduled Hrs toggle only applies to the hours generated for the Holiday Time Code. It does not extend to the Worked Time Code.

If part-time and fulltime employees use different rules, they must have separate work rules

If the Holidays Use Scheduled Hrs toggle is ON, the order for determining paid holiday hours is as follows:

Use the IDHC Holiday Calendar hours per day if specified, otherwise
Use the employee’s overridden Work Calendar scheduled hours per day if specified, otherwise
Use the Work Rule’s Work Calendar scheduled hours per day if specified, otherwise
Use the employee's assignment hours per day

If the "Holidays Use Scheduled Hrs" toggle is OFF, the order for determining paid holiday hours is as follows:

Use the IDHC Holiday Calendar hours per day if specified, otherwise
Use the employee's assignment hours per day

A holiday that falls on a non scheduled day (day off) will always use the assignment hours regardless if the Holiday’s Use Scheduled Hrs toggle is ON or OFF.

If an employee is part-time (i.e. FTE < 1) and the IDHC Holiday Calendar hours per day are used, holiday hours are generated up to a maximum of the Assignment hours per day. However, this can be overridden by making use of the Paid Holiday time rule. Please refer to the Holiday Time Rule section below for more information.

Holiday hours are only used for the Holiday Paid time code; they do not affect the Worked time code. Work time is taken directly from the Work Calendar or schedule. No work time is ever generated for days off.

Holiday Time rules#

The following time rules can be used in conjunction with timesheet holiday processing:

Time rules can be quite complex or quite simple depending on each client's needs. Time rules should be thoroughly tested before they are utilized in a production environment to ensure desired results.

Paid Holiday#

This time rule is based from a time scheduling requirement where the worked time is not always predictable i.e. shift patterns
This rule will generate the paid holiday based on the actual time worked by the employee.
To identify work on the day of a holiday, the rule will use the Work Holiday time code defined in IDHC, the time code specified in the DFT Time Code time rule or the target time code set if defined
The only Observe On rule which this time rule respects is Holiday Date
A time code is allowed in the definition but should be used only when you need to override the Holiday Time Code from IDHC. If you need to use Day Off Time Code you should not define the time code at the Time Rule level
The Target Time Code Set may include the holiday Worked Time Code defined in IDHC or the one applied by Worked Holiday time rule or Default Time Code depending on each client’s particular need. If the target time code set is not defined, the Worked Time Code from IDHC or the time code from Default Time Code rule is used to identify if the employee worked on the holiday
This time rule can be used to allow the holiday paid hours to exceed the assignment hours per day for part time employees.
If the value is defined and is 1, then for part time employees who work on a holiday, the holiday time paid can exceed the hours defined at the assignment level and can be equal with work hours on a holiday.

Band	From	To	Value	Day Of Week	Time Code	Premium	Action	Target Time Code Set	Apply Time Code Set
Number	No	No	1 = Allow Exceed Assignment Hours for FTE < 1	No	Allowed	No	Add	Allowed	No

Worked Holiday#

This time rule will apply a holiday time code if the employee worked on the holiday

This is used when the time entries are generated from UTTP, UPAUTOFILL, or from Self Service where the employees are entering their time entries. These processes will not recognize when a holiday has fallen in the pay period, as a result this time rule is used to recognize when there is a holiday in the time period and to replace the regular work time code with the Holiday Work time code.

This time rule can be used to apply a holiday work time code to a portion of a shift when the shift crosses over midnight. This is done by specifying in IDHC the Holiday Rule - Partial Shifts Apply.

This time rule will also respect the Start Time in IDHC if specified. If a Start Time has been specified, the Holiday Work time code will be invoked at that time.

The time rule should be set up in IDWR as shown below. See Time Rule Improvements for additional information regarding IDWR.

Band	From	To	Value	Day Of Week	Time Code	Premium	Action	Target Time Code Set	Apply Time Code Set
Zero	No	No	No	No	Allowed	No	Replace	Allowed	Allowed

OT Holiday#

This time rule will apply overtime to a worked holiday

Applies overtime commencing with the holiday Start Time if defined in IDHC, otherwise OT will commence when the shift starts.

This rule cannot be used for partial shifts. If clients with partial shifts require OT to be applied to a holiday they need to set up the Worked Holiday time rule as well as the OT Daily time rule. They need to ensure the holiday worked time code is in the target time code set of the OT Daily rule.