CCW-assigned Prescriber Identifier

SAS Name

This variable is the CCW-assigned number that is used to uniquely identify prescribers found in the Part D Event File. The ID is specific to the CCW and not applicable to any other identification system or data source.

This field also enables linkage between the Part D Event File and the CCW Prescriber Characteristics File.


This variable is only available 2006 - 2013. Beginning with 2014 data, the National Provider Identifier (NPI; which appears in the PDE variable called PRSCRBR_ID) is used in place of the CCW_PRSCRBR_ID within the Prescriber Characteristics File.

Researchers who received CCW data from 2006-2013 and wish to identify the HCIdeaassigned provider ID (HCID) and/or NPI associated with the CCW_PRSCRBR_ID may request the "Prescriber Bridge File", which is designed for this purpose.

This variable is the CCW-assigned prescriber identifier that is populated by linking the PRSCRBR_ID from the PDE to the proprietary HCIdea Prescriber Database.

HCIdea has prescriber information from a variety of data sources, including the NPPES directory (the National Plan and Provider Enumeration System, which assigns a unique NPI to each provider), the Drug Enforcement Administration (through data files known as the Controlled Substances Act Registrants), and SureScripts (a nationwide eprescribing network). Using these input files, it was generally possible for CCW to identify a unique provider using an NPI, DEA number, and/or UPIN number.

This variable is populated for every PDE that could be linked to a provider in the HCIdea database for that year. CCW_PRSCRBR_ID has a negative value when a conclusive link could not be found between the prescriber identification number in the source PDE data and the HCIdea database.

Source: PDE and HCIdea™ Prescriber Database (derived)

Null, or any positive or negative number