The Carrier List Bill - Vol Life and ADD Plans report uses the Carrier List Bill topic to generate a carrier list for voluntary life and AD&D plans. The EE Total Cost column in the report displays the employee rate multiplied by the volume and then multiplied by 1,000.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Carrier | Yes | Ascending | |
| Plan Option | Yes | Ascending | |
| Rate Qualifier | |||
| EE Monthly Rate | |||
| Covered Lives | Count | ||
| Volume | Sum | ||
| EE Total Cost | Sum |
Custom Fields
EE Total Cost
The EE Total Cost custom field displays the employee rate multiplied by the volume and then multiplied by 1,000. It uses the following expression:
(BenPlanEmployeeElectedOption.CoverageAmount * BenPlanOptionRateValue.EmployeeCost) / 1000
Filters
This template includes the following filters: