Prorate Paid Holiday #

Time Rule Overview#

This time rule will offset or prorate the holiday paid (HP) hours if an employee books time off on a scheduled work day before or after the holiday paid.

How it Works#

Full Time Employees will have their Holiday Hours generated, as per the Holiday Calendar attached to their Work Rule on their timesheet. Time will be pre-generated and will not be manually changed. If the employee or supervisor enters LWOP in full or part, on a scheduled day before or after the holiday, the holiday hours to be paid will be recalculated by: Hours Worked / Hours Scheduled * Holiday Hours Generated = Holiday Hours

Logic#

Hours worked day before and after holiday / Hours scheduled for day before and after holiday * Holiday Hours Generated = Holiday Hours

Requirements / Features #

UEGTSSR run should not be multi threaded. For organizations with semi-monthly weekly timesheets that are multi threaded, duplicate time rules (TRs) records may be generated. This issue it will be addressed on a later point.

Additional Info #

Band: only one band is supported

Frequency predefined as Never

Implementation#

The time rule should be set up in IDWR as shown below.

Cycle	Frequency	Seq	Time Rule Type	Band	From	To	Value	Day	Time Code	Premium	Target Time Code Set	Apply Time Code Set	Action
		120	PRORATE_PAID_HOL	# of work days*	Any value**	No	Max days to look forward and back***	No	Required, should be HP time code	No	Required, should contain work time codes	Required, should contain leave time codes	No

(*) Number of work days that if they have leaves will trigger the rule to apply. If no value is provided the number of work days is 1.

(**) Is used as an indicator to create 2 flavors of this rule:

1. If there is no value defined in this column, the HP hours are offset.
   Example: If the HP is 7 hrs, then rule will generate an offset record that has 7 hrs
   The offset record is created on the next scheduled day, which could be on the next Time Sheet, or on the next Pay Period
   
2. If any value is defined in this column, the HP is calculated based on prorated formula
   Example: Scheduled & HP hours are 7 hrs, and a leave is 3 hour on the first scheduled day before HP =
   Work Hrs(11) / Scheduled Hrs(14) * HP hrs(7) = 5.5 hrs
   Since the generated HP is 7, the system will create an offset record for 1.5 hrs
   
   The offset record is created on the next scheduled day, which could be on the next Timesheet, or on the next Pay Period/.

(***) The specified number of days to look forward and back from the holiday date, searching for scheduled work day. If no value is provided, the number of work days is 4.

---

Notes #

Click to create a new notes page