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
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
| CURRENT | Inpatient | Outpatient | Professional | Pharmacy | Other | |||||||||||||
| Rank | Mbr SSN | Contract Number | Div | Relationship | Diagnosis Description | Days | Admits | Paid Amt | Visits | Paid Amt | Services | Paid Amt | # of Rx | Paid Amt | Claim Count | Paid Amt | Total Paid Amt | Total Billed Amt |
| Total | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 |
| PRIOR | Inpatient | Outpatient | Professional | Pharmacy | Other | |||||||||||||
| Rank | Mbr SSN | Contract Number | Div | Relationship | Diagnosis Description | Days | Admits | Paid Amt | Visits | Paid Amt | Services | Paid Amt | # of Rx | Paid Amt | Claim Count | Paid Amt | Total Paid Amt | Total Billed Amt |
| 1 | ***-**-3511 | *****3511 | 008 | SUBSCRIBER | SEPSIS, UNSPECIFIED ORGANISM; ALCOHOL INDUCED ACUTE PANCREATITIS WITHOUT NECROSIS OR INFECTION; PNEUMONIA, UNSPECIFIED ORGANISM | 59 | 2 | $282,436.90 | 10 | $3,435.54 | 59 | $7,085.19 | 19 | $382.37 | 0 | $0.00 | $293,340.00 | $109,444.01 |
| 2 | ***-**-7728 | *****7728 | 011 | SUBSCRIBER | OTHER SPECIFIED NONINFLAMMATORY DISORDERS OF VAGINA; PHARMACY RX; CALCULUS OF KIDNEY | 1 | 1 | $32,177.00 | 19 | $31,980.84 | 137 | $23,845.05 | 85 | $28,221.88 | 0 | $0.00 | $116,224.77 | $665,930.86 |
| 3 | ***-**-5797 | *****5797 | 010 | SUBSCRIBER | ENCOUNTER FOR ANTINEOPLASTIC RADIATION THERAPY; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; DYSPHONIA | 0 | 0 | $0.00 | 49 | $94,950.15 | 61 | $12,908.60 | 23 | $137.08 | 0 | $0.00 | $107,995.83 | $285,283.30 |
| 4 | ***-**-6725 | *****6725 | R08 | SUBSCRIBER | UNILATERAL PRIMARY OSTEOARTHRITIS, RIGHT KNEE; UNILATERAL PRIMARY OSTEOARTHRITIS, LEFT KNEE; POLYP OF COLON | 0 | 0 | $0.00 | 13 | $91,071.84 | 74 | $14,933.65 | 18 | $36.63 | 0 | $0.00 | $106,042.12 | $235,714.20 |
| 5 | ***-**-3871 | *****3871 | 012 | SUBSCRIBER | PHARMACY RX; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS; OTHER SPECIFIED DISORDERS OF TEETH AND SUPPORTING STRUCTURES | 0 | 0 | $0.00 | 1 | $640.89 | 19 | $1,708.31 | 40 | $91,491.35 | 0 | $0.00 | $93,840.55 | $130,974.17 |
| 6 | ***-**-7551 | *****7551 | 012 | SUBSCRIBER | SEPSIS, UNSPECIFIED ORGANISM; IRON DEFICIENCY ANEMIA, UNSPECIFIED; MALIGNANT NEOPLASM OF UPPER-INNER QUADRANT OF LEFT FEMALE BREAST | 6 | 3 | $60,746.76 | 0 | $0.00 | 128 | $13,014.38 | 9 | $274.60 | 0 | $0.00 | $74,035.74 | $358,174.62 |
| 7 | ***-**-9712 | *****9712 | 011 | SUBSCRIBER | OTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION; BENIGN PAROXYSMAL VERTIGO, UNSPECIFIED EAR; HYPERTENSIVE EMERGENCY | 5 | 2 | $16,883.82 | 4 | $27,805.00 | 73 | $12,194.88 | 35 | $8,095.88 | 0 | $0.00 | $64,979.58 | $236,957.83 |
| 8 | ***-**-3674 | *****3674 | 002 | SUBSCRIBER | CALCULUS OF KIDNEY; ABRASION OF RIGHT INDEX FINGER, INITIAL ENCOUNTER; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON | 0 | 0 | $0.00 | 7 | $57,375.76 | 27 | $6,154.81 | 17 | $169.16 | 0 | $0.00 | $63,699.73 | $358,543.22 |
| 9 | ***-**-5170 | *****5170 | 007 | SUBSCRIBER | PHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OBSTRUCTIVE SLEEP APNEA (ADULT) (PEDIATRIC) | 0 | 0 | $0.00 | 0 | $0.00 | 20 | $1,227.08 | 114 | $53,867.32 | 0 | $0.00 | $55,094.40 | $98,522.55 |
| 10 | ***-**-9873 | *****7895 | 012 | SPOUSE | PHARMACY RX; OTHER RHEUMATOID ARTHRITIS WITH RHEUMATOID FACTOR OF MULTIPLE SITES; CONTACT WITH AND (SUSPECTED) EXPOSURE TO COVID-19 | 0 | 0 | $0.00 | 0 | $0.00 | 9 | $557.42 | 36 | $53,687.08 | 0 | $0.00 | $54,244.50 | $72,551.84 |
| 11 | ***-**-7639 | *****7639 | 011 | SUBSCRIBER | ATHEROSCLEROTIC 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 PECTORIS | 0 | 0 | $0.00 | 1 | $51,523.09 | 14 | $1,363.80 | 12 | $0.00 | 0 | $0.00 | $52,886.89 | $651,021.00 |
| Total | 71 | 8 | $392,244.48 | 104 | $358,783.11 | 621 | $94,993.17 | 408 | $236,363.35 | 0 | $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 .