Benefit Coverage Ending for Selected Plans

The Benefit Coverage Ending for Selected Plans report is a variation of the Employees with Benefit Coverage Ending template. It uses the Employee Benefits Coverage End topic to display a list of employees with benefit coverage ending during a specific date range, for specified plans.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Coverage End Event	Yes	Oldest to Newest
Name Number	Yes	A to Z
Plan		Ascending
Option		Ascending
Dep. Age (yrs)		Smallest to Largest
Current Status
Termination Date
Effective Start
Effective End
Last Modified
Coverage Start
Coverage End
Dependent Name
Relationship
Dep. Birth Date
Dep. Effective Start
Dep. Effective End
Dep. Last Modified
Dep. Coverage Start
Dep. Coverage End

Custom Fields

Current Status

The Current Status custom field displays the employment status. It uses the following expression:

CASE
    WHEN (EmployeeEmploymentStatus.EffectiveStart <= Getdate()
          AND (EmployeeEmploymentStatus.EffectiveEnd >= Getdate()
               OR EmployeeEmploymentStatus.EffectiveEnd IS NULL)) THEN EmploymentStatus.LongName
    ELSE 'not current status'
END

Last Modified

The Last Modified custom field displays the last modified time. It uses the following expression:

BenPlanEmployeeElectedOption.LastModifiedTimeStamp

Dependent Name

The Dependent Name custom field displays the dependent's name. It uses the following expression:

EmployeeDependentBeneficiary.FirstName + ' ' + EmployeeDependentBeneficiary.LastName

Dep. Age (yrs)

The Dep. Age (yrs) custom field displays the dependent's age. It uses the following expression:

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

Dep. Coverage Start

The Dep. Coverage Start custom field displays the dependent's coverage start date. It uses the following expression:

BenPlanEmployeeDependentElectedOption.CoverageStart

Dep. Coverage End

The Dep. Coverage End custom field displays the dependent's coverage end date. It uses the following expression:

BenPlanEmployeeDependentElectedOption.CoverageEnd

Filters

The template includes the following filters: