The medical license number accurately identifies the prescribing physician in a large pharmacy claims database

Med Care. 2007 Sep;45(9):907-10. doi: 10.1097/MLR.0b013e3180616c67.


Background: Medical license numbers that identify physicians in pharmacy claims data are used increasingly for both research and quality improvement efforts; however, little is known about how well this information identifies the physician who wrote the prescription. We studied the accuracy of the medical license number in data from a state-run drug benefit plan by assessing its consistency with 2 external sources of data.

Methods: We studied a cohort of new users of osteoporosis medications who participated in Medicare and a state-run pharmaceutical benefit program. The medical license number from the prescription data were merged with the American Medical Association's (AMA) Masterfile to determine if the physician on the pharmacy claim existed in the AMA directory and practiced in the area under study. The prescription data were then merged with Medicare Part B data to determine if the physician on the prescription had an outpatient visit with the patient who received the medication.

Results: Of the 40,002 index prescriptions, 38,671 (96.7%) were written by physicians or doctors of osteopathy. Of those, 38,618 (99.9%) could be matched to the AMA Masterfile of which 37,375 (98%) had a local address. Of the AMA-matched prescriptions with a valid Unique Physician Identification Number (UPIN), 28,888 (96.1%) could be matched to Medicare Part B data, indicating that the physician whose license number appeared on the prescription had at least 1 outpatient visit with the patient who received the medication.

Conclusions: The state medical license number in the pharmacy claims dataset studied seems to identify the prescribing physician with a high degree of accuracy.

Publication types

  • Research Support, N.I.H., Extramural
  • Research Support, Non-U.S. Gov't

MeSH terms

  • American Medical Association
  • Bone Density Conservation Agents / therapeutic use
  • Cohort Studies
  • Databases, Factual / statistics & numerical data
  • Drug Prescriptions / classification*
  • Drug Utilization Review / statistics & numerical data*
  • Humans
  • Insurance Claim Reporting / statistics & numerical data*
  • Insurance, Pharmaceutical Services / statistics & numerical data*
  • Licensure, Medical*
  • Medicare Part B / statistics & numerical data*
  • Osteoporosis / drug therapy
  • Physicians / classification*
  • Prescription Fees / statistics & numerical data
  • United States / epidemiology


  • Bone Density Conservation Agents