You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Fetching Dependents Drops

edited Sep 5, 2020 12:10AM in Benefits 4 comments

Summary

Fetching Dependents Drops

Content

Hi,

Here is my scenario

Divorce occurred on 02/24. Dependents dropped with coverage end date as of 02/23. 

Now when i run below SQL for dependents with Effective date as of 02/26 (today) no data is being fetched. But when i fetched as of 02/23 or 02/22, 02/21 ...... dependents rows are fetched as effective date is in between covg srt date and covg end date(02/23). Our extracts run every Wednesday and I need to fetch all dependents as of effective date and dependents who dropped in the last week as well. 

Any filter /condition i can add here. Please let me know.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!