1B Member and claims oct 2025- Feb 2026.xlsx

XLSX spreadsheet 859 KB Posted

Attached to
RFP 26-025-CJ GCPS- Employee Medical, Stop Loss, Dental, Vision, Disability & Voluntary Benefits Coverage
Solicitation number
RFP-115259
Issued by
Frederick County, Virginia

About this file

This is a membership and claims report for health insurance coverage provided to Gloucester County School Board for the period of October 2025 through February 2026. The report analyzes medical, pharmacy, dental, and vision insurance claims and membership data across five months, with data current as of the latest load date in February 2026 and run date of March 17, 2026. The report tracks membership subscribers and members across all four coverage categories, with medical and pharmacy subscribers maintaining relatively stable enrollment between 558 and 566 subscribers per month and vision coverage provided to between 558 and 566 subscribers. Capitated membership remained consistent at approximately 1,161 to 1,177 members throughout the five-month period. The analysis includes both monthly and quarterly breakdowns of membership and financial metrics.

The report presents comprehensive financial metrics including per-member-per-month (PMPM) and per-employee-per-month (PEPM) claim costs for each coverage type. Total medical claims across the five-month period amounted to $1,539,242, pharmacy claims totaled $1,445,032, and vision claims totaled $3,405, with capitation payments of $813 and payment innovation claims of $22,940, resulting in a combined total claim amount of $3,008,027. Medical claim PMPM costs averaged $263.34 across the period, while pharmacy claim PMPM averaged $247.23. Vision claims represented minimal costs at $0.58 PMPM. The data indicates the plan is underwritten by Anthem Blue Cross and Blue Shield, with the report noting that pharmacy claims runout information is current through February 2026 and medical claims through the date specified in the report header.

View the file

Other files

File Type Posted
Addendum 1.pdf PDF
external extract for gloucester co.xlsx XLSX spreadsheet
Attachment T – Vision Top Providers for Disruption Analysis.xlsx XLSX spreadsheet
Attachment M – Long Term Disability Claims History.xlsx XLSX spreadsheet
Attachment 2A. HCCs Sept 2023 - Oct 2024-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_HCC-01_20260318 03_32 PM.xlsx XLSX spreadsheet
Attachment 3 Retiree Dental GCPS Addendum Question.xlsx XLSX spreadsheet
Addendum 3 FINAL.pdf PDF
Attachment O – Medical Claim Repricing File for Discount and Disruption Analysis.xlsx XLSX spreadsheet
Attachment 2B. HCCs Oct 2024 - Sept 2025-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_HCC-01_20260318 03_31 PM.xlsx XLSX spreadsheet
Addendum 1.pdf PDF
Attachment V - Hybrid STD Benefit Summary.pdf PDF
external extract for gloucester co.xlsx XLSX spreadsheet
Attachment L – Disability Benefits.pdf PDF
Attachment S – Dental Network Utilization for Disruption Analysis .xlsx XLSX spreadsheet
Gloucester County Repricing Summary 02032026 file.xlsx XLSX spreadsheet
Addendum 2.pdf PDF
Attachment 2C. HCCs Oct 2025 - Feb 2026-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_HCC-01_20260318 03_29 PM.xlsx XLSX spreadsheet
Attachment D – Current census and enrollment for all lines of coverage (including COBRA and Retirees).xlsx XLSX spreadsheet
Attachment J – Dental Claims and enrollment history.xlsx XLSX spreadsheet
Attachment 2. HCCS over 50k Feb 2024 - Jan 2025-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_HCC-01_20260317 03_43 PM.pdf PDF
Attachment H – Vision Benefits.pdf PDF
Attachment B - Price Proposal.xlsx XLSX spreadsheet
Attachment R – Current and Historical Rates - All Lines.pdf PDF
Attachment W - Hybrid LTD Benefit Summary.pdf PDF
Attachment Q – Pharmacy Questionnaire.docx DOCX document
Attachment 1. Mem and Claims Oct 2023 - Sept 2024-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_FIN-01_20260317 03_29 PM (2).xlsx XLSX spreadsheet
Attachment K – Vision Claims and enrollment history.pdf PDF
Attachment U - Supplemental Plan Claims Utilization.pdf PDF
Attachment 1A. Mem and Claims Oct 2024 - Sept 2025-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_FIN-01_20260317 03_28 PM.xlsx XLSX spreadsheet
Attachment P – Pharmacy Claim Repricing & Disruption Analysis - DELETE YELLOW ONCE APPROVED.xlsx XLSX spreadsheet
Gloucester County Repricing Cover Letter 02032026.docx DOCX document
Attachment N – Accident, Critical Illness, Hospital Benefits.pdf PDF
Attachment I – Medical Claims, Enrollment, HCCs.xlsx XLSX spreadsheet
Show all 33

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

FIN-01_Visualization

FIN-01_1

Membership and Claims by Month
GLOUCESTER COUNTY SCHOOL BOARD | Segmentation: Total Account

Current: Oct 2025 - Feb 2026 | Data Set: Medical, Pharmacy, Dental & Vision | Paid/Incurred: Paid

Medical and Pharmacy Membership by MonthMedical and Pharmacy Financials by Month
MembershipFinancialsInnovation
MonthMedical SubscribersMedical MembersPharmacy SubscribersPharmacy MembersCapitated MembersMedical

Claim PMPM Medical Claim PEPM Pharmacy Claim PMPM Pharmacy Claim

PEPMCapitation
PMPMTotal
MedicalTotal
PharmacyMedical CapitationTotal Claim

with

CapitationPayment Innovation Claim
PMPMTotal
Payment InnovationTotal Claim Amount With Payment Innovation

and Capitation

