Get Started with Redwood for Oracle Cloud HCM Begin Now
Fetching Dependents Drops
Summary
Fetching Dependents DropsContent
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:
0