We have a reporting requirement with a new benefit vendor where we have to tell them an adjusted service date for vesting calculations. The way this is calculated is to take the most recent hire date, and subtract from it the previous length of service for rehires. This will then be the date that their vesting is based off of.
For example, an employee was hired on 10/5/2008 and left the company on 10/5/2010. The employee then came back on 10/5/2013. Because the employee already had 2 years of service, the date used for vesting is 10/5/2011.
We are trying to add this to reports that we send the vendor which are written using Business Objects Web Intelligence.
Has anyone done something like this before and either calculated it in batch and loaded to user fields or done a SQL calculation on the fly? I would appreciate any feedback anyone has.
(I did check the PA10.1 length of service, but it just does a simple calculation of the as of date (usually today) minus the hire date or the adjusted hire date. it ignores any lapses in service)
