Skip to main content
medRxiv
  • Home
  • About
  • Submit
  • ALERTS / RSS
Advanced Search

Tools for categorization of diagnostic codes in hospital data: Operationalizing CCSR into a patient data repository

Sarah Malecki, Anne Loffler, Daniel Tamming, Michael Fralick, Shahmir Sohail, Jiamin Shi, Surain Roberts, Michael Colacci, Fahad Razak, Amol Verma
doi: https://doi.org/10.1101/2022.11.29.22282888
Sarah Malecki
1Department of Medicine, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Anne Loffler
2St. Michael’s Hospital, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Daniel Tamming
2St. Michael’s Hospital, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Michael Fralick
3Division of General Internal Medicine, Sinai Health, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Shahmir Sohail
1Department of Medicine, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Jiamin Shi
2St. Michael’s Hospital, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Surain Roberts
2St. Michael’s Hospital, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Michael Colacci
1Department of Medicine, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Fahad Razak
2St. Michael’s Hospital, University of Toronto, Toronto, ON, Canada
4Institute of Health Policy, Management, and Evaluation, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Amol Verma
2St. Michael’s Hospital, University of Toronto, Toronto, ON, Canada
4Institute of Health Policy, Management, and Evaluation, University of Toronto, Toronto, ON, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • For correspondence: amol.verma@mail.utoronto.ca
  • Abstract
  • Full Text
  • Info/History
  • Metrics
  • Data/Code
  • Preview PDF
Loading

Abstract

Background The Clinical Classification Software refined version (CCSR) is a tool to aggregate International Classification of Diseases, 10th Revision, Clinical Modification/Procedure Coding System (ICD-10-CM/PCS) diagnosis codes into clinically meaningful categories. ICD-10-CM/PCS codes are primarily used in the United States and the tool has not been optimized for use with other country-specific ICD-10 coding systems.

Method We developed an automated procedure for mapping Canadian ICD-10 codes (ICD-10-CA) to CCSR categories using discharge diagnosis data from adult medical hospitalizations at 7 hospitals between Apr 1 2010 and Dec 31 2020, and manually validated the results.

Results There were 383,972 Canadian hospital admissions with 5,186 distinct ICD-10 discharge diagnosis codes. Only 46.6% of ICD-10-CA codes could be mapped directly to CCSR categories. Our algorithm improved mapping of hospital codes to CCSR categories to 98.2%. Validation of the algorithm demonstrated a high degree of accuracy with strong interrater agreement (observed proportionate agreement of 0.98). The algorithm was critical for mapping the majority of diagnosis codes associated with heart failure (96.6%), neurocognitive disorders (96.0%), skin and subcutaneous tissue infections (97.2%), and epilepsy (92.5%).

