A Dashboard Prototype for Tracking the Impact of Diabetes on Hospital Readmissions Using a National Administrative Database

Timothy Wong, Ethan Y. Brovman, Nikhilesh Rao, Mitchell H. Tsai, Richard D. Urman


Background: Over the past several decades, diabetes mellitus has contributed to a significant disease burden in the general population. Evidence suggests that patients with a coexisting diabetes diagnosis consume more hospital resources, and have higher readmission rates compared to those who do not. Against the backdrop of bundled-payment programs, healthcare systems cannot underestimate the importance of monitoring patient health information at the population level.

Methods: Using the data from the Centers for Medicare and Medicaid Services (CMS) administrative claims database, we created a dashboard prototype to enable hospitals to examine the impact of diabetes on their all-cause readmission rates and financial implications if diabetes was present at the index hospitalization. The technical design involved loading the relevant 10th revision of International Classification of Diseases (ICD-10) codes provided by the medical team and flagging diabetes patients at the claim. These patients were then tagged for readmissions within the same database. The odds ratios were determined based on data from two groups: those with diabetes at index hospitalization which include type 1 only, type 2 only, and type 1 and type 2 diabetes, plus those without diabetes at index hospitalization.

Results: The dashboard presents summary data of diabetes readmissions quality metrics at a national level. Users can visualize summary data of each state and compare odds ratios for readmissions as well as raw hospitalization data at their facility. Dashboard users can also view data classified by a diagnosis-related group (DRG) system. In addition to a “national” data view, for users who inquire about data specific to demographic regions, the DRG view can be further stratified at the state level or county level. At the DRG level, users can view data about the cost per readmissions for all index hospitalization with and without diabetes.

Conclusions: The dashboard prototype offers users a virtual interface which displays visual data for quick interpretation, monitors changes at a population level, and enables administrators to benchmark facility data against local and national trends. This is an important step in using data analytics to drive population level decision making to ultimately improve medical systems.

J Clin Med Res. 2020;12(1):18-25
doi: https://doi.org/10.14740/jocmr4029


Diabetes; Complications; Dashboard; Information systems; Admission; Morbidity

Full Text: HTML PDF

Browse  Journals  


Journal of Clinical Medicine Research

Journal of Endocrinology and Metabolism

Journal of Clinical Gynecology and Obstetrics


World Journal of Oncology

Gastroenterology Research

Journal of Hematology


Journal of Medical Cases

Journal of Current Surgery

Clinical Infection and Immunity


Cardiology Research

World Journal of Nephrology and Urology

Cellular and Molecular Medicine Research


Journal of Neurology Research

International Journal of Clinical Pediatrics



Journal of Clinical Medicine Research, monthly, ISSN 1918-3003 (print), 1918-3011 (online), published by Elmer Press Inc.                     
The content of this site is intended for health care professionals.
This is an open-access journal distributed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License, which permits unrestricted
non-commercial use, distribution, and reproduction in any medium, provided the original work is properly cited.
Creative Commons Attribution license (Attribution-NonCommercial 4.0 International CC-BY-NC 4.0)

This journal follows the International Committee of Medical Journal Editors (ICMJE) recommendations for manuscripts submitted to biomedical journals,
the Committee on Publication Ethics (COPE) guidelines, and the Principles of Transparency and Best Practice in Scholarly Publishing.

website: www.jocmr.org   editorial contact: editor@jocmr.org
Address: 9225 Leslie Street, Suite 201, Richmond Hill, Ontario, L4B 3H6, Canada

© Elmer Press Inc. All Rights Reserved.

Disclaimer: The views and opinions expressed in the published articles are those of the authors and do not necessarily reflect the views or opinions of the editors and Elmer Press Inc. This website is provided for medical research and informational purposes only and does not constitute any medical advice or professional services. The information provided in this journal should not be used for diagnosis and treatment, those seeking medical advice should always consult with a licensed physician.