Frequency-Based Prioritization of ICD-10-CA/CCI to OMOP Mapping in a Canadian Hospital Data Warehouse: Coverage and...

Area of Science:

• Health Informatics
• Clinical Data Management
• Biomedical Data Standards

Background:

• The secondary use of health data in Canada necessitates mapping local terminologies to standardized formats.
• The OMOP Common Data Model (CDM) is increasingly adopted for health data interoperability.
• Local Canadian codes like ICD-10-CA and Canadian Classification of Health Interventions (CCI) require mapping to the OMOP CDM.

Purpose of the Study:

• To evaluate the coverage of ICD-10-CA and CCI codes within the McGill University Health Centre (MUHC) dataset.
• To assess the performance of the Usagi tool in mapping these local codes to OMOP standard concepts.
• To determine the resources required for comprehensive data mapping and interoperability.

Main Methods:

• Analysis of McGill University Health Centre (MUHC) data from 2024.
• Utilizing the Usagi tool for mapping local ICD-10-CA and CCI codes to OMOP standard concepts.
• Statistical analysis to evaluate mapping performance and code coverage.

Main Results:

• Mapping 1,015 ICD-10-CA codes (6.5%) achieved 99.1% diagnostic coverage.
• Mapping 481 CCI codes (2.8%) achieved 80% hospital procedure coverage.
• Usagi tool performance showed significantly higher scores with longer code labels (p < 0.001), but automatic adoption requires expert validation.

Conclusions:

• A small subset of ICD-10-CA and CCI codes provides substantial coverage for diagnoses and procedures.
• The Usagi tool aids mapping but requires expert clinical validation for reliable implementation.
• A prioritized, collaborative mapping strategy is essential for efficient resource utilization and Canadian health data interoperability within OMOP.