Using National Drug Codes and drug knowledge bases to organize prescription records from multiple sources

Linas Simonaitis, Clement J. McDonald

Research output: Contribution to journalArticle

4 Citations (Scopus)

Abstract

Purpose. The utility of National Drug Codes (NDCs) and drug knowledge bases (DKBs) in the organization of prescription records from multiple sources was studied. Methods. The master files of most pharmacy systems include NDCs and local codes to identify the products they dispense. We obtained a large sample of prescription records from seven different sources. These records carried a national product code or a local code that could be translated into a national product code via their formulary master. We obtained mapping tables from five DKBs. We measured the degree to which the DKB mapping tables covered the national product codes carried in or associated with the sample of prescription records. Results. Considering the total prescription volume, DKBs covered 93.0-99.8% of the product codes from three outpatient sources and 77.4-97.0% of the product codes from four inpatient sources. Among the inpatient sources, invented codes explained 36-94% of the noncoverage. Outpatient pharmacy sources rarely invented codes, which comprised only 0.11-0.21% of their total prescription volume, compared with inpatient pharmacy sources for which invented codes comprised 1.7-7.4% of their prescription volume. The distribution of prescribed products was highly skewed, with 1.4-4.4% of codes accounting for 50% of the message volume and 10.7-34.5% accounting for 90% of the message volume. Conclusion. DKBs cover the product codes used by outpatient sources sufficiently well to permit automatic mapping. Changes in policies and standards could increase coverage of product codes used by inpatient sources.

Original languageEnglish
Pages (from-to)1743-1753
Number of pages11
JournalAmerican Journal of Health-System Pharmacy
Volume66
Issue number19
DOIs
StatePublished - Oct 1 2009

Fingerprint

Knowledge Bases
Prescriptions
Inpatients
Pharmaceutical Preparations
Outpatients
Formularies
Organizations

Keywords

  • Codes
  • Databases
  • Hospitals
  • National Drug Code
  • Pharmacy, institutional, hospital
  • Records

ASJC Scopus subject areas

  • Pharmacology
  • Health Policy

Cite this

Using National Drug Codes and drug knowledge bases to organize prescription records from multiple sources. / Simonaitis, Linas; McDonald, Clement J.

In: American Journal of Health-System Pharmacy, Vol. 66, No. 19, 01.10.2009, p. 1743-1753.

Research output: Contribution to journalArticle

@article{97c13b186e7349d9bf0fc409cded6ff0,
title = "Using National Drug Codes and drug knowledge bases to organize prescription records from multiple sources",
abstract = "Purpose. The utility of National Drug Codes (NDCs) and drug knowledge bases (DKBs) in the organization of prescription records from multiple sources was studied. Methods. The master files of most pharmacy systems include NDCs and local codes to identify the products they dispense. We obtained a large sample of prescription records from seven different sources. These records carried a national product code or a local code that could be translated into a national product code via their formulary master. We obtained mapping tables from five DKBs. We measured the degree to which the DKB mapping tables covered the national product codes carried in or associated with the sample of prescription records. Results. Considering the total prescription volume, DKBs covered 93.0-99.8{\%} of the product codes from three outpatient sources and 77.4-97.0{\%} of the product codes from four inpatient sources. Among the inpatient sources, invented codes explained 36-94{\%} of the noncoverage. Outpatient pharmacy sources rarely invented codes, which comprised only 0.11-0.21{\%} of their total prescription volume, compared with inpatient pharmacy sources for which invented codes comprised 1.7-7.4{\%} of their prescription volume. The distribution of prescribed products was highly skewed, with 1.4-4.4{\%} of codes accounting for 50{\%} of the message volume and 10.7-34.5{\%} accounting for 90{\%} of the message volume. Conclusion. DKBs cover the product codes used by outpatient sources sufficiently well to permit automatic mapping. Changes in policies and standards could increase coverage of product codes used by inpatient sources.",
keywords = "Codes, Databases, Hospitals, National Drug Code, Pharmacy, institutional, hospital, Records",
author = "Linas Simonaitis and McDonald, {Clement J.}",
year = "2009",
month = "10",
day = "1",
doi = "10.2146/ajhp080221",
language = "English",
volume = "66",
pages = "1743--1753",
journal = "American Journal of Health-System Pharmacy",
issn = "1079-2082",
publisher = "American Society of Health-Systems Pharmacy",
number = "19",

}

