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
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 Month | Medical and Pharmacy Financials by Month | ||||||
| Membership | Financials | Innovation | |||||
| Month | Medical Subscribers | Medical Members | Pharmacy Subscribers | Pharmacy Members | Capitated Members | Medical |
Claim PMPM Medical Claim PEPM Pharmacy Claim PMPM Pharmacy Claim
| PEPM | Capitation | |
| PMPM | Total | |
| Medical | Total | |
| Pharmacy | Medical Capitation | Total Claim |
with
| Capitation | Payment Innovation Claim |
| PMPM | Total |
| Payment Innovation | Total Claim Amount With Payment Innovation |
and Capitation
| Oct 2025 | 564 | 1,169 | 564 | 1,169 | 1,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 2025 | 560 | 1,166 | 560 | 1,166 | 1,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 2025 | 560 | 1,171 | 560 | 1,171 | 1,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 2026 | 566 | 1,175 | 566 | 1,175 | 1,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 2026 | 560 | 1,164 | 560 | 1,164 | 1,166 | $318.77 | $662.60 | $314.50 | $653.72 | $0.14 | $371,053 | $366,083 | $162 | $737,298 | $4.41 | $5,128 | $742,426 |
| Total | 2,810 | 5,845 | 2,810 | 5,845 | 5,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 Quarter | Medical and Pharmacy Financials by Quarter | ||||||
| Membership | Financials | Innovation | |||||
| Quarter | Medical Subscribers | Medical Members | Pharmacy Subscribers | Pharmacy Members | Capitated Members | Medical |
Claim PMPM Medical Claim PEPM Pharmacy Claim PMPM Pharmacy Claim
| PEPM | Capitation | |
| PMPM | Total | |
| Medical | Total | |
| Pharmacy | Medical Capitation | Total Claim |
with
| Capitation | Payment Innovation Claim |
| PMPM | Total |
| Payment Innovation | Total Claim Amount With Payment Innovation |
and Capitation
| QTR 4 2025 | 1,684 | 3,506 | 1,684 | 3,506 | 3,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 2026 | 1,126 | 2,339 | 1,126 | 2,339 | 2,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 |
| Total | 2,810 | 5,845 | 2,810 | 5,845 | 5,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 Month | Dental and Vision Financials by Month | |||||
| Membership | Financials | |||||
| Month | Dental Subscribers | Dental Members | Vision Subscribers | Vision | ||
| Members | Dental |
Claim PMPM Dental Claim PEPM Vision Claim PMPM Vision Claim
| PEPM | Total |
| Dental | Total |
Vision
| Oct 2025 | 0 | 0 | 564 | 1,169 | $0.00 | $0.00 | $1.00 | $2.07 | $0 | $1,170 |
| Nov 2025 | 0 | 0 | 561 | 1,167 | $0.00 | $0.00 | $0.16 | $0.34 | $0 | $190 |
| Dec 2025 | 0 | 0 | 561 | 1,172 | $0.00 | $0.00 | $0.25 | $0.52 | $0 | $290 |
| Jan 2026 | 0 | 0 | 566 | 1,176 | $0.00 | $0.00 | $0.97 | $2.01 | $0 | $1,140 |
| Feb 2026 | 0 | 0 | 558 | 1,163 | $0.00 | $0.00 | $0.53 | $1.10 | $0 | $615 |
| Total | 0 | 0 | 2,810 | 5,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 .