Medicare Advantage, Part D, Medicaid

MA parent alias dictionary, every CMS parent_org_raw string mapped to a canonical parent, effective-dated and cited

medicare_semantic.dim_parent_alias_v1·live·dim

Rows

1,076

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The alias half of ADR M-6 (docs/architecture/2026-05-09-medicare-substrate-m6-alias-lineage.md, built 2026-09-30).
2Every raw parent string carries canonical_parent_id / canonical_parent_name, effective_start / effective_end, event_type (self_identity, string_variant, label_change, rename, brand_of_acquirer, or the acquisition event type of a later segment), lineage_event_id, method_tier (tier0_exact 826 strings, tier0_normalized 78, tier1_corroborated 26, tier2_reasoned 66), confidence, one citation (source type, url, accessed_at, snippet), the corroboration the CMS file gives, and the string's span and size.
3Renames map for every month; an acquired book joins the acquirer from the close month;
4Aetna is the CVS Health brand for every month by decision.
5Seed: pipelines/medicare/data/ma_parent_lineage_v1.yaml plus lineage_event.yaml.

Grain

Key	Grain
N/A	1One row per parent_org_raw string x effective period. 21,076 rows over all 995 distinct strings of medicare_silver.monthly_contract_enrollment_summary 2006-08 to 2026-09 (measured 2026-09-30); a string has more than one row only where an acquisition moves it to another canonical from the close month.

Columns (21)

Column	Type	Meaning
`parent_org_raw`	string
`canonical_parent_id`	string
`canonical_parent_name`	string
`effective_start`	date
`effective_end`	date
`event_type`	string
`lineage_event_id`	string
`method_tier`	string
`confidence`	string
`citation_source_type`	string
`citation_url`	string
`citation_accessed_at`	date
`citation_snippet`	string
`corroboration`	string
`notes`	string
`raw_first_month`	date
`raw_last_month`	date
`raw_contracts`	bigint
`raw_member_months`	bigint
`built_at`	string
`seed_version`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`parent_org_raw,effective_start`
Join	`how_to_join(source_fqn="medicare_semantic.dim_parent_alias_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.dim_parent_alias_v1
Company names	`canonical_parent_name` `parent_org_raw` 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_dim_parent_alias_v1.md · every page in one file: /llms-full.txt