Attachment U - Supplemental Plan Claims Utilization.pdf

PDF 59 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 Supplemental Plan Claims Utilization report for Gloucester County Public covering supplemental insurance products for the period spanning 2024 to 2025 under Group Contract 172963. The report details claims experience across three product categories: Accident, Critical Illness, and Hospital Indemnity insurance. The data encompasses 931 total year-end member lives and includes both member and dependent claims. Claims are segmented into Non-Wellness and Wellness claim categories, with comprehensive tracking of claim counts and corresponding benefits paid for each product line and reporting year.

The report documents total claims activity of 86 claims across all products, generating $37,010 in total benefits paid during the reporting period. Accident coverage recorded 38 claims with $4,460 in benefits paid across 434 member lives; Critical Illness recorded 24 claims with $12,300 in benefits paid across 284 member lives; and Hospital Indemnity recorded 24 claims with $20,250 in benefits paid across 213 member lives. Wellness claims comprised 70 of the total 86 claims, with $4,600 paid in wellness benefits, while Non-Wellness claims totaled 16 with $32,410 paid. Year-over-year comparison shows variation in claim activity and benefit utilization across both product categories and wellness classifications.

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
1B Member and claims oct 2025- Feb 2026.xlsx XLSX spreadsheet
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 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

Experience by Year Detailed Product

Year-End Member Lives

Non-Wellness Claim Count (#)

Wellness Claim Count (#)

Total Claim Count (#)

Non-Wellness Benefits Paid ($)

Wellness Benefits Paid ($)

Total Benefits Paid ($)

Accident 434 4 34 38 $2,810 $1,650 $4,460 2024 231 1 0 1 $60 $0 $60 2025 203 3 34 37 $2,750 $1,650 $4,400

Critical Illness 284 1 23 24 $10,000 $2,300 $12,300 2024 154 1 2 3 $10,000 $200 $10,200 2025 130 0 21 21 $0 $2,100 $2,100

Hospital Indemnity 213 11 13 24 $19,600 $650 $20,250 2024 110 2 1 3 $4,750 $50 $4,800 2025 103 9 12 21 $14,850 $600 $15,450

Total 931 16 70 86 $32,410 $4,600 $37,010

Group Contract: 172963

Data for:

Supplemental Reporting

GLOUCESTER COUNTY PUBLIC

Data includes year(s): 2024 to 2025

Claims data include both Member and Dependent claims.

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