# Part D plan dimension, monthly (CMS), plan type from CMS's organization type

`drug_silver.vw_dim_part_d_plan_monthly_v3` · Drugs and formularies · status live · 499,050 rows

Every MA-PD and PDP plan segment in every monthly edition 2019-01..2026-09: names, formulary, premium, deductible, region codes, SNP type, and plan_type from CMS's organization type. 2026-09: 5,518 segments (5,141 MA-PD, 10 COST, 367 PDP).

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

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| release_month | string |  |
| contract_year | int |  |
| contract_name | string |  |
| plan_name | string |  |
| formulary_id | string |  |
| premium | double |  |
| deductible | double |  |
| ma_region_code | string |  |
| pdp_region_code | string |  |
| snp | string |  |
| plan_suppressed_yn | boolean |  |
| plan_type | varchar(5) |  |
| cms_organization_type | string |  |
| plan_type_source | varchar(24) |  |
| contract_id_prefix | string |  |
| plan_type_legacy | 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.vw_dim_part_d_plan_monthly_v3 WHERE ... LIMIT 100`; read `describe_data_source("drug_silver.vw_dim_part_d_plan_monthly_v3")` first.