OTBI-Fusion Benefits (Employees who are also designated as Dependents)

Summary

This query finds any Employees who are also Dependents under another Employees enrollments.

Content

Using the Benefits - Enrollments Real Time subject area along with a Subquery we are able to identify any Dependents that are also Employees.  Useful for employers that have the scenario where they may have BOTH Employees and Dependents working at the enterprise.

1. Cut and paste XML Subquery into application

2. Cut and paste XML Report into application

3. Upon save of report you will get an error of the subquery path, click on on criteria and modify the path to the subquery. (see word doc with screenshots)