Fruchart Mathilde, Quindroit Paul, Jacquemont Chloé, Beuscart Jean-Baptiste, Calafiore Matthieu, Lamer Antoine
Univ Lille, CHU Lille, ULR 2694 - METRICS: Évaluation des Technologies de santé et des, Pratiques médicales, 2 Place de Verdun, Lille, F-59000, France.
Département de Médecine Générale, University of Lille, Lille, France.
JMIR Med Inform. 2024 Aug 13;12:e49542. doi: 10.2196/49542.
Patient-monitoring software generates a large amount of data that can be reused for clinical audits and scientific research. The Observational Health Data Sciences and Informatics (OHDSI) consortium developed the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) to standardize electronic health record data and promote large-scale observational and longitudinal research.
This study aimed to transform primary care data into the OMOP CDM format.
We extracted primary care data from electronic health records at a multidisciplinary health center in Wattrelos, France. We performed structural mapping between the design of our local primary care database and the OMOP CDM tables and fields. Local French vocabularies concepts were mapped to OHDSI standard vocabularies. To validate the implementation of primary care data into the OMOP CDM format, we applied a set of queries. A practical application was achieved through the development of a dashboard.
Data from 18,395 patients were implemented into the OMOP CDM, corresponding to 592,226 consultations over a period of 20 years. A total of 18 OMOP CDM tables were implemented. A total of 17 local vocabularies were identified as being related to primary care and corresponded to patient characteristics (sex, location, year of birth, and race), units of measurement, biometric measures, laboratory test results, medical histories, and drug prescriptions. During semantic mapping, 10,221 primary care concepts were mapped to standard OHDSI concepts. Five queries were used to validate the OMOP CDM by comparing the results obtained after the completion of the transformations with the results obtained in the source software. Lastly, a prototype dashboard was developed to visualize the activity of the health center, the laboratory test results, and the drug prescription data.
Primary care data from a French health care facility have been implemented into the OMOP CDM format. Data concerning demographics, units, measurements, and primary care consultation steps were already available in OHDSI vocabularies. Laboratory test results and drug prescription data were mapped to available vocabularies and structured in the final model. A dashboard application provided health care professionals with feedback on their practice.
患者监测软件会生成大量数据，这些数据可重新用于临床审计和科学研究。观察性健康数据科学与信息学（OHDSI）联盟开发了观察性医疗结局合作组织（OMOP）通用数据模型（CDM），以规范电子健康记录数据并促进大规模观察性和纵向研究。
本研究旨在将初级保健数据转换为OMOP CDM格式。
我们从法国瓦特勒洛的一个多学科健康中心的电子健康记录中提取初级保健数据。我们在本地初级保健数据库的设计与OMOP CDM表和字段之间进行了结构映射。将法国本地词汇概念映射到OHDSI标准词汇。为了验证将初级保健数据实施到OMOP CDM格式中的情况，我们应用了一组查询。通过开发一个仪表板实现了实际应用。
来自18395名患者的数据被实施到OMOP CDM中，对应于20年期间的592226次会诊。总共实施了18个OMOP CDM表。总共确定了17个与初级保健相关的本地词汇，它们对应于患者特征（性别、地点、出生年份和种族）、测量单位、生物特征测量、实验室检查结果、病史和药物处方。在语义映射过程中，10221个初级保健概念被映射到标准的OHDSI概念。通过将转换完成后获得的结果与源软件中获得的结果进行比较，使用五个查询来验证OMOP CDM。最后，开发了一个原型仪表板，以可视化健康中心的活动、实验室检查结果和药物处方数据。
来自法国一家医疗保健机构的初级保健数据已被实施到OMOP CDM格式中。OHDSI词汇中已经包含了有关人口统计学、单位、测量和初级保健会诊步骤的数据。实验室检查结果和药物处方数据被映射到可用词汇中，并在最终模型中进行了结构化。一个仪表板应用程序为医疗保健专业人员提供了有关其执业情况的反馈。
