Monthly Prescription Drug Plan Formulary and Pharmacy Network Information - basic_drugs_formulary

Monthly Medicare Part D and Medicare Advantage plan formulary and pharmacy network data.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.MONTHLY_PRESCRIPTION_DRUG_PLAN_FORMULARY_AND_PHARMACY_NETWORK_INFORMATION__BASIC_DRUGS_FORMULARY on Snowflake and Databricks — 12 snapshot releases spanning 2025–2026, aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake	DWV.MONTHLY_PRESCRIPTION_DRUG_PLAN_FORMULARY_AND_PHARMACY_NETWORK_INFORMATION__BASIC_DRUGS_FORMULARY
Databricks	cms_dwv.monthly_prescription_drug_plan_formulary_and_pharmacy_network_information__basic_drugs_formulary
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2026-06-01
Loaded	2026-06-17
Columns	12 data + 6 lineage
Identifiers	NDC codes
File versions	12
License	CMS public data — U.S. Government work
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.

Current — CMS last published this feed on 2026-06-01. Coverage runs through 2026-06-01. Next CMS release expected ~Jul 2026.

Full-refresh feed — each file version is a complete snapshot and newer files supersede older ones. Filter to the latest file (see the sample query) to avoid double-counting across versions.

Sample queries

Snowflake

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM DWV.MONTHLY_PRESCRIPTION_DRUG_PLAN_FORMULARY_AND_PHARMACY_NETWORK_INFORMATION__BASIC_DRUGS_FORMULARY
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

About this feed

Monthly Medicare Part D and Medicare Advantage plan formulary and pharmacy network data. The October file contains new plan-year information.

— Source: CMS feed metadata

Keywords: Medicare, Monthly Prescription Drug Plan Formulary and Pharmacy Network Information - basic_drugs_formulary Theme: Medicare

Coverage timeline

2025 🟩 · 2026 🟩

2 of 2 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2026-06-01	2026-06-01	2026-06-17	✓
Snapshot as of 2026-05-01	2026-05-01	2026-05-21
Snapshot as of 2026-04-01	2026-04-01	2026-04-23
Snapshot as of 2026-03-01	2026-03-01	2026-03-27
Snapshot as of 2026-02-01	2026-02-01	2026-02-28
Snapshot as of 2026-01-01	2026-01-01	2026-01-28
Snapshot as of 2025-12-01	2025-12-01	2025-12-17
Snapshot as of 2025-11-01	2025-11-01	2025-11-19
Snapshot as of 2025-10-01	2025-10-01	2025-11-07
Snapshot as of 2025-09-01	2025-09-01	2025-09-28

Show 2 earlier file versions

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2025-08-01	2025-08-01	2025-09-06
Snapshot as of 2025-07-01	2025-07-01	2025-09-06

Data dictionary

📋 12 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Monthly Prescription Drug Plan Formulary and Pharmacy Network Information - basic_drugs_formulary data dictionary.

Data columns

Column	Type
FORMULARY_ID	NUMBER
FORMULARY_VERSION	NUMBER
CONTRACT_YEAR	NUMBER
RXCUI	NUMBER
NDC	NUMBER
TIER_LEVEL_VALUE	NUMBER
QUANTITY_LIMIT_YN	BOOLEAN
QUANTITY_LIMIT_AMOUNT	TEXT
QUANTITY_LIMIT_DAYS	TEXT
PRIOR_AUTHORIZATION_YN	BOOLEAN
STEP_THERAPY_YN	BOOLEAN
SELECTED_DRUG_YN	BOOLEAN

Lineage columns (present on every feed table)

Column	Type	Description
ROW_ID	TEXT	Unique row ID for this table (PK)
FILE_ID	TEXT	Source file — joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID	TEXT	Parent feed — joins to FEEDS.ID (FK)
FILE_NAME	TEXT	Source file name as published by CMS
ROWNUM	NUMBER	Row number within the source file
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

SELECT d.FORMULARY_ID, d.FORMULARY_VERSION, d.CONTRACT_YEAR,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.MONTHLY_PRESCRIPTION_DRUG_PLAN_FORMULARY_AND_PHARMACY_NETWORK_INFORMATION__BASIC_DRUGS_FORMULARY d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

• Official CMS documentation

Frequently asked questions

How often is Monthly Prescription Drug Plan Formulary and Pharmacy Network Information - basic_drugs_formulary updated?

CMS last published this feed on 2026-06-01. New releases are added automatically when CMS publishes them.

What years does Monthly Prescription Drug Plan Formulary and Pharmacy Network Information - basic_drugs_formulary cover?

2025 through 2026.

How many records are in Monthly Prescription Drug Plan Formulary and Pharmacy Network Information - basic_drugs_formulary?

Count the current snapshot yourself once the share is mounted:

SELECT COUNT(*)
FROM DWV.MONTHLY_PRESCRIPTION_DRUG_PLAN_FORMULARY_AND_PHARMACY_NETWORK_INFORMATION__BASIC_DRUGS_FORMULARY d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID
WHERE ff.IS_LATEST = 1;

How do I get Monthly Prescription Drug Plan Formulary and Pharmacy Network Information - basic_drugs_formulary data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.MONTHLY_PRESCRIPTION_DRUG_PLAN_FORMULARY_AND_PHARMACY_NETWORK_INFORMATION__BASIC_DRUGS_FORMULARY directly — no pipeline setup required.

Related feeds

Medicare Post-Acute Care Utilization - Home Health Agency by Geography and ProviderMedicare Inpatient Hospitals - by ProviderAmbulatory Surgical Center Quality Measures - StateQuarterly Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information - geographic_locatorSkilled Nursing Facility Enrollments

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

2. Mount the share — the database and DWV schema appear in your account immediately

3. Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →