BACKGROUND: Electronic health records provide clinically rich data for research and quality improvement work. However, the data are often unstructured text, may be inconsistently recorded and extracted into centralized databases, making them difficult to use for research. OBJECTIVES: We sought to quantify the variation in how key laboratory measures are recorded in the Department of Veterans Affairs (VA) Corporate Data Warehouse (CDW) across hospitals and over time. We included 6 laboratory tests commonly drawn within the first 24 hours of hospital admission (albumin, bilirubin, creatinine, hemoglobin, sodium, white blood cell count) from fiscal years 2005-2015. RESULTS: We assessed laboratory test capture for 5,454,411 acute hospital admissions at 121 sites across the VA. The mapping of standardized laboratory nomenclature (Logical Observation Identifiers Names and Codes, LOINCs) to test results in CDW varied within hospital by laboratory test. The relationship between LOINCs and laboratory test names improved over time; by FY2015, 109 (95.6%) hospitals had >90% of the 6 laboratory tests mapped to an appropriate LOINC. All fields used to classify test results are provided in an Appendix (Supplemental Digital Content 1, http://links.lww.com/MLR/B635). CONCLUSIONS: The use of electronic health record data for research requires assessing data consistency and quality. Using laboratory test results requires the use of both unstructured text fields and the identification of appropriate LOINCs. When using data from multiple facilities, the results should be carefully examined by facility and over time to maximize the capture of data fields.
BACKGROUND: Electronic health records provide clinically rich data for research and quality improvement work. However, the data are often unstructured text, may be inconsistently recorded and extracted into centralized databases, making them difficult to use for research. OBJECTIVES: We sought to quantify the variation in how key laboratory measures are recorded in the Department of Veterans Affairs (VA) Corporate Data Warehouse (CDW) across hospitals and over time. We included 6 laboratory tests commonly drawn within the first 24 hours of hospital admission (albumin, bilirubin, creatinine, hemoglobin, sodium, white blood cell count) from fiscal years 2005-2015. RESULTS: We assessed laboratory test capture for 5,454,411 acute hospital admissions at 121 sites across the VA. The mapping of standardized laboratory nomenclature (Logical Observation Identifiers Names and Codes, LOINCs) to test results in CDW varied within hospital by laboratory test. The relationship between LOINCs and laboratory test names improved over time; by FY2015, 109 (95.6%) hospitals had >90% of the 6 laboratory tests mapped to an appropriate LOINC. All fields used to classify test results are provided in an Appendix (Supplemental Digital Content 1, http://links.lww.com/MLR/B635). CONCLUSIONS: The use of electronic health record data for research requires assessing data consistency and quality. Using laboratory test results requires the use of both unstructured text fields and the identification of appropriate LOINCs. When using data from multiple facilities, the results should be carefully examined by facility and over time to maximize the capture of data fields.
Authors: Xiao Qing Wang; Brenda M Vincent; Wyndy L Wiitala; Kaitlyn A Luginbill; Elizabeth M Viglianti; Hallie C Prescott; Theodore J Iwashyna Journal: BMC Med Res Methodol Date: 2019-05-08 Impact factor: 4.615
Authors: Richard Evans; Jennifer Burns; Laura Damschroder; Ann Annis; Michelle B Freitag; Susan Raffa; Wyndy Wiitala Journal: JMIR Med Inform Date: 2022-03-09