Data extraction from electronic health records - existing tools may be unreliable and potentially unsafe.
BACKGROUND
The increasing use of routinely collected data in electronic health record (EHR) systems for business analytics, quality improvement and research requires an extraction process fit for purpose. Little is known about the quality of EHR data extracts. We examined the accuracy of three data extraction tools (DETs) with two EHR systems in Australia.


METHODS
The hardware, software environment and extraction instructions were kept the same for the extraction of relevant demographic and clinical data for all active patients with diabetes. The counts of identified patients and their demographic and clinical information were compared by EHR and DET.


RESULTS
The DETs identified different numbers of diabetics and measures of quality of care under the same conditions.


CONCLUSIONS
Current DETs are not reliable and potentially unsafe. Proprietary EHRs and DETs must support transparency and independent testing with standardised queries. Quality control within an appropriate policy and legislative environment is essential.
PhD, FRACGP, FACHI, is Professor of General Practice, University of New South Wales and Director, General Practice Unit, South West Sydney Local Health District, New South Wales.
Siaw-Teng
ST
Liaw
Jane
J
Taggart
Hairong
H
Yu
Simon
S
de Lusignan
D001315:Australia; D003625:Data Collection; D003920:Diabetes Mellitus / Q000175:diagnosis*; D006801:Humans; D016347:Medical Records Systems, Computerized / Q000592:standards*; D011787:Quality of Health Care; D012984:Software