My Oracle Support Banner

Identification Of Earliest Continuous Employment Date For Employees Experiencing A Global Transfer (Doc ID 2227016.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

Oracle Fusion Benefits - Version and later
Oracle Fusion Benefits Cloud Service - Version and later
Information in this document applies to any platform.


Identification of earliest continuous employment date for employees experiencing a global transfer

Customer has broad population of employees who undergo global transfers periodically. The dates associated with a waiting period in benefits use the hire date of the most recent legal employer. Is there a particular DBI that would allow us to return the date of the earliest period of employment for someone who has multiple continuous periods of employment? For example:

XXX Hire Date: 1-Jan-2015
YYY Transfer Date: 1-Jun-2015
Termination Date: 30-Sep-2015
XXX Rehire Date: 1-Jan-2016
ZZZ Transfer Date: 30-Sep-2016
XXX Transfer Date: 1-Jan-2017

In this example, we  have two continuous periods of service:

1-Jan-2015 - 30-Sep-2015
1-Jan-2016 - Present

When an employee experiences a global transfer, we have to process a life event to pick up the correct rates for that legal employer. However, using the delivered dates, it keeps resetting the waiting period. For the 1-Jan-2017 date, how can we base the waiting period on the 1-Jan-2016 date, which is the beginning of the current continuous period of employment?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.