The Family Tiered Health Option No Spouse or DP report displays a list of employees enrolled in the Employee & Family tier option without spouse or legal partner coverage.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee Name Number | Yes | A to Z | |
| Number Dependents | Sum | ||
| Count Spouse | Sum | ||
| Ben Plan Option Name |
Custom Fields
Number Dependents
The Number Dependents field shows the total number of dependents. It uses the following expression:
CASE WHEN EmployeeDependentBeneficiary.IsDependent = 1 THEN 1 ELSE 0 END
Count Spouse
The Count Spouse field shows the number of spouses. It uses the following expression:
CASE WHEN (RelationshipType.IsSpouse = 1 OR RelationshipType.IsLPShip = 1) THEN 1 ELSE 0 END
Filters
The template includes the following filters: