Hours worked derived factor

Summary

Absence accrual calculation based on Hours worked

Content

How do we accrue absence balance based on the no. of hours worked by a worker using a repeating time period same as that of payroll and also stop a newly hired employee from accruing hours unless they work for a minimum number of hours which would span multiple periods.

Ex. Bi Weekly Payroll. Total scheduled hours is 80 hours. 

      New Hire has to work at least 220 hours to start accruing absence balance.After working 220 hours lets assume the worker would start accruing balance @ 1 hour for every 60 hours worked.Please note that it is not the scheduled hours but the actual hours worked that needs to be used for accrual calculation. And we also need to have a matrix for different groups of hourly employees.