Medicare Advantage, Part D, Medicaid

MA parent lineage events, acquisitions, mergers, novations, renames and divestitures with a citation and what the CMS file measured

medicare_semantic.fact_parent_lineage_event_v1·live·mart

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The event half of ADR M-6.
2Each row carries event_name, event_type (acquisition, merger, novation, divestiture, rebrand), announced_date, effective_date (the close), cms_recognition_month (the first month the CMS file carries the successor on the moved contracts, measured), predecessor and successor parents, the contracts the seed cites and the contracts the CMS file shows moving within six months of the close (with members moved), enrollment_at_event and transaction_value_usd where cited, cascade_strategy, and one citation.
3Entity-level events drive the acquisition segments of dim_parent_alias_v1; contract-level divestitures (a PDP book sold while the parent continues) are recorded here only.

Grain

Key	Grain
N/A	1One row per event_id. 258 events (measured 2026-09-30), 20 from the M-6 Phase 1 seed (lineage_event.yaml) and 38 from ma_parent_lineage_v1.yaml.

Columns (21)

Column	Type	Meaning
`event_id`	string
`event_name`	string
`event_type`	string
`announced_date`	date
`effective_date`	date
`cms_recognition_month`	date
`predecessor_parents`	string
`successor_parents`	string
`affected_contracts_cited`	string
`affected_contracts_measured`	string
`contracts_moved_measured`	bigint
`members_moved_measured`	bigint
`enrollment_at_event_cited`	bigint
`transaction_value_usd`	bigint
`cascade_strategy`	string
`citation_source_type`	string
`citation_url`	string
`citation_accessed_at`	date
`citation_snippet`	string
`registry`	string
`built_at`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`event_id`
Join	`how_to_join(source_fqn="medicare_semantic.fact_parent_lineage_event_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.fact_parent_lineage_event_v1

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