Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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