Benefits Double Dipping Report on Dependents

Summary

2 reports (Dependent under Multiple employees, and employees as dependents of others)

Content

Dependents Under Multiple Employees:

Summary:
Dependents having more than one active / current enrollments for a single plan and option.

Details of each condition
Filter to identify Active enrollment.
    ("- Enrollment Results"."Participant Enrollment Result Status" IS NULL)  And Ended Coverage Through Date is equal to / is in 12/31/4712
Filter to identify Dependents records only.
    Dependent Display Name is not null
Filter to identify dependents with more than one enrollment per plan per option
    SUM(# of Enrollments BY Dependent Display Name, Plan Name, Option Name) is greater than 1

Employees As Dependents