Dependent Age Out - Spouse

The Dependent Age Out - Spouse report uses the Employee Benefit Elections - As of Date topic to display employees’ covered spouse dependents who might age out of a benefit plan option. The report includes information about employees and their spouses, including the spouse’s name, age, and coverage dates.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee
EE SSN/SIN
Plan Option
Relationship
Dep Last Name
Dep First Name
Dep SSN/SIN
Dep Birth Date
Dep Age
Dep Opt Eff From
Dep Opt Eff To
Dep Cov From
Dep Cov To

Custom Fields

Dep Age

The Dep Age custom field displays the dependent’s age. It uses the following expression:

DATEDIFF(year, EmployeeDependentBeneficiary.BirthDate, 
GETDATE())

Dep Cov From

The Dep Cov From custom field displays the effective start date of the dependent’s coverage. It uses the following expression:

BenPlanEmployeeDependentElectedOption.CoverageStart

Dep Cov To

The Dep Cov To custom field displays the effective end date of the dependent’s coverage. It uses the following expression:

BenPlanEmployeeDependentElectedOption.CoverageEnd

Filters

The template includes the following filters: