Medicare Advantage, Part D, Medicaid

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

medicare_semantic.ma_spine_parent_month_v20261017a·partial·mart

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Part of the MA spine (docs/architecture/2026-10-12-ma-spine.md;
2Alpha lane; rebuilds take the next letter, never overwrite).
3Joins 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.
4Accepted for the raw door 2026-11-02 (acceptance gate CANDIDATE, reachable, has data, schema captured;
5Omega's MA enrollment master reads it).

Grain

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

Columns (16)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,report_month`
Join	`how_to_join(source_fqn="medicare_semantic.ma_spine_parent_month_v20261017a")`
Raw door	Athena: medicare_semantic.ma_spine_parent_month_v20261017a (versioned name; 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_parent_month_v20261017a.md · every page in one file: /llms-full.txt