Mapping Emergency Medicine Data to the Observational Medical Outcomes Partnership Common Data Model: A Gap Analysis...

This study aims to conduct a gap analysis to determine the feasibility of mapping electronic health record data from the Clinical Emergency Data Registry (CEDR) to the Observational Medical Outcomes Partnership Common Data Model (OMOP-CDM).

We employed a structured approach using a custom-built comparison matrix. This matrix facilitated the alignment of CEDR data fields with the corresponding elements in the OMOP-CDM schema. Each field was evaluated for compatibility, with categorization into 3 distinct types: direct matches, fields requiring transformation, and fields with no OMOP-CDM equivalent. The mapping process was informed by consultations with the Observational Health Data Sciences and Informatics community forums and was guided by existing documentation and best practices in data harmonization. We performed descriptive analyses, quantifying the extent of direct matches and identifying the specific transformations needed for each CEDR-CDM field to ensure compliance with the OMOP-CDM model.

Our analysis indicates a high degree of compatibility between CEDR and OMOP, with over 90% (244/269) of CEDR fields being successfully mapped. Specifically, 173 fields had direct matches, whereas 71 required transformations. Challenges identified include addressing fields unique to CEDR with no OMOP-CDM equivalent and managing the transformations required for proper alignment.

The OMOP-CDM presents a promising framework for standardizing emergency medicine data, thereby enhancing future query automation, analytics, and cross-institutional collaboration. Despite the potential challenges in capturing unique CEDR fields and addressing necessary transformations, most emergency department data can be standardized within the OMOP-CDM, fostering broader insights and applications in research and public health.