This is version 1 2 3 4 5 6 7 8 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

TR_PRORATE_PAID_HOL

Prorate Paid Holiday #

Time Rule Overview#

This time rule will prorate or offset the holiday paid (HP) if a leave is found on a working day, before of after the holiday.

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.

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

• 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