Medicare Advantage, Part D, Medicaid

MA spine: plan-year keys (market, product, Part D, parent, lineage)

medicare_semantic.ma_spine_plan_year_v20261012c·partial·mart

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Part of the MA spine (one connected, normalized Medicare Advantage layer: docs/architecture/2026-10-12-ma-spine.md).
2Built by tools/ma_spine/, rails pass (docs/architecture/ma-spine/STATUS.md).
3Accepted for the raw door 2026-11-02 (acceptance gate CANDIDATE, reachable, has data, schema captured;
4Omega's MA enrollment master reads it).

Grain

Key	Grain
N/A	1One row per plan segment x plan year, 2008-2027: market (MA, PACE, Cost, MMP, PDP) and market_key (EGWP suffixed), product type, SNP class, Part D with its source, parent as was / as now, lineage, classification_source.

Columns (27)

Column	Type	Meaning
`plan_year`	bigint
`contract_id`	string
`plan_id`	string
`segment_id`	string
`plan_segment_key`	string
`plan`	string
`plan_name`	string
`market_raw`	string
`market`	string
`market_key`	string
`is_employer_group`	boolean
`product_type`	string
`snp_class`	string
`dsnp_integration_status`	string
`part_d`	string
`part_d_source`	varchar(13)
`parent_id_as_was`	string
`parent_name_as_was`	string
`parent_id_as_now`	string
`parent_name_as_now`	string
`parent_source`	varchar(15)
`parent_ref_month`	string
`parent_provisional`	boolean
`lineage_id`	string
`lineage_link`	string
`classification_source`	varchar(24)
`spine_version`	varchar(10)

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`plan_year,plan_segment_key`
Join	`how_to_join(source_fqn="medicare_semantic.ma_spine_plan_year_v20261012c")`
Raw door	Athena: medicare_semantic.ma_spine_plan_year_v20261012c (accepted 2026-11-02)
Company names	`parent_name_as_now` `parent_name_as_was` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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