Appendix_F_-_Active_Employee_and_Retiree_PPO_Plan_Census_(revised).xlsx

The provided file is an employee census spreadsheet for active and retired employees enrolled in Sharewell and Wellwise Choice PPO health plans, associated with the County of Orange Human Resource Services, Employee Benefits Department in California. The spreadsheet contains detailed demographic information including employee dates of birth, gender, home state, zip code, and selected health plan coverage tier (such as "You Only", "You + Spouse/Domestic Partner", or "You + 2 or More Dependents"). The data appears to support a Request for Proposal (RFP) for claims administration services for self-insured PPO health plans covering both active and retired members.

The census data reveals a comprehensive breakdown of employees across multiple coverage options, with representation primarily from California but also including employees from states like Nevada, Arizona, Texas, and others. The spreadsheet includes multiple plan variations (Sharewell Retiree PPO and Wellwise Choice PPO) with different coverage tiers, suggesting a complex and diverse employee benefits structure. The extensive demographic information would be crucial for potential claims administrators to assess risk, determine pricing, and develop appropriate administrative strategies for the County of Orange's health plan management.