Get Started with Redwood for Oracle Cloud HCM Begin Now
Benefits Extracts - Dependent Termination
Summary
Benefits Extracts - Dependent TerminationContent
Hi,
We need to Fetch Dependents who are waived from Health plans(Medical,Vision, Dental) because of Divorce or any LE where Dependent is moving out of coverage but not an employee.
As system updates Coverage end date for all Benefit coverages when there is new event. In this case it's difficult to fetch dependent row with a genuine coverage end date (i.e. for Divorce event). We are using BEN_EXT_ENRT_DPNT_UE to fetch the Dependents data and using Dependent - Coverage Through Date DBI.
Is there any attribute that we can have to filter condition or any other DBI we need to look for the Actual Dep Coverage end date.
Tagged:
0