Gloucester County Repricing Summary 02032026 file.xlsx

XLSX spreadsheet 112 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 document is a Cigna OAP (Open Access Plus) repricing summary for Gloucester County covering claims data from October 2024 through September 2025, paid through December 2025. The summary analyzes healthcare claim charges and network discounts across multiple service categories including inpatient facilities, outpatient facilities, physician services, injectables, laboratory services, radiology, and Healthcare Common Procedure Coding System (HCPCS) items. The data is segmented by three-digit zip codes and provider-specific arrangements, providing comparative analysis of network charges, discount percentages, discount amounts in dollars, and network-allowed amounts. The document does not contain information regarding response dates, due dates, site visits, bidders' meetings, award dates, or contract terms, as it functions as a historical financial analysis rather than a solicitation or contract award document.

The repricing summary reveals significant variation in network discount rates across service categories. The three-digit zip code approach achieved a 63.7% network discount rate on $7.96 billion in total charges for inpatient, outpatient, and physician services combined, resulting in $4.86 billion in discounts and $2.77 billion in network-allowed amounts. The provider-specific approach achieved a 60.5% discount rate, generating $4.63 billion in discounts and $3.02 billion in network-allowed amounts. Virginia accounts for nearly all claims activity, with minimal "All Other" state representation. Outpatient facility services represent the largest claim volume at $4.32 billion in charges, while inpatient services account for $1.24 billion and physician services $1.41 billion. Data quality issues totaling $128,326 were excluded from primary repricing analysis, with reconciliation confirming all source file totals matched the summary page figures.

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
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 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

Summary

Gloucester County Repricing Summary
Cigna OAP - 2026
Extract Dates: Incurred Oct 2024-Sep 2025 Paid through Dec 2025
3-DIGIT ZIPPROVIDER SPECIFIC
Claim TypesTotal ChargesNetwork ChargesNetwork Discount (%)Network Discount ($)Network AllowedNetwork ChargesNetwork Discount (%)Network Discount ($)Network Allowed
IP FacilityInpatient$1,244,397$943,01956.4%$531,493$411,526$943,01947.6%$449,137$493,882
OP FacilityOutpatient$4,322,272$4,322,27269.0%$2,982,700$1,339,572$4,322,27265.4%$2,827,940$1,494,332
PhysicianPhysician$1,405,214$1,404,66357.1%$801,789$602,874$1,404,66348.3%$679,077$725,586
InjectiblesInjectibles$337,370$337,37057.1%$192,756$144,613$337,37060.1%$202,608$134,762
LabLab$325,163$319,28757.1%$182,216$137,071$319,28778.2%$249,595$69,692
RadiologyRadiology$164,502$164,45857.0%$93,817$70,641$164,45852.0%$85,521$78,936
HCPCs*HCPCs*$159,834$158,82557.0%$90,598$68,227$158,82582.7%$131,341$27,484
IP/OP/Phys Subtotal$7,958,752$7,649,89363.7%$4,875,369$2,774,524$7,649,89360.5%$4,625,219$3,024,674
Data Issues$128,326$128,32663.7%$81,783$46,542$128,32660.5%$77,587$50,738
Grand Total$8,087,078$7,778,21963.7%$4,957,153$2,821,066$7,778,21960.5%$4,702,806$3,075,412

OON Charges $308,859 47.8% $147,615 $161,244 $308,859 47.8% $147,615 $161,244

* Healthcare Common Procedure Coding System (HCPCs) claims include transportation, medical supplies/materials, and hearing.

&F - &A &D &T

IP-OP-Phys Subtotal Repricing Summary - IP/OP/Physician

3-DIGIT ZIPPROVIDER SPECIFIC
StateTotal Claim ChargesNetwork ChargesNetwork Discount(%)Network Discount($)Network AllowedNetwork ChargesNetwork Discount(%)Network Discount($)Network Allowed
Totals$7,958,752$7,649,89363.7%$4,875,369$2,774,524$7,649,89360.5%$4,625,219$3,024,674
VA$7,958,033$7,649,17463.7%$4,874,889$2,774,285$7,649,17460.5%$4,624,838$3,024,336
All Other$719$71966.7%$480$239$71953.0%$381$338
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0

