Transforming Primary Care Data Into the Observational Medical Outcomes Partnership Common Data Model: Development and...

Area of Science:

• Health Informatics
• Observational Health Data Sciences
• Electronic Health Records

Background:

• Patient monitoring software generates vast amounts of reusable data for research and audits.
• The Observational Health Data Sciences and Informatics (OHDSI) consortium developed the OMOP Common Data Model (CDM) to standardize EHR data.
• Standardization facilitates large-scale observational and longitudinal research.

Purpose of the Study:

• To transform primary care data into the OMOP CDM format.
• To enable secondary use of primary care data for research and clinical audits.
• To develop a practical application for visualizing transformed data.

Main Methods:

• Extracted primary care data from a French multidisciplinary health center.
• Performed structural and semantic mapping of local data to OMOP CDM tables and OHDSI standard vocabularies.
• Validated the OMOP CDM implementation using queries and developed a prototype dashboard.

Main Results:

• 18,395 patients' data (592,226 consultations) were implemented into 18 OMOP CDM tables over 20 years.
• 10,221 local primary care concepts were mapped to 17 OHDSI standard vocabularies.
• A dashboard was developed to visualize health center activity, lab results, and prescriptions.

Conclusions:

• Primary care data from a French facility were successfully implemented into the OMOP CDM.
• Demographics, measurements, and consultation steps were mapped to existing OHDSI vocabularies.
• Lab results and prescriptions were structured in the OMOP CDM, and a dashboard provided practice feedback.