Generate Holiday hours based on hours worked ranges
Hi everyone,
I'm looking for a way to generate holiday hours based on hours worked ranges. This is for our hourly employees. Currently employees do this manually and it is in correct, or they forget to do it. We want to generate the holiday hours based on total hours worked in the pay period:
30 to < 36 hours worked in the pay period = 3 hours holiday
36 to < 45 hours worked = 4 hours
45 to < 54 hours worked = 5 hours
54 to < 63 hours = 6 hours
63 to < 72 hours = 7 hours
72+ hours = 8 hours
I've looked at documentation for Time card Templates, for the overtime generator P186401, this user group and the support site. I can't quite figure out how to do this with ranges of hours worked. I tested setting up a PDBA benefit, used a calculation table with the hours worked ranges, used regular hours pay type in the basis of calc, and it does work. I'm not sure if that is the best option as we would only want the DBA to apply during the pay periods that contain a holiday. I could add the PDBA to DBA instructions and have