&F - &A &D &T

Inpatient Repricing Summary - Inpatient

3-DIGIT ZIPPROVIDER SPECIFIC
StateTotal Claim ChargesNetwork ChargesNetwork Discount(%)Network Discount($)Network AllowedNetwork ChargesNetwork Discount(%)Network Discount($)Network Allowed
Totals$1,244,397$943,01956.4%$531,493$411,526$943,01947.6%$449,137$493,882
VA$1,244,397$943,01956.4%$531,493$411,526$943,01947.6%$449,137$493,882
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0

&F - &A &D &T

Outpatient Repricing Summary - Outpatient

3-DIGIT ZIPPROVIDER SPECIFIC
StateTotal Claim ChargesNetwork ChargesNetwork Discount(%)Network Discount($)Network AllowedNetwork ChargesNetwork Discount(%)Network Discount($)Network Allowed
Totals$4,322,272$4,322,27269.0%$2,982,700$1,339,572$4,322,27265.4%$2,827,940$1,494,332
VA$4,322,272$4,322,27269.0%$2,982,700$1,339,572$4,322,27265.4%$2,827,940$1,494,332
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0

&F - &A &D &T

Physician Repricing Summary - Physician

3-DIGIT ZIPPROVIDER SPECIFIC
StateTotal Claim ChargesNetwork ChargesNetwork Discount(%)Network Discount($)Network AllowedNetwork ChargesNetwork Discount(%)Network Discount($)Network Allowed
Totals$1,405,214$1,404,66357.1%$801,789$602,874$1,404,66348.3%$679,077$725,586
VA$1,404,807$1,404,25657.1%$801,517$602,739$1,404,25648.3%$678,936$725,320
All Other$407$40766.7%$272$135$40734.7%$141$266
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0

&F - &A &D &T

Hospital Based Repricing Summary - Injectables, Lab, Radiology

3-DIGIT ZIPPROVIDER SPECIFIC
StateTotal Claim ChargesNetwork ChargesNetwork Discount(%)Network Discount($)Network AllowedNetwork ChargesNetwork Discount(%)Network Discount($)Network Allowed
Totals$827,035$821,11457.1%$468,789$352,325$821,11465.5%$537,724$283,390
VA$826,723$820,80257.1%$468,581$352,221$820,80265.5%$537,485$283,318
All Other$312$31266.7%$208$104$31276.8%$240$72
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
0$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0

&F - &A &D &T

HCPCs Repricing Summary - HCPCs

3-DIGIT ZIPPROVIDER SPECIFIC
StateTotal Claim ChargesNetwork ChargesNetwork Discount(%)Network Discount($)Network AllowedNetwork ChargesNetwork Discount(%)Network Discount($)Network Allowed
Totals$159,834$158,82557.0%$90,598$68,227$158,82582.7%$131,341$27,484
VA$159,834$158,82557.0%$90,598$68,227$158,82582.7%$131,341$27,484
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0
$0$00.0%$0$0$00.0%$0$0

&F - &A &D &T

Data Issues Data Issues

Comments
Claim TypesPercent of TotalTotal Charges3-DIGIT ZIPPROVIDER SPECIFIC
Dental0.4%$47863.7%60.5%Assume these claims are similar to the repriced ones
Dietitian1.4%$1,79863.7%60.5%
Equipment/Supplies82.6%$106,04063.7%60.5%
Home Health2.5%$3,25063.7%60.5%
Invalid Data0.1%$13763.7%60.5%
Limited Benefit0.4%$55163.7%60.5%
Nursing12.5%$16,07263.7%60.5%
Grand Totals100.0%$128,32663.7%60.5%

&F - &A &D&T

Reconciliation Reconciliation to Source Data

Comments
Source FileSource Table/TabGrouper (optional)Total
Source File8,087,078
Total on Source File8,087,078
Total on Summary Page8,087,078
Difference- 0

Were these totals taken from the physical file provided?

If not, what processing was done prior to these totals?

Yes No

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