Medicare Advantage, Part D, Medicaid

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

medicare_silver.vw_ma_landscape_contract_year_v20261013a·live·semantic_view

Rows

2,880,985

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Read-side correction of the Landscape year (LAND-3), nothing restamped in place.
2For 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.
3Every other row keeps contract_year = report_year.
4Defined 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

Key	Grain
N/A	1The 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).

Columns (90)

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

describe_data_source(source_fqn="medicare_silver.vw_ma_landscape_contract_year_v20261013a")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.vw_ma_landscape_contract_year_v20261013a WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_silver.vw_ma_landscape_contract_year_v20261013a")`
Raw door	Athena (read-only via query_substrate): medicare_silver.vw_ma_landscape_contract_year_v20261013a (filter contract_year and record_family)
Company names	`org_marketing_name` `org_name` `parent_org_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	View from #3630, created on Athena 2026-10-13. Registered 2026-10-13 under the cms_ma_landscape register card by the Data Tracker (PR claude/tracker-landscape-pbp-traps). Door RAW, World W3. Readers repoint per docs/data-tracker/LANDSCAPE-PBP-DEFECTS-2026-10-13.md s1.5.

This page as markdown: /docs-md/data/medicare_silver_vw_ma_landscape_contract_year_v20261013a.md · every page in one file: /llms-full.txt