Our goal is to determine how many hours of PTO an Hourly Employee receives based on the # of years (months or days) an employee has worked (see picture below). This calc needs to be reassessed at every calc period so if an employee crosses a milestone of years employed, we begin capturing the proper hours of PTO assigned.
The logic provided below is our starting point. If there is a more efficient logic, open to ideas!
Step 1: Calc
Calc Period Start Date - Employee Hire Date = # of Months
If # Months < 24 months (or 2 years) then return 80 (hours), If not then If # Months >= 24 months then return 120 (hours). See full breakout below:
I have changed the values in the fields below, but the concept remains the same.
The content we are utilizing to build our business rule includes the following fields from the Register:
Additional PLP Global Drivers built are below. We understand yearly updates will be necessary. The purpose of having these global drivers is to assign dates to each calc period so we can compare “apples to apples” from a Calc Period vs a Hire Date.