GUC Medical Census 5.26.2026.xlsx

This is a medical census data file for the City of Greenville and Greenville Utilities Commission (GUC) related to a self-funded medical and pharmacy claims administration services solicitation. The census data contains enrollment information as of May 26, 2026, documenting covered employees and dependents across multiple medical plan options including Core Medical Plan, Enhanced Medical Plan, and HSA Medical Plan, with coverage tiers designated as EC (Employee and Child), EO (Employee Only), ES (Employee and Spouse), and FA (Family). The file includes 1,289 enrollee records with demographic information including employee identification numbers, dates of birth, zip codes, enrollment status (Full-Time or Retiree), and gender, providing a comprehensive snapshot of the eligible population for which claims administration services will be required.

The census data demonstrates significant enrollment distribution across plan types, with the Core Medical Plan comprising the majority of enrollees, followed by HSA Medical Plan and Enhanced Medical Plan options. Geographic distribution shows concentration in North Carolina zip codes in the 27000 and 28000 ranges, reflecting the service area of the City of Greenville and GUC. The data serves as the baseline for proposers to understand plan design, enrollment demographics, and projected claims volume for cost estimation purposes in the self-funded medical and pharmacy services solicitation. This census information is critical for vendors responding to the RFP to accurately model administrative costs, develop competitive pricing, and ensure capability to service the identified employee and dependent population across multiple plan options and coverage tiers.