7-Exhibit B - Medical Census Report 08-27-2025.xlsx

The provided document is a Medical Census Report for an employee benefits insurance program, specifically detailing health insurance enrollment for a large organization across multiple job classifications. The spreadsheet contains comprehensive enrollment data for employees, including unique identifiers, demographics (gender, date of birth, zip code), job classifications (Professional, Paraprofessional, Auxiliary), and health insurance plan details from Aetna, including Baptist ACO Plan 3, High Deductible Health Plan (HDHP) Plan 1, and Point of Service (POS) Plan 2. The document includes multiple coverage tiers (EO, EC, ES, FA) and provides a granular view of the organization's health insurance enrollment.

While the spreadsheet itself does not contain explicit pricing or contract terms, it reveals a structured approach to employee health benefits with multiple plan options tailored to different job classifications. The data suggests a diverse workforce with employees from various age groups, geographic locations (primarily Texas zip codes), and professional levels. The prevalence of Aetna plans, particularly the Baptist ACO Plan 3, indicates a potentially long-standing relationship with this insurance provider. The detailed census provides insights into the organization's benefit strategy, showing a comprehensive approach to employee health coverage with options that accommodate different employee needs and job roles.