TY - JOUR

T1 - Using National Drug Codes and drug knowledge bases to organize prescription records from multiple sources

AU - Simonaitis, Linas

AU - McDonald, Clement J.

PY - 2009/10/1

Y1 - 2009/10/1

N2 - Purpose. The utility of National Drug Codes (NDCs) and drug knowledge bases (DKBs) in the organization of prescription records from multiple sources was studied. Methods. The master files of most pharmacy systems include NDCs and local codes to identify the products they dispense. We obtained a large sample of prescription records from seven different sources. These records carried a national product code or a local code that could be translated into a national product code via their formulary master. We obtained mapping tables from five DKBs. We measured the degree to which the DKB mapping tables covered the national product codes carried in or associated with the sample of prescription records. Results. Considering the total prescription volume, DKBs covered 93.0-99.8% of the product codes from three outpatient sources and 77.4-97.0% of the product codes from four inpatient sources. Among the inpatient sources, invented codes explained 36-94% of the noncoverage. Outpatient pharmacy sources rarely invented codes, which comprised only 0.11-0.21% of their total prescription volume, compared with inpatient pharmacy sources for which invented codes comprised 1.7-7.4% of their prescription volume. The distribution of prescribed products was highly skewed, with 1.4-4.4% of codes accounting for 50% of the message volume and 10.7-34.5% accounting for 90% of the message volume. Conclusion. DKBs cover the product codes used by outpatient sources sufficiently well to permit automatic mapping. Changes in policies and standards could increase coverage of product codes used by inpatient sources.

AB - Purpose. The utility of National Drug Codes (NDCs) and drug knowledge bases (DKBs) in the organization of prescription records from multiple sources was studied. Methods. The master files of most pharmacy systems include NDCs and local codes to identify the products they dispense. We obtained a large sample of prescription records from seven different sources. These records carried a national product code or a local code that could be translated into a national product code via their formulary master. We obtained mapping tables from five DKBs. We measured the degree to which the DKB mapping tables covered the national product codes carried in or associated with the sample of prescription records. Results. Considering the total prescription volume, DKBs covered 93.0-99.8% of the product codes from three outpatient sources and 77.4-97.0% of the product codes from four inpatient sources. Among the inpatient sources, invented codes explained 36-94% of the noncoverage. Outpatient pharmacy sources rarely invented codes, which comprised only 0.11-0.21% of their total prescription volume, compared with inpatient pharmacy sources for which invented codes comprised 1.7-7.4% of their prescription volume. The distribution of prescribed products was highly skewed, with 1.4-4.4% of codes accounting for 50% of the message volume and 10.7-34.5% accounting for 90% of the message volume. Conclusion. DKBs cover the product codes used by outpatient sources sufficiently well to permit automatic mapping. Changes in policies and standards could increase coverage of product codes used by inpatient sources.

KW - Codes

KW - Databases

KW - Hospitals

KW - National Drug Code

KW - Pharmacy, institutional, hospital

KW - Records

UR - http://www.scopus.com/inward/record.url?scp=70349730121&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=70349730121&partnerID=8YFLogxK

U2 - 10.2146/ajhp080221

DO - 10.2146/ajhp080221

M3 - Article

VL - 66

SP - 1743

EP - 1753

JO - American Journal of Health-System Pharmacy

JF - American Journal of Health-System Pharmacy

SN - 1079-2082

IS - 19

ER -