ESBD_540156_1784577532774_Exhibit A-1 Census.xlsx

This is a census data exhibit for a Stop Loss Insurance RFP filed by Central Health, a Texas-based organization headquartered at 1400 N IH 35 in Austin, TX 78701 (Tax ID: 20-1317514). The document provides detailed employee enrollment information across multiple medical benefit plans effective January 1, 2027, for an eligible population of 2,000 lives. The census data is organized by plan type—Medical ACO Seton (Full-Time and Part-Time), HDHP HSA, and TMN EPO—and further segmented by salary bands (70K+ and Below 70K) and coverage types (Team Member Only, Team Member + Spouse, Team Member + Child(ren), and Team Member + Family). The spreadsheet tracks 316 individual employee records with comprehensive demographic information including age, gender, state, zip code, employment status (Active, Retired, On Leave), hire dates, and dependent counts.

The census data reflects employee benefit elections as of January 1, 2026, with coverage effective dates through December 31, 2099, though some records indicate mid-year changes in coverage. The majority of the workforce is located in the Austin, Texas area, with employees distributed across various zip codes in Travis and surrounding counties. The data demonstrates significant enrollment across all three medical plan options, with the ACO Seton plan showing the highest participation rate, followed by HDHP HSA and TMN EPO plans. The dependent structure varies widely across the population, with coverage ranging from individual team members to families with up to seven dependents, indicating diverse healthcare needs within the Central Health employee population that will inform stop loss insurance requirements and premium calculations.