Benefit Costs and Elections

The Benefit Cost and Elections report shows employee benefit elections including plan option, effective dates, coverage dates, and both employee and employer per pay and annual costs.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee
Plan Sub Type
Plan Option		Ascending
Ben Plan Carrier Name
Ben Plan Type Name
Ben Plan Report Category Name
Tobacco User
Opt Eff From
Opt Eff To
Cov Start
Cov End
EE Per Pay Cost
EE Annual Cost
ER Per Pay Cost
ER Annual Cost
Age
Years of Service

Custom Fields

Years of Service

The Years of Service custom field shows the employee's years of service. It uses the following expression:

CASE WHEN Employee.HireDate < GETDATE() THEN CASE WHEN Employee.HireDate < Employee.TerminationDate THEN DATEDIFF(DAY, Employee.HireDate, Employee.TerminationDate) / 365.0 ELSE DATEDIFF(DAY, Employee.HireDate, GETDATE()) / 365.0 END ELSE NULL END

Filters

The template includes the following filters: