Data Cleaning for Commercial Pharmacy and Pharmaceutical Distributor Databases: DEA Registration and State License Verification, NCPDP Provider Identification Number Reconciliation, Pharmacy Ownership and Affiliation Change Tracking, Wholesaler Account and Ordering Credential Maintenance, 340B Program Eligibility and Covered Entity Database Accuracy, and Pharmacy Benefit Manager (PBM) Network Directory Validation
On this page
The Pharmacy Database Where Every Record Has a Regulatory Consequence
Pharmacy databases are unlike other commercial contact databases because virtually every data element in a pharmacy record has a regulatory consequence. Shipping a controlled substance to a pharmacy with an expired DEA registration is a federal crime. Billing a prescription under the wrong NCPDP provider ID can trigger audit findings and clawback demands from payers. Dispensing 340B-priced drugs through a contract pharmacy arrangement that is not properly registered with HRSA can result in program termination and repayment of 340B savings. Listing a pharmacy in a PBM network directory with incorrect hours or services can violate state network adequacy requirements and create member access complaints.
The pharmaceutical supply chain database is therefore not just a business tool but a compliance instrument. The accuracy of every field -- DEA number, state license number, NCPDP provider ID, ownership entity, NPI number, ship-to address, 340B eligibility, PBM network status -- directly affects whether the organizations that rely on the database can operate legally.
The challenge is that pharmacy data changes constantly. The United States has approximately 88,000 retail pharmacy locations. Each year, hundreds of independent pharmacies close. Pharmacy chains open new locations and close underperforming ones. Independent pharmacies are acquired by chains or by other independents. Pharmacies relocate. Pharmacists-in-charge change. State licenses renew on varying schedules. DEA registrations renew on a three-year cycle that differs by pharmacy. The cumulative effect of these changes is that a pharmacy database that was fully accurate on January 1 will have thousands of stale, incomplete, or inaccurate records by December 31 if it is not systematically maintained.
DEA Registration and State License Verification
Every pharmacy that dispenses controlled substances must hold a valid DEA registration. The DEA registration is specific to the pharmacy location (not the pharmacist or the pharmacy corporation) and specifies the schedules of controlled substances the pharmacy is authorized to handle (Schedule II through Schedule V). DEA registrations expire on a three-year cycle and must be renewed before expiration; a pharmacy that continues to dispense controlled substances after its DEA registration expires is operating illegally.
Pharmaceutical wholesalers are required by the Drug Supply Chain Security Act (DSCSA) and by their own compliance programs to verify that every pharmacy they ship controlled substances to holds a currently active DEA registration. This verification must be performed at the time of initial account setup and periodically thereafter, because a pharmacy's DEA registration can be suspended, revoked, or surrendered between verification cycles.
The DEA does not provide a free public database of active DEA registrations. The NTIS DEA Active Registrant Database is available by subscription and contains the registration number, registrant name and address, business activity (retail pharmacy, hospital pharmacy, practitioner, etc.), drug schedules authorized, and registration expiration date for every active DEA registrant. State boards of pharmacy maintain their own license verification databases that are searchable online and show the pharmacy license status (active, expired, suspended, revoked), the pharmacist-in-charge name, and the license expiration date.
Export the pharmacy database and cross-reference each pharmacy's DEA number against the NTIS database and each pharmacy's state license number against the appropriate state board of pharmacy license verification system. Save state board of pharmacy license verification result pages as HTML. Upload to Email Extractor to extract pharmacist-in-charge names, pharmacy manager email addresses, and updated contact information from the state board records.
Pharmacy Ownership and Affiliation Change Tracking
Pharmacy ownership changes are among the most disruptive events for pharmacy database accuracy because an ownership change can alter the pharmacy's DEA number (a new owner must obtain a new DEA registration), state license number, NPI number, NCPDP provider ID, wholesaler account, 340B eligibility, and PBM network contracts -- all simultaneously. An independent pharmacy acquired by a chain may retain its NCPDP provider ID but change its DEA number, NPI, and wholesaler account. A chain location divested to an independent may retain the physical location but change every identifier.
Ownership change tracking requires monitoring multiple data sources: state board of pharmacy transfer applications (which must be filed when pharmacy ownership changes and are often visible through the state board's online license search), NCPDP database updates (which reflect ownership changes as they are processed), wholesaler account change requests (which indicate that a pharmacy's ordering credentials or ship-to information has changed), and industry news sources (pharmacy trade publications like Drug Store News, Pharmacy Times, and Drug Topics report chain pharmacy acquisitions and divestitures).
Buying groups and PSAOs face a particular challenge with affiliation changes. When an independent pharmacy joins or leaves a buying group, the buying group must update its member roster, the wholesaler must update the pharmacy's pricing tier and contract terms, and the PSAO must update the pharmacy's PBM network contracts. A pharmacy that has left the buying group but remains listed in the member roster may continue to receive contract pricing it is no longer entitled to, creating financial exposure for the buying group and the wholesaler.
PBM Network Directory Validation
PBMs maintain pharmacy network directories that health plan members use to find in-network pharmacies. State insurance regulations and CMS Medicare Part D requirements impose network adequacy standards that require a minimum number of pharmacies within defined distance and travel time thresholds for plan members. If the PBM's network directory contains inaccurate information -- pharmacies listed as in-network that have closed, pharmacies listed with incorrect addresses or phone numbers, pharmacies listed as offering services (compounding, specialty, 24-hour) that they do not actually provide -- the PBM may fail network adequacy audits and create member access problems.
PBM network directory validation requires periodic verification of every pharmacy listing against current data sources. At a minimum, the validation should confirm that the pharmacy is still operating at the listed address, the pharmacy's phone number is current and answered, the pharmacy's hours of operation are accurately listed, the pharmacy's service offerings (immunizations, compounding, delivery, drive-through, etc.) are accurately listed, and the pharmacy is still contracted with the PBM's network.
Export the PBM network directory and save individual pharmacy website contact pages and state board of pharmacy listing pages as HTML. Upload to Email Extractor to extract current pharmacy manager and pharmacist-in-charge email addresses for follow-up verification communications.
