PCD Submission Process Overview

Pharmacy Customer Data Requests

Pharmacy Customer Data is a pharmacy’s dispensing history for the most recent three months, inclusive of controlled substances and non-controlled substances.

Please respond to a request for PCD as well as any follow-up communication from Cencora as quickly as possible to ensure a timely review. Delays in response will impede Cencora’s review process and may result in pharmacies being ineligible to purchase controlled substances from Cencora.

Smiling businessman holding a tablet and taking notes during the meeting

1. Data Collection

Pharmacies may collect PCD using the following methods:

  • Pharmacies may leverage their Pharmacy Management System. Cencora has partnered with most PMS vendors to develop reports that meet our PCD collection criteria. If your PMS vendor has partnered with Cencora, our team will send you instructions on how to prepare your PCD extract. View the list of PMS vendors Cencora has partnered with here.
  • If you are a Corporate Partner pharmacy, Cencora will reach out to the designated point of contact to initiate the PCD collection process.
  • With your approval, we can leverage a third-party service to collect the data directly from your system and produce the report in the required format.
Doctor sitting at the desk and working on the computer

2. Data Validation

Several automated quality checks will be performed on the data to ensure it is in the correct format and contains the required content. Pharmacies will be notified of any submission issues that require resolution. Any issues, if present, must be resolved for Cencora’s CSMP team to begin reviewing your data.

3. Data Analysis

PCD will be aggregated and sent to Cencora’s CSMP team for review after the data validation process is completed. Please keep an eye out for any follow-up communication from Cencora as we work to review your data.

Submission requirements

  • Data must include the three most recent full months of dispensing data for all non-controlled and controlled substance prescriptions. For example, if data is requested on June 15th, you will provide requested data from March, April, and May.
  • The data must be captured at the prescription level (i.e., one record per prescription).
  • The data should include the column headers in the first row.
  • The data must include all prescriptions for controlled and non-controlled prescription drugs.
  • File name must include the pharmacy name and DEA registration number within it (e.g. ABC Pharmacy AB1234567. xlsx).
  • File must be sent in .txt, .csv, .xls, .xlsx, or .xlsb format (access template here).
  • Data must not contain PHI.
  • The data provided must follow the exact column order described in the table below.

Returns Policy Table
Column # Column Header Description Example
1 Pharmacy DEA Number The pharmacy's DEA Registration Number
 FA3456789
2 Pharmacy NPI The pharmacy's 11-digit National Provider Identification number
 1234567890
3 Pharmacy Name
 The pharmacy name
 Pharmacy Store
4 Pharmacy Address 1
 Pharmacy Address line 1
 456 Standard Lane
5 Pharmacy Address 2
 Pharmacy Address line 2. Leave blank if there is no value.
 Suite 100
6 Pharmacy City The pharmacy City Philadelphia
7 Pharmacy Zip Code The pharmacy zip code 12345
8 Pharmacy  State
 The pharmacy’s state abbreviation PA
 9 Prescription Date This is the date the prescription was written by the prescriber. Please provide in 'MM/DD/YYYY' format. 01/01/2025
 10  Fill Date This is the date the prescription was filled by the pharmacy. Please provide in MM/DD/YYYY' format 01/05/2025
 11 Days Supply Prescription Length (eg- 30, 60,90); Numerical values only, do not include text such as "90 days")   30
 12 Quantity Dispensed Quantity filled in dispensing units (numerical values only, do not include dosage type e.g. ml's, mg's, etc.)  120
 13  NDC 11 digit National Drug Code 68001033308
 14  Drug Name  Item Description Lisinopril Oral Tablet 5 MG
 15 Cash Payment Flag - An indicator specifying whether or not this prescription was a cash sale (e.g., cash, credit card, discount card, or charge that does not go through a third party payor).
- Please indicate a cash payment with a value of "Y" and all other payments with a value of "N"
- Additional values indicating cash transactions may be accepted on a case by case basis in coordination with Cencora		  Y or N
 16 Prescriber DEA Number The prescriber's Drug Enforcement Administration registration number AB1234567
 17 Prescriber NPI Number National Provider Identification number of the prescriber 1234567890
 18 Prescriber Last Name Prescriber last name  Doe
 19 Prescriber First Name Prescriber first name  John
 20 Prescriber Address 1 Prescriber Address line 1 123 Wall Street
 21 Prescriber Address 2 Prescriber Address line 2. Leave blank if there is no value.  Suite A
 22 Prescriber City City  Philadelphia
 23 Prescriber State The prescriber's state abbreviation  PA
 24 Prescriber Zip Zip code of the prescriber (5 digit required)  12345
 25 Patient 3-Digit Zip Code

- Three-digit zip-code prefix in which patient is located (e.g.. 123' instead of 12345').
- Please note that five digit zip codes cannot be accepted

  123
 

We are here to answer your questions.

We're always eager to answer questions about how our team can help. Just reach out, and we'll get back to you soon.