How does the process work?
1. Notification and Data Use Agreement
- The pharmacy will receive a system email from a Cencora e-mail address requesting PCD submission. The pharmacy will be asked to acknowledge the request using a button in the email before moving forward.
- Before data can be submitted, the pharmacy must have a signed Data Use Agreement on file. If one is not already on file, instructions for completing and signing the agreement will be included in the request email.
2. Data Preparation
Pharmacies can prepare PCD themselves or using one of the following methods:
- Use Pharmacy Management System (PMS) reporting tools: Cencora has partnered with many PMS vendors to develop Cencora-specific reporting in their platform. The initial e-mail notification will include instructions for generating PCD for each vendor that has enabled this functionality.
- Pre-Established Relationship: If your pharmacy has a pre-established contact with Cencora for these requests, Cencora will reach out directly to the designated point of contact to facilitate the data collection.
- Third-Party Support: If you are unable to generate PCD using one of the approaches above, Cencora can engage a third-party service, with your approval, that will work with you to collect the data and produce the report in the required format.
3. Data Submission and Validation
- Once PCD has been prepared, the data is uploaded through Cencora’s secure PCD submission portal using the link provided in the request email.
- The data is ingested into Cencora’s secure environment, where automated quality checks are performed to ensure it is in the correct format. Pharmacies will be notified of any submission issues that require resolution.
4. Data Analysis
- The pharmacy’s PCD will be reviewed by Cencora’s CSMP team. The CSMP team may follow up with any questions from the review.
PCD Requirements
Update the bullets underneath to reflect the following:
- Data must include the three most recent full months of dispensing data. 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 must include all prescriptions for controlled and non-controlled prescription drugs.
- The data should include the column headers in the first row.
- File must be sent in .txt, .csv, .xls, .xlsx, or .xlsb format (access template here).
- The file must not contain any additional fields not specifically noted in the requirements.
- The data provided must follow the exact column order described in the table below.
| 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 | The date the prescription was written by the prescriber. Please provide in ‘M/D/YYYY’ or ‘MM/DD/YYYY’ format. | 01/01/2025 |
| 10 | Fill Date | The date the prescription was filled by the pharmacy. Please provide in ‘M/D/YYYY’ or ‘MM/DD/YYYY’ format. | 01/05/2025 |
| 11 | Days Supply | Prescription Length (ex: 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 is not processed through a third party switch) - 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').
|
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.
