COG Medical Census 5.26.2026.xlsx

This is a medical census spreadsheet for the City of Greenville and Greenville Utilities Commission (COG) related to a solicitation for Self-Funded and Medical and Pharmacy Claims Administration Services. The document lists approximately 1,200 covered employees and beneficiaries enrolled across multiple medical plan options including Core Medical Plan, Enhanced Medical Plan, and HSA Medical Plan. Covered individuals include full-time employees (FT), part-time employees (PT), retirees, elected officials, COBRA participants, and those with designated qualifying statuses (DQ, DH, Elected). Plan participation is distributed across various job classes and coverage tiers, with employees representing diverse geographic locations indicated by zip codes throughout North Carolina. The census data provides essential enrollment information for bidders responding to the healthcare claims administration services proposal.

The spreadsheet captures individual-level enrollment details including employee identification numbers (EID), job classification, date of birth, gender, and zip code, which collectively establish the baseline population for actuarial and rate-setting purposes. Plan tiers range from Core Medical to Enhanced Medical to HSA options, reflecting different benefit designs and cost-sharing structures. The presence of retiree, COBRA, and active employee populations indicates a complex benefit structure requiring comprehensive claims administration capabilities. This census data serves as the foundation for vendor evaluation and pricing proposals, enabling potential bidders to assess population demographics, plan distribution, and administrative complexity for the self-funded medical and pharmacy services contract.