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 HoursLogic#
Hours worked day before and after holiday / Hours scheduled for day before and after holiday * Holiday Hours Generated = Holiday HoursRequirements / 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 supportedFrequency 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:
- 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
- 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.
