Exhibit 42 - Cal Yr 2025 City of Miami CIGNA TC19 Disruption Report - Total Records Total Claimants Total Eligible Charges Summary.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- RFP No. 2130386 - Employee Health Benefits Plan
- Solicitation number
- RFP No. 2130386
- Issued by
- Florida
About this file
This document is a CIGNA Total Records Summary Report for the City of Miami's health benefits plan, covering calendar year 2025. The report provides a comprehensive analysis of in-network and out-of-network healthcare providers, focusing on total records, claimants, and eligible billed charges. The data reveals that 99.68% of records are in-network, representing 31,162 total records and $200,835,113.44 in eligible billed charges.
The report breaks down provider categories, with Community Physician Facility (CPF) providers comprising the largest segment at 68.04% of total records and 92.36% of eligible billed charges. Hospital-based providers account for 25.32% of records, while behavioral health providers and non-par providers are also detailed. Geographically, Florida dominates the provider landscape, with 82.83% of out-of-network records. The document includes additional analyses of provider specialties, with Family Medicine and Internal Medicine representing significant portions of the out-of-network providers. A Collaborative Accountable Care (CAC) section notes that the report may underestimate the impact of Cigna's physician group programs, as it only reports at the physician level.
View the file
Other files
Show 40 more
Latest 50 of 114 listed here. See the rest on GovTribe.
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
OAP
| In Network? | Total Records | % Total Records | TOTALSA | % TOTALSA | TOTALSB | % TOTALSB |
| Cigna | ||||||
| SUMMARY REPORT | ||||||
| City of Miami |
| EXHIBIT 42 | ||||||
| Open Access Plus | ||||||
| In Network? | Total Records | % Total Records | CLAIMANTS | % CLAIMANTS | eligible_billed_charges | % eligible_billed_charges |
| YES | 31,162 | 99.68% | 66,859 | 99.74% | $200,835,113.44 | 99.95% |
| NO | 99 | 0.32% | 174 | 0.26% | $105,150.63 | 0.05% |
| Adjusted Total | 31,261 | 67,033 | $200,940,264.07 | |||
| Excluded Records | 846 | 1,427 | $4,473,123.90 | |||
| Total Records in File | 32,107 | 68,460 | $205,413,387.97 | |||
| Yes Breakdown | Total Records | % Total Records | CLAIMANTS | % CLAIMANTS | eligible_billed_charges | % eligible_billed_charges |
| CPF | 21,202 | 68.04% | 47,911 | 71.66% | $185,498,126.91 | 92.36% |
| Hospital-Based | 7,891 | 25.32% | 16,155 | 24.16% | $13,197,969.15 | 6.57% |
| NAME | 39 | 0.13% | 47 | 0.07% | $102,089.23 | 0.05% |
| NAME+ADDRESS+STATE | 4 | 0.01% | 4 | 0.01% | $440.00 | 0.00% |
| NAME+STATE | 156 | 0.50% | 219 | 0.33% | $520,746.47 | 0.26% |
| NPI | 357 | 1.15% | 417 | 0.62% | $158,861.58 | 0.08% |
| NPI - Dental Only | 18 | 0.06% | 18 | 0.03% | $5,000.11 | 0.00% |
| NPI - Pharmacy Only | 25 | 0.08% | 25 | 0.04% | $26,340.42 | 0.01% |
| NPI - Vision Only | 3 | 0.01% | 4 | 0.01% | $385.00 | 0.00% |
| NPI+NAME+STATE | 9 | 0.03% | 9 | 0.01% | $5,260.58 | 0.00% |
| TIN | 39 | 0.13% | 217 | 0.33% | $58,890.24 | 0.03% |
| TIN+NAME | 88 | 0.28% | 104 | 0.16% | $60,673.50 | 0.03% |
| TIN+NAME+ADDRESS+STATE | 84 | 0.27% | 127 | 0.19% | $181,917.39 | 0.09% |
| TIN+STATE | 1,247 | 4.00% | 1,602 | 2.40% | $1,018,412.86 | 0.51% |
| Total Yes | 31,162 | 66,859 | $200,835,113.44 | |||
| Top 20 No Breakdown - PROV_SPECIALTY | Total Records | % Total Records | CLAIMANTS | % CLAIMANTS | eligible_billed_charges | % eligible_billed_charges |
| FAMILY MEDICINE | 32 | 32.32% | 52 | 29.89% | $19,917.13 | 18.94% |
| INTERNAL MEDICINE | 23 | 23.23% | 39 | 22.41% | $15,755.35 | 14.98% |
| OTHER | 16 | 16.16% | 31 | 17.82% | $36,964.34 | 35.15% |
| PEDIATRICS | 5 | 5.05% | 17 | 9.77% | $16,104.00 | 15.32% |
| CARDIOVASCULAR DISEASE | 4 | 4.04% | 7 | 4.02% | $2,099.52 | 2.00% |
| DERMATOLOGY | 4 | 4.04% | 12 | 6.90% | $4,644.63 | 4.42% |
| ENDOCRINOLOGY AND METABOLISM | 2 | 2.02% | 2 | 1.15% | $760.00 | 0.72% |
| GENERAL PRACTICE | 2 | 2.02% | 2 | 1.15% | $305.00 | 0.29% |
| NEUROLOGY | 2 | 2.02% | 2 | 1.15% | $5,063.00 | 4.82% |
| ONCOLOGY | 2 | 2.02% | 2 | 1.15% | $419.00 | 0.40% |
| OPHTHALMOLOGY | 2 | 2.02% | 3 | 1.72% | $1,715.82 | 1.63% |
| BEHAVIORAL NURSE | 1 | 1.01% | 1 | 0.58% | $177.00 | 0.17% |
| CARDIOLOGY, INTERVENTIONAL | 1 | 1.01% | 1 | 0.58% | $0.00 | 0.00% |
| PEDIATRIC NEUROLOGY | 1 | 1.01% | 1 | 0.58% | $709.00 | 0.67% |
| SURGERY, PLASTIC | 1 | 1.01% | 1 | 0.58% | $272.84 | 0.26% |
| UROLOGY | 1 | 1.01% | 1 | 0.58% | $244.00 | 0.23% |
| Total No | 99 | 174 | $105,150.63 | |||
| Top 20 No Breakdown - STATE | Total Records | % Total Records | CLAIMANTS | % CLAIMANTS | eligible_billed_charges | % eligible_billed_charges |
| FL | 82 | 82.83% | 134 | 77.01% | $78,610.26 | 74.76% |
| PR | 6 | 6.06% | 17 | 9.77% | $11,531.74 | 10.97% |
| CA | 5 | 5.05% | 17 | 9.77% | $14,036.63 | 13.35% |
| TX | 2 | 2.02% | 2 | 1.15% | $0.00 | 0.00% |
| IL | 1 | 1.01% | 1 | 0.58% | $600.00 | 0.57% |
| IN | 1 | 1.01% | 1 | 0.58% | $195.00 | 0.19% |
| ME | 1 | 1.01% | 1 | 0.58% | $0.00 | 0.00% |
| NM | 1 | 1.01% | 1 | 0.58% | $177.00 | 0.17% |
| Total No | 99 | 174 | $105,150.63 | |||
| BEHAVIORAL HEALTH PROVIDERS* (included in above results): | ||||||
| In Network? | Total Records | Impact on Disruption | CLAIMANTS | Impact on Disruption | eligible_billed_charges | Impact on Disruption |
| YES | 78 | 109 | $172,842.93 | |||
| NO | 1 | 0.00% | 1 | 0.00% | $177.00 | 0.00% |
| Total | 79 | 110 | $173,019.93 | |||
| *Refer to Understanding Your Results tab for section details | ||||||
| HOSPITAL-BASED Providers (included in above results): | ||||||
| Provider Type | Total Records | CLAIMANTS | eligible_billed_charges | |||
| Ambulance | 24 | 67 | $135,859.07 | |||
| Anesthesiology | 1,462 | 1,829 | $3,735,481.42 | |||
| Emergency | 1,064 | 1,905 | $2,488,847.59 | |||
| Hospitalists | 6 | 6 | $2,418.00 | |||
| Neonatologist | 94 | 157 | $856,526.00 | |||
| Pathology | 890 | 3,583 | $1,597,299.19 | |||
| Radiology | 2,707 | 5,877 | $2,471,777.13 | |||
| Surgical Assistant | 33 | 48 | $22,712.00 | |||
| Total | 6,280 | 13,472 | $11,310,920.40 | |||
| NON-PAR Providers ("Yes" records included in above results; "Non-Par" included below in Excluded Records): | ||||||
| In Network? | Total Records | Impact on Disruption | CLAIMANTS | Impact on Disruption | eligible_billed_charges | Impact on Disruption |
| YES | 4,137 | 13.23% | 5,837 | 8.71% | $4,582,016.13 | 2.28% |
| Non-Par | 505 | 722 | $2,760,059.92 | |||
| Total | 4,642 | 6,559 | $7,342,076.05 | |||
| EXCLUDED RECORDS: (Includes all "Invalid" and "Non-Par" records) | ||||||
| Provider Type | Total Records | CLAIMANTS | eligible_billed_charges | |||
| Acupuncture | 15 | 16 | $31,121.38 | |||
| Audiology | 13 | 16 | $6,462.38 | |||
| Dietitians | 43 | 54 | $29,204.58 | |||
| DME | 137 | 412 | $961,688.82 | |||
| Home Health | 111 | 183 | $642,779.32 | |||
| Midwife | 22 | 24 | $41,807.50 | |||
| Non-Par | 505 | 722 | $2,760,059.92 | |||
| Total | 846 | 1,427 | $4,473,123.90 | |||
| Collaborative Accountable Care (CAC): | Total Records | % Total Records | CLAIMANTS | % CLAIMANTS | eligible_billed_charges | % eligible_billed_charges |
| Yes | 2,267 | 7.27% | 3,996 | 5.98% | $3,180,290.25 | 1.58% |
| This report may underestimate the impact of Cigna Collaborative Care physician group programs (aka Cigna Accountable Care, CACs) as it reports at the physician level only. | ||||||
| Facilities, Ancillaries, and Associations are not identified at the CAC level and therefore this report does not contain CAC results for these types of providers. |
Disclaimers
| FOR PPO AND OPEN ACCESS PLUS ANALYSES ONLY: 'Accounts with members residing in Hawaii or parts of Mississippi are 'subject to plan design review and approval prior to gaining 'network access. For further information, see Speedread 000423 release 9/5/2003. |
| FOR OPEN ACCESS PLUS ANALYSES ONLY: PR350 and VI350: restrictions apply; FOR EXISTING BUSINESS ONLY. NOT AVAILABLE FOR SALE. No exceptions. Only USVI Government is approved to use OAP network. |
| FOR HMO/POS (CHP/CHA) ANALYSIS ONLY: 'Effective 7/1/01, accounts with members residing in the 'Chicago/NW Indiana HMO network are required to access a new 'provider network (HMO 143/IL801) that is different than the existing 'Network/Network POS (Flexcare) network (HMO 100/IL053). Disruption data for the new network will be available on 6/18/01. For further information, see Speedread 010176 released 4/13/2001. |
image1.png image2.png
File details come from the government source that posted it. Updated .