12-SCBOCC Experience Report HCC Florida Blue Medical 202312.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
Group Medical Benefits
Solicitation number
2026-10
Issued by
Seminole County, Florida

About this file

This is a High Cost Claims Summary Experience Report prepared by Florida Blue for the Suwannee County Board of County Commissioners (BOCC) regarding group medical benefits coverage. The report documents claim experiences for the period from October 2023 through December 2023 (current period) and compares this data to the prior period from October 2022 through September 2023. The claims analysis is organized by member and includes detailed breakdowns of inpatient admissions, outpatient visits, professional services, and pharmacy claims for individuals whose total paid claims exceeded the $50,000 threshold during the evaluation periods. The current period shows zero high-cost claims meeting the threshold, while the prior period identified eleven members with claims exceeding this amount, generating total paid claims of $1,082,384.11 against total billed amounts of $3,203,117.60.

The report details individual claim experiences across multiple service categories, with the highest-cost claimant in the prior period accumulating $293,340.00 in total paid claims related to sepsis, acute pancreatitis, and pneumonia requiring 59 inpatient days and two admissions. Notable diagnoses among high-cost claimants include cancer treatment, cardiac disease, orthopedic conditions, and chronic disease management requiring ongoing pharmacy support. The report was generated on February 16, 2024, and is marked as proprietary and confidential information belonging to Florida Blue, serving as an analytical tool for the Suwannee County BOCC to assess medical plan utilization patterns and cost management effectiveness across its employee and retiree populations.

View the file

Other files

File Type Posted
24-0.3 Guarantee Ltr of Commit Guarantee From.pdf PDF
29-1.1 Summary Form.pdf PDF
22-0.1 Information Instructions.pdf PDF
9-SCBOCC Monitoring Report FB DEC 2025 (1).xlsx XLSX spreadsheet
30-0.2 Scope of Work.pdf PDF
4-SCBOCC Claims MARCH 2026.xlsx XLSX spreadsheet
20-Participants.xlsx XLSX spreadsheet
16-Suwannee Cert P03160 10-1-25.pdf PDF
17-SCBOCC SBC PLAN 03559 Florida Blue Medical 20251001.pdf PDF
21-0.0 Advertisement.jpg JPG image
6-SCBOCC Experience Report Monitoring and HCC Florida Blue Medical 202312.xlsx XLSX spreadsheet
10-SCBOCC SBC PLAN 60 Florida Blue Medical 20251001.pdf PDF
14-Suwannee Cert P60 10-1-25.pdf PDF
13-SCBOCC SBC PLAN 03160 Florida Blue Medical 20251001.pdf PDF
1-Suwannee County Medical Census 3.19.2026.xlsx XLSX spreadsheet
2-SCBOCC Experience Report Florida Blue Medical 202403.xlsx XLSX spreadsheet
25-1.4 Scope of Services Table.pdf PDF
28-1.3 Questionnaire.pdf PDF
18-SCBOCC SBC PLAN 03161 Florida Blue Medical 20251001.pdf PDF
19-Suwannee Renewal Negotiated Florida Blue Medical Final 20251001 (1).pdf PDF
23-0.4 Standard Contract Terms.pdf PDF
5-SCBOCC ExpRpt FMR BCBSFL Medical 2025.12 (1).pdf PDF
7-SCBOCC Experience Report Florida Blue Medical 202409.xlsx XLSX spreadsheet
3-Suwannee Cert P03559 10-1-25.pdf PDF
11-SCBOCC Monitoring Report Report July 2025.xlsx XLSX spreadsheet
26-1.5 Financial Response Forms.pdf PDF
15-Suwannee Cert P03161 10-1-25.pdf PDF
8-SCBOCC Experience Report Monitoring and HCC Florida Blue Medical 202309.xlsx XLSX spreadsheet
27-1.2 Required Forms.pdf PDF
Show all 29

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

S1 High Cost Claims Summ Page1