Conclusion Our algorithm for operationalizing CCSR into a patient data repository (https://github.com/GEMINI-Medicine/gemini-ccsr) has been validated for use with Canadian ICD-10 codes and may be useful to clinicians and researchers from diverse geographic locations.

Competing Interest Statement

The authors have declared no competing interest.

Funding Statement

This study was funded by the NDRIO-Portage COVID-19 Data Curation Funding and Digital Research Alliance of Canada Data Champion Pilot Project. The development of the GEMINI data platform has been supported with funding from the Canadian Cancer Society, the Canadian Frailty Network, the Canadian Institutes of Health Research, the Canadian Medical Protective Association, Green Shield Canada Foundation, the Natural Sciences and Engineering Research Council of Canada, Ontario Health, the St. Michael's Hospital Association Innovation Fund, and the University of Toronto Department of Medicine, with in-kind support from partner hospitals and Vector Institute. Funders had no role in the design, conduct or interpretation of this study.

Author Declarations

I confirm all relevant ethical guidelines have been followed, and any necessary IRB and/or ethics committee approvals have been obtained.

Yes

The details of the IRB/oversight body that provided approval or exemption for the research described are given below:

Research ethics board approval was obtained from the University Health Network (Toronto), Sunnybrook Health Sciences Centre (Toronto) and St. Michael's Hospital (Toronto) through the integrated Clinical Trials Ontario platform, with St. Michael's Hospital as the Board of Record (CTO project ID: 1394). Research ethics board approval was also obtained from Trillium Health Partners (Mississauga; REB# 742) and Mount Sinai Hospital (Toronto; REB# 15-0075-C)

I confirm that all necessary patient/participant consent has been obtained and the appropriate institutional forms have been archived, and that any patient/participant/sample identifiers included were not known to anyone (e.g., hospital staff, patients or participants themselves) outside the research group so cannot be used to identify individuals.

Yes

I understand that all clinical trials and any other prospective interventional studies must be registered with an ICMJE-approved registry, such as ClinicalTrials.gov. I confirm that any such study reported in the manuscript has been registered and the trial registration ID is provided (note: if posting a prospective study registered retrospectively, please provide a statement in the trial ID field explaining why the study was not registered in advance).

Yes

I have followed all appropriate research reporting guidelines and uploaded the relevant EQUATOR Network research reporting checklist(s) and other pertinent material as supplementary files, if applicable.

Yes

Footnotes

  • Funding Statement: This study was funded by the NDRIO-Portage COVID-19 Data Curation Funding and Digital Research Alliance of Canada Data Champion Pilot Project. The development of the GEMINI data platform has been supported with funding from the Canadian Cancer Society, the Canadian Frailty Network, the Canadian Institutes of Health Research, the Canadian Medical Protective Association, Green Shield Canada Foundation, the Natural Sciences and Engineering Research Council of Canada, Ontario Health, the St. Michael’s Hospital Association Innovation Fund, and the University of Toronto Department of Medicine, with in-kind support from partner hospitals and Vector Institute. Funders had no role in the design, conduct or interpretation of this study.

  • Ethics Approval: Research ethics board approval was obtained from the University Health Network (Toronto), Sunnybrook Health Sciences Centre (Toronto) and St. Michael’s Hospital (Toronto) through the integrated Clinical Trials Ontario platform, with St. Michael’s Hospital as the Board of Record (CTO project ID: 1394). Research ethics board approval was also obtained from Trillium Health Partners (Mississauga; REB# 742) and Mount Sinai Hospital (Toronto; REB# 15-0075-C).

Data Availability

Data from this manuscript can be accessed upon request to the corresponding author, to the extent that is possible in compliance with local research ethics board requirements and data sharing agreements.

Copyright 
The copyright holder for this preprint is the author/funder, who has granted medRxiv a license to display the preprint in perpetuity. All rights reserved. No reuse allowed without permission.
Back to top
PreviousNext
Posted November 30, 2022.
Download PDF
Data/Code
Email

Thank you for your interest in spreading the word about medRxiv.

NOTE: Your email address is requested solely to identify you as the sender of this article.

Enter multiple addresses on separate lines or separate them with commas.
Tools for categorization of diagnostic codes in hospital data: Operationalizing CCSR into a patient data repository
(Your Name) has forwarded a page to you from medRxiv
(Your Name) thought you would like to see this page from the medRxiv website.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Share
Tools for categorization of diagnostic codes in hospital data: Operationalizing CCSR into a patient data repository
Sarah Malecki, Anne Loffler, Daniel Tamming, Michael Fralick, Shahmir Sohail, Jiamin Shi, Surain Roberts, Michael Colacci, Fahad Razak, Amol Verma
medRxiv 2022.11.29.22282888; doi: https://doi.org/10.1101/2022.11.29.22282888
Reddit logo Twitter logo Facebook logo LinkedIn logo Mendeley logo
Citation Tools
Tools for categorization of diagnostic codes in hospital data: Operationalizing CCSR into a patient data repository
Sarah Malecki, Anne Loffler, Daniel Tamming, Michael Fralick, Shahmir Sohail, Jiamin Shi, Surain Roberts, Michael Colacci, Fahad Razak, Amol Verma
medRxiv 2022.11.29.22282888; doi: https://doi.org/10.1101/2022.11.29.22282888

Citation Manager Formats

  • BibTeX
  • Bookends
  • EasyBib
  • EndNote (tagged)
  • EndNote 8 (xml)
  • Medlars
  • Mendeley
  • Papers
  • RefWorks Tagged
  • Ref Manager
  • RIS
  • Zotero
  • Tweet Widget
  • Facebook Like
  • Google Plus One

Subject Area

  • Health Informatics
Subject Areas
All Articles
  • Addiction Medicine (227)
  • Allergy and Immunology (500)
  • Anesthesia (110)
  • Cardiovascular Medicine (1226)
  • Dentistry and Oral Medicine (205)
  • Dermatology (147)
  • Emergency Medicine (282)
  • Endocrinology (including Diabetes Mellitus and Metabolic Disease) (526)
  • Epidemiology (9990)
  • Forensic Medicine (5)
  • Gastroenterology (496)
  • Genetic and Genomic Medicine (2430)
  • Geriatric Medicine (236)
  • Health Economics (479)
  • Health Informatics (1632)
  • Health Policy (750)
  • Health Systems and Quality Improvement (632)
  • Hematology (247)
  • HIV/AIDS (528)
  • Infectious Diseases (except HIV/AIDS) (11840)
  • Intensive Care and Critical Care Medicine (623)
  • Medical Education (250)
  • Medical Ethics (73)
  • Nephrology (267)
  • Neurology (2266)
  • Nursing (139)
  • Nutrition (348)
  • Obstetrics and Gynecology (449)
  • Occupational and Environmental Health (532)
  • Oncology (1241)
  • Ophthalmology (375)
  • Orthopedics (133)
  • Otolaryngology (226)
  • Pain Medicine (154)
  • Palliative Medicine (50)
  • Pathology (324)
  • Pediatrics (727)
  • Pharmacology and Therapeutics (311)
  • Primary Care Research (280)
  • Psychiatry and Clinical Psychology (2272)
  • Public and Global Health (4814)
  • Radiology and Imaging (832)
  • Rehabilitation Medicine and Physical Therapy (486)
  • Respiratory Medicine (649)
  • Rheumatology (283)
  • Sexual and Reproductive Health (237)
  • Sports Medicine (224)
  • Surgery (266)
  • Toxicology (44)
  • Transplantation (123)
  • Urology (99)