OHIC Data Hub

As part of the Health Spending Accountability and Transparency Program, OHIC collaborated with an analytics consultant and the Health Care Cost Trends Steering Committee to develop interactive dashboards that utilize All-Payer Claims Database (APCD) data. These dashboards provide transparent reporting on trends in the cost and use of healthcare services in Rhode Island. The purpose is to inform provider organizations, payers, purchasers, policymakers, and state residents interested in improving the affordability of healthcare in Rhode Island.

The dashboards employ common methods for analyzing healthcare spending. Because alternative methods will produce different results, the measures reported here may differ from those generated by the Rhode Island Medicaid program. Individuals eligible for both Medicaid and Medicare, known as dual eligibles, are included only under their primary insurance coverage.

Although we believe the information, analysis, and methodology presented in the Cost Trends reports are accurate, reporting errors may impact the tool's calculations. Users assume responsibility for determining the tool's suitability for their purposes and use it at their own risk. OHIC may modify the information and analysis without notice.

This dashboard summarizes health care utilization and spending measures across Rhode Island and its counties. This supports understanding and analysis of health care cost drivers to generate insights into policy options for slowing spending growth within the state. Pharmacy spending data does not account for manufacturer rebates.

This dashboard facilitates analysis of retail pharmacy spending, enabling comparison of cost and utilization metrics by drug category and identification of the drugs that constitute the greatest proportion of total spend. Pharmacy spending data does not account for manufacturer rebates.

This dashboard enables analysis of medical pharmacy spending by comparing cost and utilization metrics across drug categories, highlighting the drugs that represent the largest proportion of total spend. Users can examine spending and utilization trends at both the state and county levels. The dashboard employs the Restructured BETOS Classification System (RBCS) to categorize utilization and spending, using Berenson-Eggers Type of Service (BETOS) codes assigned to each Healthcare Common Procedure Coding System (HCPCS) procedure code. The BETOS coding system was primarily developed for analyzing growth in Medicare expenditures. All results are based on analysis of commercial claims and Medicaid data.

This dashboard utilizes the Restructured BETOS Classification System (RBCS) categories along with derived user-intuitive Type of Service categories to analyze utilization and spending for medical services typically delivered in Hospital Outpatient or Professional/Office care settings. Berenson-Eggers Type of Service (BETOS) codes are assigned for each Healthcare Common Procedure Coding System (HCPCS) or Current Procedural Terminology (CPT) procedure code. The BETOS Coding System was developed primarily for analyzing the growth in Medicare expenditures, and has been updated and expanded by CMS since 2021.

This dashboard enables users to compare spending and utilization measures by diagnosis category, with a focus on identifying mental health disorders that represent a significant proportion of total spending in Rhode Island. The dashboard also highlights variations in utilization and spending by age group, gender, market (including commercial insurance, Medicaid, and Medicare Advantage), and service category or care setting. Mental health disorders have been identified and grouped by diagnosis category, using the International Classification of Diseases, 10th Revision (ICD-10) classification system adopted by the World Health Organization (WHO).

This dashboard compares in-state and out of state spending for hospital-provided services for which Rhode Island residents traveled out of state. Results are based on Major Diagnostic Categories (MDCs) and Diagnosis Related Groups (DRGs). MDCs organize illnesses into 25 mutually exclusive groups based on principal diagnoses and by medical specialty and organ system or etiology. To help facilitate meaningful comparisons, DRGs are assigned and used to categorize hospital inpatient visits based on severity of illness, risk of mortality, medical prognosis, need for intervention, and intensity of resource use in treating patients. Each DRG falls within a Major Diagnostic Category (MDC). MDCs and DRGs were assigned using the 3M All Patient Refined Diagnosis Related Groups (APR DRG) software. Out-of-state care locations include Massachusetts, Connecticut, and All Other states.

This dashboard supports analysis of utilization and spending on Chemotherapy drugs for Rhode Island residents by care location in Rhode Island, Massachusetts, and Connecticut. Users can compare total spending, units, payment per unit, and identify the 20 Chemotherapy drugs that account for the largest share of total spend. This report also shows the top 10 diagnoses associated with Chemotherapy treatment and compares payment per unit (PPU) by care location (city and state) in RI, MA, and CT. Chemotherapy treatments typically occur in an outpatient institutional or professional office setting and are defined by “J Codes.” Results are based on analysis of claims data for commercial insurance plans, Medicaid, and Medicare. 

This report allows users to compare spending and utilization for Emergency Department visits by named Rhode Island hospital. Emergency Department visits are grouped using Current Procedural Terminology (CPT) codes reflecting increasing levels of presenting problem severity and treatment intensity. CPT code 99281 is assigned to ED visits for low severity presenting problems that can be addressed using relatively simple medical interventions. Codes 99282 through 99285 are used for more serious ED visits and require a medically appropriate health history and exam. These codes capture increasing intensity of needed medical intervention based on the number and complexity of presenting problems and risk of complications, morbidity, or mortality. CPT codes 99284 and 99285 are applied to the most complex ED visits requiring the highest levels of medical decision making and number and intensity of services to address. 
 

This dashboard utilizes the CMS Chronic Conditions Data Warehouse (CCW) categories to group chronic conditions and highlight variation to help identify opportunities to reduce costs and improve the quality of care for chronically ill patients.
 

This dashboard compares utilization and spending for hospital provided services based on Diagnosis Related Groups (DRGs). To help facilitate meaningful comparisons, DRGs are assigned and used to categorize hospital inpatient visits based on severity of illness, risk of mortality, medical prognosis, need for intervention, and intensity of resource use in treating patients. Each DRG falls within a Major Diagnostic Category (MDC). MDCs organize illnesses into 25 mutually exclusive groups based on principal diagnoses and by medical specialty and organ system or etiology. MDCs and DRGs were assigned using the 3M All Patient Refined Diagnosis Related Groups (APR DRG) software.