RT Journal Article SR Electronic T1 Tools for categorization of diagnostic codes in hospital data: Operationalizing CCSR into a patient data repository JF medRxiv FD Cold Spring Harbor Laboratory Press SP 2022.11.29.22282888 DO 10.1101/2022.11.29.22282888 A1 Sarah Malecki A1 Anne Loffler A1 Daniel Tamming A1 Michael Fralick A1 Shahmir Sohail A1 Jiamin Shi A1 Surain Roberts A1 Michael Colacci A1 Fahad Razak A1 Amol Verma YR 2022 UL http://medrxiv.org/content/early/2022/11/30/2022.11.29.22282888.abstract AB 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 StatementThe authors have declared no competing interest.Funding StatementThis 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 DeclarationsI confirm all relevant ethical guidelines have been followed, and any necessary IRB and/or ethics committee approvals have been obtained.YesThe 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.YesI 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).YesI 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.YesData 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.