ESBD_521004_1780004433000_Exhibit A-12 Census.xlsx

This is an employee benefits census file for Central Health, a Texas-based healthcare organization headquartered in Austin, containing detailed enrollment data for medical, dental, and vision insurance coverage effective January 1, 2027. The census documents 2,000 eligible lives across multiple benefit plan options, including Medical ACO Seton plans (available in both 70K+ and Below 70K salary tiers with full-time and part-time designations), Medical HDHP HSA plans, Medical TMN EPO plans, Dental PPO plans offered through Aetna in Basic and Premium tiers, and Vision plans through Aetna in Basic and Premium levels. Coverage types include Team Member Only, Team Member + Spouse, Team Member + Child(ren), and Team Member + Family configurations. The file captures individual employee records with hire dates ranging from April 1983 through February 2011, employee status designations (Active, Retired, On Leave), and coverage effective dates with most benefits running through December 31, 2099, though some show early termination dates in early 2026.

The census provides granular individual-level data including employee demographics (age, gender, zip code), salary information, dependent counts, and specific plan selections across the medical, dental, and vision product lines. Summary tables indicate total enrollment counts by plan type, with Medical ACO Seton - 70K+ FT comprising 499 lives, Medical ACO Seton - Below 70K FT at 675 lives, and total dental and vision enrollment exceeding 1,700 and 1,800 lives respectively. The data reflects a mature workforce with employees spanning multiple decades of tenure and geographic distribution across the greater Austin metropolitan area and surrounding Texas regions. This comprehensive census serves as the baseline enrollment and demographic foundation for benefit plan administration, actuarial analysis, and contract renewal or modification discussions with the involved carriers.