title: Data extraction from a semi-structured electronic medical record system for outpatients: a model to facilitate the access and use of data for quality control and research.
abstract: The use of clinical data from electronic medical records (EMRs) for clinical research and for evaluation of quality of care requires an extraction process. Many efforts have failed because the extracted data seemed to be unstructured, incomplete and ridden by errors. We have developed and tested a concept of extracting semi-structured EMRs (Journal III, Profdoc) data from 776 diabetes patients in a general practice clinic over a 5 year period. We used standard database management techniques commonly applied in clinical research in the pharmaceutical industry to clean up the data and make the data available for statistical analysis. The key problem was difficulties locating the data, as no standard way to enter the data in the EMR system was reinforced. Furthermore, no built-in edit checks to facilitate data entry were available. Laboratory, drug information and diagnostic data could be used directly while other data such as vital signs required much work to locate and become useful.
authors.affiliation: Division of Clinical Pharmacology, Department of Laboratory Medicine, Karolinska Institute, Karolinska University Hospital, Huddinge, Sweden. Krister@Kristianson.com
authors.forename: Krister J
authors.initials: KJ
authors.lastname: Kristianson
authors.forename: Henrik
authors.initials: H
authors.lastname: Ljunggren
authors.forename: Lars L
authors.initials: LL
authors.lastname: Gustafsson
mesh_terms: D022126:Access to Information; D000959:Antihypertensive Agents / Q000627:therapeutic use; D015992:Body Mass Index; D001835:Body Weight; D057225:Data Mining / Q000379:methods; D003628:Database Management Systems; D003920:Diabetes Mellitus; D057286:Electronic Health Records; D005194:Family Practice / Q000706:statistics & numerical data; D006801:Humans; D016347:Medical Records Systems, Computerized / Q000592:standards; D011786:Quality Control
chemical_list: D000959:Antihypertensive Agents