High Cost Claims Summary
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 High Cost Claims Threshold: 50000 Current Paid Period: From 10/2023 to 12/2023 Prior Paid Period: From 10/2022 to 09/2023

CURRENTInpatientOutpatientProfessionalPharmacyOther
RankMbr SSNContract NumberDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
Total00$0.000$0.000$0.000$0.000$0.00$0.00$0.00
PRIORInpatientOutpatientProfessionalPharmacyOther
RankMbr SSNContract NumberDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1***-**-3511*****3511008SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; ALCOHOL INDUCED ACUTE PANCREATITIS WITHOUT NECROSIS OR INFECTION; PNEUMONIA, UNSPECIFIED ORGANISM592$282,436.9010$3,435.5459$7,085.1919$382.370$0.00$293,340.00$109,444.01
2***-**-7728*****7728011SUBSCRIBEROTHER SPECIFIED NONINFLAMMATORY DISORDERS OF VAGINA; PHARMACY RX; CALCULUS OF KIDNEY11$32,177.0019$31,980.84137$23,845.0585$28,221.880$0.00$116,224.77$665,930.86
3***-**-5797*****5797010SUBSCRIBERENCOUNTER FOR ANTINEOPLASTIC RADIATION THERAPY; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; DYSPHONIA00$0.0049$94,950.1561$12,908.6023$137.080$0.00$107,995.83$285,283.30
4***-**-6725*****6725R08SUBSCRIBERUNILATERAL PRIMARY OSTEOARTHRITIS, RIGHT KNEE; UNILATERAL PRIMARY OSTEOARTHRITIS, LEFT KNEE; POLYP OF COLON00$0.0013$91,071.8474$14,933.6518$36.630$0.00$106,042.12$235,714.20
5***-**-3871*****3871012SUBSCRIBERPHARMACY RX; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS; OTHER SPECIFIED DISORDERS OF TEETH AND SUPPORTING STRUCTURES00$0.001$640.8919$1,708.3140$91,491.350$0.00$93,840.55$130,974.17
6***-**-7551*****7551012SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; IRON DEFICIENCY ANEMIA, UNSPECIFIED; MALIGNANT NEOPLASM OF UPPER-INNER QUADRANT OF LEFT FEMALE BREAST63$60,746.760$0.00128$13,014.389$274.600$0.00$74,035.74$358,174.62
7***-**-9712*****9712011SUBSCRIBEROTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION; BENIGN PAROXYSMAL VERTIGO, UNSPECIFIED EAR; HYPERTENSIVE EMERGENCY52$16,883.824$27,805.0073$12,194.8835$8,095.880$0.00$64,979.58$236,957.83
8***-**-3674*****3674002SUBSCRIBERCALCULUS OF KIDNEY; ABRASION OF RIGHT INDEX FINGER, INITIAL ENCOUNTER; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON00$0.007$57,375.7627$6,154.8117$169.160$0.00$63,699.73$358,543.22
9***-**-5170*****5170007SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OBSTRUCTIVE SLEEP APNEA (ADULT) (PEDIATRIC)00$0.000$0.0020$1,227.08114$53,867.320$0.00$55,094.40$98,522.55
10***-**-9873*****7895012SPOUSEPHARMACY RX; OTHER RHEUMATOID ARTHRITIS WITH RHEUMATOID FACTOR OF MULTIPLE SITES; CONTACT WITH AND (SUSPECTED) EXPOSURE TO COVID-1900$0.000$0.009$557.4236$53,687.080$0.00$54,244.50$72,551.84
11***-**-7639*****7639011SUBSCRIBERATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; OCCLUSION AND STENOSIS OF BILATERAL CAROTID ARTERIES; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSPECIFIED ANGINA PECTORIS00$0.001$51,523.0914$1,363.8012$0.000$0.00$52,886.89$651,021.00
Total718$392,244.48104$358,783.11621$94,993.17408$236,363.350$0.00$1,082,384.11$3,203,117.60

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 02/16/2024 9:49 AM Page 1 of 1

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