# CMS MA / Part D Landscape with the true contract year (corrected Plan and Premium year)

`medicare_silver.vw_ma_landscape_contract_year_v20261013a` · Medicare Advantage, Part D, Medicaid · status live · 2,880,985 rows

Read-side correction of the Landscape year (LAND-3), nothing restamped in place. For record_family = 'plan_premium' rows contract_year applies parser 1.3.0's rule (#3107) to the stored source_member path: release-date stamps are stripped, then the innermost segment's year is taken. Every other row keeps contract_year = report_year. Defined in pipelines/medicare/semantic/pbp/adhoc_views/vw_ma_landscape_contract_year_v20261013a.sql (#3630); proved equal to the fixed loader and to the files' own title rows on all 45 held members (tools/data_tracker/landscape_contract_year_check.py, Athena 14934086).

**Grain.** The rows of medicare_silver.fact_ma_landscape (is_current) unchanged, plus contract_year and contract_year_basis: 2,880,985 rows (1,814,465 landscape + 1,066,520 plan_premium), CY2006-2027 (Athena 057d2d5a, 0b2f4ab9, 2026-10-13).

| column | type | meaning |
|---|---|---|
| report_year | int |  |
| row_seq | bigint |  |
| record_family | string |  |
| category | string |  |
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| source_member | string |  |
| source_member_sha256 | string |  |
| state | string |  |
| county | string |  |
| org_name | string |  |
| plan_name | string |  |
| plan_type | string |  |
| snp_indicator | string |  |
| benefit_type | string |  |
| consolidated_premium | string |  |
| part_c_premium | string |  |
| part_d_premium | string |  |
| part_d_deductible | string |  |
| moop_in_network | string |  |
| overall_star_rating | string |  |
| part_d_star | string |  |
| gap_coverage | string |  |
| sanctioned | string |  |
| state_name | string |  |
| us_territory | string |  |
| org_marketing_name | string |  |
| parent_org_name | string |  |
| contract_name | string |  |
| organization_type | string |  |
| snp_type | string |  |
| snp_institutional_type | string |  |
| snp_institutional_category | string |  |
| dsnp_integration_status | string |  |
| dsnp_aip_identifier | string |  |
| csnp_condition_type | string |  |
| zero_dollar_cost_sharing_dsnp | string |  |
| drug_benefit_category | string |  |
| benefit_type_detail | string |  |
| part_d_coverage_indicator | string |  |
| national_pdp | string |  |
| de_minimis_participant | string |  |
| part_d_basic_premium_at_or_below_benchmark | string |  |
| zero_premium_with_full_lis | string |  |
| lis_auto_enrollment | string |  |
| tier_without_deductible | string |  |
| increased_initial_coverage_limit | string |  |
| part_d_basic_premium | string |  |
| part_d_supplemental_premium | string |  |
| part_d_oop_threshold | string |  |
| lips_amount | string |  |
| part_c_star | string |  |
| ma_region_code | string |  |
| ma_region | string |  |
| pdp_region_code | string |  |
| pdp_region | string |  |
| mmp_start_date | string |  |
| demo_type | string |  |
| moop_at_or_below_3400_flag | 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 |  |
| part_d_lips_cms_pays | string |  |
| part_d_low_income_beneficiary_premium | string |  |
| enrollment_capacity_limit_accepted | string |  |
| enrollment_capacity_limit_amount | string |  |
| part_d_premium_obligation_75pct_assistance | string |  |
| part_d_premium_obligation_50pct_assistance | string |  |
| part_d_premium_obligation_25pct_assistance | string |  |
| gap_coverage_type | string |  |
| state_code | string |  |
| lis_auto_enrollment_all_eras | string |  |
| drug_benefit_category_all_eras | string |  |
| drug_benefit_type_all_eras | string |  |
| member_path_year | string |  |
| contract_year | int |  |
| contract_year_basis | varchar(39) |  |

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