EUVIMEDEUVIMED entdecken
Open Access

Linking Dispense Data to Electronic Health Orders: Tutorial for Querying Commercial Pharmacy Databases to Support Systemwide Quality Improvement

Benjamin Michaels, Jessica Pourian

Journal of Medical Internet Research · 06.10.2026 · 28 · e90954-e90954

DOI: 10.2196/90954 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Journal of Medical Internet Research, online erschienen am 06.10.2026. Verfasst von Benjamin Michaels und 1 weiteren Autor:innen. Beteiligte Einrichtung: Department of Pharmacy, University of California, San Francisco, 1500 Owens Street, San Francisco, CA, 94158, United States, 1 513 658 0104. Hauptthemen laut MEDLINE: Electronic Health Records, Quality Improvement, Databases, Factual, Pharmacies. Die Arbeit nennt 26 Literaturangaben. Der Volltext ist frei in PubMed Central verfügbar.

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Background

Assessing medication adherence is central to quality care, yet linking electronic health record (EHR) medication orders to outpatient pharmacy dispense data remains technically complex.

Objective

This study aimed to present a generalized, reproducible tutorial for linking EHR medication orders to pharmacy dispense data that can be used to assess medication dispense proportions.

Methods

We developed and validated a structured query approach to link EHR medication orders to external pharmacy dispense data using patient identifiers, medication-level identifiers, pharmacy identifiers, and temporal constraints. The tutorial emphasizes key design decisions, including handling multiple triggering events, deduplication across vendors, and managing formulation changes. A retrospective cohort of pediatric acute otitis media encounters (January 1, 2021, to January 1, 2024) was used as an illustrative example.

Results

Overall, 98.3% (302/307) of pharmacies in the cohort returned at least 1 dispense record during the study period and were therefore classified as reporting pharmacies. Among 3404 orders, 2616 (76.9%) had a recorded dispense.

Conclusions

EHR-integrated pharmacy data provide a feasible, timely proxy for assessing medication adherence. This tutorial provides a scalable framework for linking EHR and pharmacy data for medication adherence studies, while highlighting key methodological considerations for SQL coding.

Schlagwörter

MeSH-Schlagwörter (MEDLINE)

Electronic Health RecordsQuality ImprovementDatabases, FactualPharmaciesHumansRetrospective Studies

Stichwörter der Autor:innen

clinical informaticsdrug prescriptionselectronic health recordhealth information exchangepharmacy information systemsquality improvement

Autor:innen und Institutionen

  • Department of Pharmacy, University of California, San Francisco, 1500 Owens Street, San Francisco, CA, 94158, United States, 1 513 658 0104.
  • Division of Clinical Informatics and Digital Transformation, Department of Pediatrics, University of California, San Francisco, San Francisco, CA, United States.

Zitieren

APA

Michaels, B., & Pourian, J. (2026). Linking Dispense Data to Electronic Health Orders: Tutorial for Querying Commercial Pharmacy Databases to Support Systemwide Quality Improvement. Journal of Medical Internet Research, 28, e90954-e90954. https://doi.org/10.2196/90954

Vancouver

Michaels B, Pourian J. Linking Dispense Data to Electronic Health Orders: Tutorial for Querying Commercial Pharmacy Databases to Support Systemwide Quality Improvement. Journal of Medical Internet Research. 2026;28:e90954-e90954. doi:10.2196/90954

BibTeX
@article{Michaels2026,
  author = {Michaels, Benjamin and Pourian, Jessica},
  title = {Linking Dispense Data to Electronic Health Orders: Tutorial for Querying Commercial Pharmacy Databases to Support Systemwide Quality Improvement},
  journal = {Journal of Medical Internet Research},
  year = {2026},
  volume = {28},
  pages = {e90954--e90954},
  doi = {10.2196/90954}
}
Kostenlos starten →