# MA spine: parent per contract x month (as was, as now)

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

Part of the MA spine (docs/architecture/2026-10-12-ma-spine.md; Alpha lane; rebuilds take the next letter, never overwrite). Joins enroll_plan_county / enroll_plan_month on contract_id + report_month; read parent_*_as_now to restate history to today's parent, parent_*_as_was for the parent of the day. 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 contract_id x report_month: the parent organization as CMS printed it that month (parent_of_record), the parent as it was then (parent_id_as_was, parent_name_as_was) and the parent as it is today (parent_id_as_now, parent_name_as_now, with as_now_rule and as_now_events naming the restatement), method_tier, confidence, organization_type, plan_type, enrollment_count, spine_version.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| report_month | date |  |
| parent_id_as_was | string |  |
| parent_name_as_was | string |  |
| parent_id_as_now | string |  |
| parent_name_as_now | string |  |
| as_now_rule | varchar(16) |  |
| as_now_events | varchar(33) |  |
| parent_of_record | string |  |
| method_tier | string |  |
| confidence | string |  |
| applied_event_id | string |  |
| organization_type | string |  |
| plan_type | string |  |
| enrollment_count | int |  |
| spine_version | varchar(10) |  |

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