ABSTRACT
Objective: To describe the reusable transformation process of electronic health records (EHR), claims, and prescriptions data into Observational Medical Outcome Partnership (OMOP) Common Data Model (CDM), together with challenges faced and solutions implemented. Materials and Methods: We used Estonian national health databases that store almost all residents' claims, prescriptions, and EHR records. To develop and demonstrate the transformation process of Estonian health data to OMOP CDM, we used a 10% random sample of the Estonian population (n = 150 824 patients) from 2012 to 2019 (MAITT dataset). For the sample, complete information from all 3 databases was converted to OMOP CDM version 5.3. The validation was performed using open-source tools. Results: In total, we transformed over 100 million entries to standard concepts using standard OMOP vocabularies with the average mapping rate 95%. For conditions, observations, drugs, and measurements, the mapping rate was over 90%. In most cases, SNOMED Clinical Terms were used as the target vocabulary. Discussion: During the transformation process, we encountered several challenges, which are described in detail with concrete examples and solutions. Conclusion: For a representative 10% random sample, we successfully transferred complete records from 3 national health databases to OMOP CDM and created a reusable transformation process. Our work helps future researchers to transform linked databases into OMOP CDM more efficiently, ultimately leading to better real-world evidence.
ABSTRACT
COVID-19 and other acute respiratory viruses can have a long-term impact on health. We aimed to assess the common features and differences in the post-acute phase of COVID-19 compared with other non-chronic respiratory infections (RESP) using population-based electronic health data. We applied the self-controlled case series method where prescription drugs and health care utilisation were used as indicators of health outcomes during the six-month-long post-acute period. The incidence rate ratios of COVID-19 and RESP groups were compared. The analysis included 146 314 individuals. Out of 5452 drugs analysed, 14 had increased administration after COVID-19 with drugs for cardiovascular diseases (trimetazidine, metoprolol, rosuvastatin) and psychotropic drugs (alprazolam, zolpidem, melatonin) being most prevalent. The health impact of COVID-19 was more apparent among females and individuals with non-severe COVID-19. The increased risk of exacerbating pre-existing conditions was observed for the COVID-19 group. COVID-19 vaccination did not have effect on drug prescriptions but lowered the health care utilisation during post-acute period. Compared with RESP, COVID-19 increased the use of outpatient services during the post-infection period. The long-term negative impact of COVID-19 on life quality must be acknowledged, and supportive health care and public health services provided.