Oct 20255641,1695641,1691,161$361.15$748.56$191.38$396.66$0.14$422,186$223,719$163$646,068$4.50$5,265$651,332
Nov 20255601,1665601,1661,169$259.22$539.74$223.69$465.75$0.14$302,252$260,818$162$563,232$4.47$5,210$568,442
Dec 20255601,1715601,1711,177$126.57$264.66$269.87$564.32$0.14$148,212$316,022$163$464,396$4.36$5,110$469,506
Jan 20265661,1755661,1751,175$251.52$522.15$236.93$491.86$0.14$295,539$278,391$163$574,093$1.90$2,227$576,321
Feb 20265601,1645601,1641,166$318.77$662.60$314.50$653.72$0.14$371,053$366,083$162$737,298$4.41$5,128$742,426
Total2,8105,8452,8105,8455,848$263.34$547.77$247.23$514.25$0.14$1,539,242$1,445,032$813$2,985,087$3.92$22,940$3,008,027
Medical and Pharmacy Membership by QuarterMedical and Pharmacy Financials by Quarter
MembershipFinancialsInnovation
QuarterMedical SubscribersMedical MembersPharmacy SubscribersPharmacy MembersCapitated MembersMedical

Claim PMPM Medical Claim PEPM Pharmacy Claim PMPM Pharmacy Claim

PEPMCapitation
PMPMTotal
MedicalTotal
PharmacyMedical CapitationTotal Claim

with

CapitationPayment Innovation Claim
PMPMTotal
Payment InnovationTotal Claim Amount With Payment Innovation

and Capitation

QTR 4 20251,6843,5061,6843,5063,507$248.90$518.20$228.34$475.39$0.14$872,650$800,558$488$1,673,696$4.45$15,585$1,689,281
QTR 1 20261,1262,3391,1262,3392,341$284.99$592.00$275.53$572.36$0.14$666,592$644,474$325$1,311,391$3.14$7,355$1,318,747
Total2,8105,8452,8105,8455,848$263.34$547.77$247.23$514.25$0.14$1,539,242$1,445,032$813$2,985,087$3.92$22,940$3,008,027
Note: Quarterly summaries are based on the most current rolling 12 months (), causing some quarters to include less than 3 calendar months of data.
Dental and Vision Membership by MonthDental and Vision Financials by Month
MembershipFinancials
MonthDental SubscribersDental MembersVision SubscribersVision
MembersDental

Claim PMPM Dental Claim PEPM Vision Claim PMPM Vision Claim

PEPMTotal
DentalTotal

Vision

Oct 2025005641,169$0.00$0.00$1.00$2.07$0$1,170
Nov 2025005611,167$0.00$0.00$0.16$0.34$0$190
Dec 2025005611,172$0.00$0.00$0.25$0.52$0$290
Jan 2026005661,176$0.00$0.00$0.97$2.01$0$1,140
Feb 2026005581,163$0.00$0.00$0.53$1.10$0$615
Total002,8105,847$0.00$0.00$0.58$1.21$0$3,405

Anthem Blue Cross and Blue Shield is the trade name of: In Colorado: Rocky Mountain Hospital and Medical Service, Inc. HMO products underwritten by HMO Colorado, Inc. In Connecticut: Anthem Health Plans, Inc. In Indiana: Anthem Insurance Companies, Inc. In Georgia: Blue Cross Blue Shield Healthcare Plan of Georgia, Inc. and Community Care Health Plan of Georgia, Inc. In Kentucky: Anthem Health Plans of Kentucky, Inc. In Maine: Anthem Health Plans of Maine, Inc. In Missouri (excluding 30 counties in the Kansas City area): RightCHOICE® Managed Care, Inc. (RIT), Healthy Alliance® Life Insurance Company (HALIC), and HMO Missouri, Inc. RIT and certain affiliates administer non-HMO benefits underwritten by HALIC and HMO benefits underwritten by HMO Missouri, Inc. RIT and certain affiliates only provide administrative services for self-funded plans and do not underwrite benefits. In Nevada: Rocky Mountain Hospital and Medical Service, Inc. HMO products underwritten by HMO Colorado, Inc., dba HMO Nevada. In New Hampshire: Anthem Health Plans of New Hampshire, Inc. HMO plans are administered by Anthem Health Plans of New Hampshire, Inc. and underwritten by Matthew Thornton Health Plan, Inc. In 17 southeastern counties of New York: Anthem HealthChoice Assurance, Inc., and Anthem HealthChoice HMO, Inc. In these same counties Anthem Blue Cross and Blue Shield HP is the trade name of Anthem HP, LLC. In Ohio: Community Insurance Company. In Virginia: Anthem Health Plans of Virginia, Inc. trades as Anthem Blue Cross and Blue Shield, and its affiliate HealthKeepers, Inc. trades as Anthem HealthKeepers providing HMO coverage, and their service area is all of Virginia except for the City of Fairfax, the Town of Vienna, and the area east of State Route 123. In Wisconsin: Blue Cross Blue Shield of Wisconsin (BCBSWI) underwrites or administers PPO and indemnity policies and underwrites the out-of-network benefits in POS policies offered by Compcare Health Services Insurance Corporation (Compcare) or Wisconsin Collaborative Insurance Corporation (WCIC). Compcare underwrites or administers HMO or POS policies; WCIC underwrites or administers Well Priority HMO or POS policies. Independent licensees of the Blue Cross and Blue Shield Association. Anthem is a registered trademark of Anthem Insurance Companies, Inc.

This confidential information should not be distributed without prior written consent and should only be used to review health care utilization.

Pharmacy claims runout/paid through date is always set to the Latest Data Loaded month, for every time period. Medical claims runout/paid through date is indicated in the report header.
Latest Data Loaded: 02/2026 Run Date: 03/17/2026

image1.png image2.png image3.png image4.jpeg

File details come from the government source that posted it. Updated .