The Employees with Benefit Coverage Ending report uses the Employee Benefits Coverage End topic to display a list of employees and their dependents who lost coverage during the specified date range.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Benefit Coverage End Event Date | Yes | Oldest to Newest | |
| Employee Display Name | Yes | Ascending | |
| Ben Coverage End Event Last Modified Date-Time | Oldest to Newest | ||
| Employee Name | Ascending | ||
| Ben Plan Name | Ascending | ||
| Ben Plan Option Name | Ascending | ||
| Dependent Age (yrs) | Smallest to Largest | ||
| Employee Number | |||
| Termination Date | |||
| Employee Birth Date | |||
| Ben Plan Employee Elected Option Effective Start | |||
| Ben Plan Employee Elected Option Effective End | |||
| Employee Elected Option Last Modified Date Time | |||
| Employee Elected Option Coverage Start | |||
| Employee Elected Option Coverage End | |||
| Dependent Name | |||
| Dependent Birth Date | |||
| Ben Plan Employee Dependent Elected Option Effective Start | |||
| Ben Plan Employee Dependent Election Option Effective End | |||
| Dependent Elected Option Last Modified Date Time | |||
| Dependent Elected Option Coverage Start | |||
| Dependent Elected Option Coverage End |
Custom Fields
Dependent Name
The Dependent Name field displays the dependent's name. It uses the following expression:
EmployeeDependentBeneficiary.FirstName + EmployeeDependentBeneficiary.LastName
Dependent Age (yrs)
The Dependent Age (yrs) field displays the dependent's age. It uses the following expression:
DATEDIFF(year, EmployeeDependentBeneficiary.BirthDate, GETDATE())
Filters
The template includes the following filters: