Copyright © 2009. American Society of Health-System Pharmacists, Inc. All rights reserved. 1079-2082/04/0602-1242$06.00
Using National Drug Codes and drug knowledge bases to organize prescription records from multiple sourcesLINAS SIMONAITIS, M.D., is Research Scientist, Regenstrief Institute, Indianapolis, IN, and Assistant Professor, School of Medicine, Indiana University, Indianapolis. CLEMENT J. MCDONALD, M.D., is Director, Lister Hill National Center for Biomedical Communications, National Library of Medicine, Bethesda, MD; at the time this research was conducted, he was Director Emeritus, Regenstrief Institute, and Regenstrief Professor Emeritus of Medical Informatics, School of Medicine, Indiana University, Indianapolis. Address correspondence to Dr. Simonaitis at Regenstrief Institute, 410 West 10th Street, Suite 2000, Indianapolis, IN 46202 (lsimonaitis{at}regenstrief.org).
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 in-patient 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.
Index terms: Codes; Databases; Hospitals; National Drug Code; Pharmacy, institutional, hospital; Records
|
|||||||||||||||||||||||