HCE2RNFC: An Efficient Methodology for Reusing the EHR in the Spanish National Hip Fracture Registry.

Hip fracture is a condition associated with ageing and frailty, with an associated prevalence of 7 per 10000 population in Spain. Evidence suggests that factors in the healthcare process can influence clinical outcomes, so the creation of a national registry is an opportunity to monitor and improve this process. In this regards, Electronic Health Record (EHR) can provide a large amount of data, that can be used to populate the Spanish National Hip Fracture Registry (RNFC, by its acronym in Spanish). However, this reuse of the EHR requires a prior effort in modelling and standardization to build the extraction, transformation, and loading (ETL) processes in a flexible, transparent, and scalable manner. In this work, a robust EHR reuse methodology is implemented to obtain EHR-derived data for the RNFC. The main result of this work was the design and implementation of an EHR data reuse methodology, which was able to load 1279 hip fracture cases and almost 68% of the required concepts from the RNFC.

TransformEHRs: a flexible methodology for building transparent ETL processes for EHR reuse.

BACKGROUND: During the COVID-19 pandemic, several methodologies were designed for obtaining electronic health record (EHR)-derived datasets for research. These processes are often based on black boxes, on which clinical researchers are unaware of how the data were recorded, extracted, and transformed. In order to solve this, it is essential that extract, transform, and load (ETL) processes are based on transparent, homogeneous, and formal methodologies, making them understandable, reproducible, and auditable. OBJECTIVES: This study aims to design and implement a methodology, according with FAIR Principles, for building ETL processes (focused on data extraction, selection, and transformation) for EHR reuse in a transparent and flexible manner, applicable to any clinical condition and health care organization. METHODS: The proposed methodology comprises four stages: (1) analysis of secondary use models and identification of data operations, based on internationally used clinical repositories, case report forms, and aggregated datasets; (2) modeling and formalization of data operations, through the paradigm of the Detailed Clinical Models; (3) agnostic development of data operations, selecting SQL and R as programming languages; and (4) automation of the ETL instantiation, building a formal configuration file with XML. RESULTS: First, four international projects were analyzed to identify 17 operations, necessary to obtain datasets according to the specifications of these projects from the EHR. With this, each of the data operations was formalized, using the ISO 13606 reference model, specifying the valid data types as arguments, inputs and outputs, and their cardinality. Then, an agnostic catalog of data was developed through data-oriented programming languages previously selected. Finally, an automated ETL instantiation process was built from an ETL configuration file formally defined. CONCLUSIONS: This study has provided a transparent and flexible solution to the difficulty of making the processes for obtaining EHR-derived data for secondary use understandable, auditable, and reproducible. Moreover, the abstraction carried out in this study means that any previous EHR reuse methodology can incorporate these results into them.

Making EHRs Trustable: A Quality Analysis of EHR-Derived Datasets for COVID-19 Research.

One approach to verifying the quality of research data obtained from EHRs is auditing how complete and correct the data are in comparison with those collected by manual and controlled methods. This study analyzed data quality of an EHR-derived dataset for COVID-19 research, obtained during the pandemic at Hospital Universitario 12 de Octubre. Data were extracted from EHRs and a manually collected research database, and then transformed into the ISARIC-WHO COVID-19 CRF model. Subsequently, a data analysis was performed, comparing both sources through this convergence model. More concepts and records were obtained from EHRs, and PPV (95% CI) was above 85% in most sections. In future studies, a more detailed analysis of data quality will be carried out.