Skip to main content

Electronic clinical laboratory test results data tables: lessons from Mini-Sentinel.

Publication ,  Journal Article
Raebel, MA; Haynes, K; Woodworth, TS; Saylor, G; Cavagnaro, E; Coughlin, KO; Curtis, LH; Weiner, MG; Archdeacon, P; Brown, JS
Published in: Pharmacoepidemiol Drug Saf
June 2014

PURPOSE: Developing electronic clinical data into a common data model posed substantial challenges unique from those encountered with administrative data. We present here the design, implementation, and use of the Mini-Sentinel Distributed Database laboratory results table (LRT). METHODS: We developed the LRT and guided Mini-Sentinel data partners (DPs) in populating it from their source data. Data sources included electronic health records and internal and contracted clinical laboratory systems databases. We employed the Logical Observation Identifiers, Names, and Codes (LOINC®) results reporting standards. We evaluated transformed results data using data checks and an iterative, ongoing characterization and harmonization process. RESULTS: Key LRT variables included test name, subcategory, specimen source, LOINC, patient location, specimen date and time, result unit, and unique person identifier. Selected blood and urine chemistry, hematology, coagulation, and influenza tests were included. Twelve DPs with outpatient test results participated; four also contributed inpatient test results. As of September 2013, the LRT included 385,516,239 laboratory test results; data are refreshed at least quarterly. LOINC availability and use varied across DP. Multiple data quality and content issues were identified and addressed. CONCLUSION: Developing the LRT brought together disparate data sources with no common coding structure. Clinical laboratory test results obtained during routine healthcare delivery are neither uniformly coded nor documented in a standardized manner. Applying a systematic approach with data harmonization efforts and ongoing oversight and management is necessary for a clinical laboratory results data table to remain valid and useful.

Duke Scholars

Altmetric Attention Stats
Dimensions Citation Stats

Published In

Pharmacoepidemiol Drug Saf

DOI

EISSN

1099-1557

Publication Date

June 2014

Volume

23

Issue

6

Start / End Page

609 / 618

Location

England

Related Subject Headings

  • Sentinel Surveillance
  • Pilot Projects
  • Pharmacology & Pharmacy
  • Humans
  • Electronic Health Records
  • Databases, Factual
  • Clinical Laboratory Information Systems
  • 4202 Epidemiology
  • 3214 Pharmacology and pharmaceutical sciences
  • 1117 Public Health and Health Services
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Raebel, M. A., Haynes, K., Woodworth, T. S., Saylor, G., Cavagnaro, E., Coughlin, K. O., … Brown, J. S. (2014). Electronic clinical laboratory test results data tables: lessons from Mini-Sentinel. Pharmacoepidemiol Drug Saf, 23(6), 609–618. https://doi.org/10.1002/pds.3580
Raebel, Marsha A., Kevin Haynes, Tiffany S. Woodworth, Gwyn Saylor, Elizabeth Cavagnaro, Kara O. Coughlin, Lesley H. Curtis, Mark G. Weiner, Patrick Archdeacon, and Jeffrey S. Brown. “Electronic clinical laboratory test results data tables: lessons from Mini-Sentinel.Pharmacoepidemiol Drug Saf 23, no. 6 (June 2014): 609–18. https://doi.org/10.1002/pds.3580.
Raebel MA, Haynes K, Woodworth TS, Saylor G, Cavagnaro E, Coughlin KO, et al. Electronic clinical laboratory test results data tables: lessons from Mini-Sentinel. Pharmacoepidemiol Drug Saf. 2014 Jun;23(6):609–18.
Raebel, Marsha A., et al. “Electronic clinical laboratory test results data tables: lessons from Mini-Sentinel.Pharmacoepidemiol Drug Saf, vol. 23, no. 6, June 2014, pp. 609–18. Pubmed, doi:10.1002/pds.3580.
Raebel MA, Haynes K, Woodworth TS, Saylor G, Cavagnaro E, Coughlin KO, Curtis LH, Weiner MG, Archdeacon P, Brown JS. Electronic clinical laboratory test results data tables: lessons from Mini-Sentinel. Pharmacoepidemiol Drug Saf. 2014 Jun;23(6):609–618.

Published In

Pharmacoepidemiol Drug Saf

DOI

EISSN

1099-1557

Publication Date

June 2014

Volume

23

Issue

6

Start / End Page

609 / 618

Location

England

Related Subject Headings

  • Sentinel Surveillance
  • Pilot Projects
  • Pharmacology & Pharmacy
  • Humans
  • Electronic Health Records
  • Databases, Factual
  • Clinical Laboratory Information Systems
  • 4202 Epidemiology
  • 3214 Pharmacology and pharmaceutical sciences
  • 1117 Public Health and Health Services