# Part D pharmacy networks and dispensing fees, CMS SPUF member, 2019-Q1 to 2026-Q3

`drug_silver.fact_part_d_pharmacy_network` · Drugs and formularies · status live · 10,248,730,900 rows

CMS quarterly Part D pharmacy network membership, preferred retail/mail flags, in-area flag, floor price and brand/generic/selected-drug dispensing fees by plan and pharmacy. 31 quarters, including 306,634,467 rows in 2026-Q3.

**Grain.** One row per (report_quarter, contract_id, plan_id, segment_id, pharmacy_number).

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| pharmacy_number | string |  |
| pharmacy_zipcode | string |  |
| preferred_status_retail | boolean |  |
| preferred_status_mail | boolean |  |
| pharmacy_retail | boolean |  |
| pharmacy_mail | boolean |  |
| in_area_flag | int |  |
| floor_price | double |  |
| brand_dispensing_fee_30 | double |  |
| brand_dispensing_fee_60 | double |  |
| brand_dispensing_fee_90 | double |  |
| generic_dispensing_fee_30 | double |  |
| generic_dispensing_fee_60 | double |  |
| generic_dispensing_fee_90 | double |  |
| selected_dispensing_fee_30 | double |  |
| selected_dispensing_fee_60 | double |  |
| selected_dispensing_fee_90 | double |  |
| report_quarter | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM drug_silver.fact_part_d_pharmacy_network WHERE ... LIMIT 100`; read `describe_data_source("drug_silver.fact_part_d_pharmacy_network")` first.