The Carrier List Bill - Health Plans report uses the Carrier List Bill topic to generate a carrier list for health plans. The Total column in the report displays the employer monthly rate multiplied by the total number of employees covered by each plan option.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Carrier | Yes | Ascending | |
| Plan Option | Yes | Ascending | |
| Rate Qualifier | |||
| EE Monthly Rate | |||
| ER Monthly Rate | |||
| Covered Lives | Count | ||
| Total |
Custom Fields
Total
The Total custom field displays the employer monthly rate multiplied by the total number of employees covered by each plan option. It uses the following expression:
COUNT(Employee.NameNumber) * BenPlanOptionRateValue.EmployerCost
Filters
This template includes the following filters: