Medical_Census_Date_File-_9_1_26-_Updated_9_22_26.xlsx

This is a medical census data file for Metrocare Services, a Texas-based organization, in support of a state and local contract opportunity for Individual Coverage Health Reimbursement Arrangement (ICHRA) administration services. The file contains comprehensive employee enrollment data updated as of September 22, 2026, including over 1,000 active employees and dependents across Texas and select out-of-state locations. The census template captures critical enrollment information such as unique employee identifiers, employment status (active, retiree, COBRA, or leave of absence), dates of birth, hire dates, home states and zip codes, medical plan elections (primarily BlueCross BlueShield HDHP and EPO plans), coverage tier selections (employee only, employee plus spouse, employee plus children, or family), employment type (full-time), FTE percentages, and annual salary information. The data is organized to facilitate carrier proposals and plan analysis while protecting personally identifiable information through the use of unique identifiers rather than social security numbers, and includes annotations from benefits professionals regarding data handling best practices and plan administration considerations.

The census file reflects a diverse workforce with annual salaries ranging from approximately $37,000 to $333,000, with the majority of employees electing high-deductible health plans (HDHP) with preferred provider organization (PPO) networks. The file includes notation that certain data fields such as extended waiting periods, state-specific benefit requirements (California STD benefits, Hawaii plan approvals, Massachusetts filing requirements), and geographic distribution by city may be relevant for analysis of safe and sick leave requirements and other jurisdictional compliance matters. Coverage elections indicate varying family compositions, with many employees selecting family or dependent coverage options, and several employees identified as Medicare-eligible. The data quality includes error flags in certain date fields and notes regarding waived or declined coverage elections, providing a comprehensive snapshot of the organization's health benefit population necessary for ICHRA plan design, implementation, and ongoing administration services.