Prorate Paid Holiday #

Time Rule Overview#

This time rule will offset or prorate the holiday paid (HP) hours if the EE books time off 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 a semi-monthly weekly timesheets, multi threaded, may generate duplication of time rules(TRs) records.
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.

CycleFrequencySeqTime Rule TypeBandFromToValueDayTime CodePremiumTarget Time Code Set Apply Time Code SetAction
120 # of work days*Any value**NoMax days to look forward and back***NoRequired, should be HP time codeNoRequired, should contain work time codesRequired, should contain leave time codesNo
  • 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.
  • Frequency is used as an indicator to create two flavors of this rule:
  1. If there is no value defined in this column, the HP hours are offsetted.
    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 Time Sheet, or on the next Pay Period
The offset record is created on the next scheduled day which could be on the next times sheet even on the next PP
  • The defined the numbers of days to look forward and back form 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