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

`medicare_semantic.ma_spine_plan_year_v20261012c` · Medicare Advantage, Part D, Medicaid · status partial

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

**Grain.** One 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.

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.ma_spine_plan_year_v20261012c WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.ma_spine_plan_year_v20261012c")` first.