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.