Hi All,
I'm writing a process flow that populates a benefit date based on some specific rules.
The flow looks for Personnel Actions of a specific type (REHIRE) that were processed in the previous day, determine the employee's break-in-service (rehire date - term date = break in service), and then populate a Benefit Date field with either the rehire date or a calculated date depending on the break-in-service.
What I need to do is find out what the TERM-DATE was before the Personnel Action was processed so I can determine the employee's break in service.
Any suggestions on how to get this historical value? My best guess is to query the HRHISTORY table and get the TERM-DATE value for the greatest effective date before the PA - is there an easier/better way?
Thanks!