ESBD_503812_1777066702397_No BL Census.xlsx

This file is a census data spreadsheet for optional life and retiree optional life insurance benefits for the Texas A&M University System, supporting the RFP SBA-26-280 for group life and accidental death and dismemberment (AD&D) insurance claims administration services. The spreadsheet contains detailed enrollment information for approximately 1,000 active employees and 300 retirees participating in optional life insurance coverage. For active employees, the data includes date of birth, gender, active status, current salary, benefits salary, optional life rate, tobacco use status, benefit coverage type (ranging from 0.5X to 6X salary), and calculated coverage amounts. Retiree data similarly includes date of birth, gender, retiree status, tobacco use status, coverage type, and calculated benefit coverage amounts. The active employee coverage amounts range from approximately $18,000 to $1,000,000, while retiree coverage amounts range from $5,000 to $100,000, reflecting the standard benefit design under the current Hartford Life and Accident Insurance Company policies (numbers 681794G and 681835G).

The spreadsheet serves as the basis for actuarial analysis and rate recommendations required as part of the claims administration contract. This census data is critical for prospective vendors to develop accurate premium quotes and demonstrate understanding of the A&M System's current benefit obligations across its 42,285 employees and 18,066 retirees in Basic Life and AD&D coverage. The data reflects the self-bill arrangement currently in place with a 40 to 50-day premium lag due to payroll system limitations, and supports the incumbent Hartford's demonstrated combined loss ratio of 85.7% over the five-year period from September 2020 through August 2025. Vendors responding to the RFP must use this census information to calculate fully-insured pricing guaranteed for the initial three-year contract term (September 1, 2026, through August 31, 2029) with potential renewals through August 31, 2032, with proposals due May 4, 2026.