Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information Files
These public use files contain formulary, pharmacy network, and pricing data for Medicare Prescription Drug Plans and Medicare Advantage Prescription Drug Plans (with the exception of employer and PACE plans). The Formulary and Pharmacy Network File will be updated monthly with updates being available at the end of the first complete week of each month. Additionally, a file containing formulary, pharmacy network, and pricing data will be available on a quarterly basis.
These public use files are comprised of the following files:
- Geographic Locator File - Includes the MA and PDP Region codes and county codes
- Plan Information File - Includes information for each plan (name, contract ID, plan ID, service area, plan type, etc.)
- Formulary File - Formulary details for each plan including NDCs, Tier Level, and indicators for Step Therapy, Quantity Limits, and Prior Authorization.
- Beneficiary Cost File - Plan level cost sharing details for preferred, non-preferred and mail order network pharmacies.
- Pharmacy Network File - NABP numbers for each network pharmacy including preferred, retail, and mail order indicators.
- Pricing File - Included in the quarterly file, plan level average monthly costs for formulary Part D drugs.
- Record Layout - This file includes a diagram of file linkages, plus separate data dictionaries for each of the files listed above. The record layout and data dictionary for the Formulary file are subject to change. Please check the data dictionary shipped with your order. For viewing the data dictionaries on-line, please see the Record Layout files in Downloads below.
Common data elements in each file include Contract ID, Plan ID, and Segment ID (if applicable).
Use of these files will require access to the following data sources:
- National Council for Prescription Drug Programs, Inc (NCPDP) data access to crosswalk the NABP unique pharmacy numbers to pharmacy names and addresses in the Pharmacy Network File.
- Drug databases such as MediSpan or First DataBank to crosswalk NDCs to drug names in the Formulary File.
TERMS AND CONDITIONS FOR USE OF PART D FORMULARY, PHARMACY NETWORK, AND PRICING INFORMATION
The Part D Formulary, Pharmacy Network, and Pricing Information are public use files being provided by the Centers for Medicare & Medicaid Services (CMS), and any use of such information by Requesting Party must be in a manner consistent with these Terms and Conditions. By requesting and using the Formulary, Pharmacy Network, and Pricing Information, requesting party agrees that it will comply with these Terms and Conditions. See full Terms and Conditions in the Downloads area below.
Data Format: CSV text file
Approximate Size: 10 MB
Compatible Software Programs: Microsoft SQL/DB2/Oracle, SAS or other statistical software. (Note: Microsoft Excel, Microsoft Access, or TextPad cannot be used to analyze the formulary files)
Monthly - Prescription Drug Plan Formulary and Pharmacy Network Files:
Media: CD ROM
File Cost: $250.00 per month
Available: Monthly updates starting December 2005
The release dates for 2013 data are:
10/03/13, 11/13/13, 12/12/13, 01/08/14, 02/05/14, 03/05/14, 04/16/14, 05/14/14, 06/11/14, 07/09/14, 08/06/14
Quarterly - Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information:
Media: CD ROM
File Cost: $750.00 per quarter
Available: Quarterly updates starting May 2009
The release dates for CY 2013 data are:
09/27/13, 12/31/13, 03/14/14, 06/20/14
The new year of Part D Plan pricing data will first appear in the October file (i.e., year 2014 pricing data available in the October 2013 file).
- Terms and Conditions for Use of Part D Formulary, Pharmacy Network, and Pricing Information [PDF, 19KB]
- Record Layout for 2014 Monthly File [PDF, 164KB]
- Record Layout for 2011 Monthly File [PDF, 123KB]
- Record Layout for 2014 Quarterly File [PDF, 165KB]
- Record Layout for 2011 Quarterly File [PDF, 117KB]
- Record Layout for 2010 Quarterly File [PDF, 122KB]
- Order form and general ordering instructions [ZIP, 57KB]
- Page last Modified: 10/22/2013 2:26 PM
- Help with File Formats and Plug-Ins