State programs

Medicaid MCO parent share, monthly - build definition v3 (current; not door-served)

medicare_semantic.vw_medicaid_mco_parent_share_monthly_v3·partial·semantic_view

Rows

28,970

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The current build definition: v2's logic over ledger v5 with scope medicaid_parent_share_state_scope_v3.yaml and crosswalk medicare_silver.medicaid_plan_parent_crosswalk_v2.
2The dated materialization medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260927t0218z is built from it and the pointer medicare_semantic.vw_medicaid_mco_parent_share_monthly serves it.

Grain

Key	Grain
N/A	1One parent (or the unmapped bucket) x state x month x measure segment; 228,970 rows, 38 states, 4,315 state-months (the current materialization).

Columns (28)

Column	Type	Meaning
`state_code`	varchar(2)
`observation_period`	timestamp
`segment_id`	varchar(24)
`measure`	varchar(146)
`value_unit`	string
`geography_type`	string
`geography_level`	varchar(48)
`source_time_basis`	string
`parent_id`	string
`parent_name`	string
`parent_ticker`	string
`is_unmapped_bucket`	boolean
`plan_rows`	bigint
`plan_keys`	bigint
`plan_labels`	string
`parent_reported_value_sum`	double
`state_plan_row_sum`	double
`state_mapped_sum`	double
`state_unmapped_sum`	double
`parent_share`	double
`unmapped_share`	double
`null_or_suppressed_rows`	bigint
`duplicate_rows_collapsed`	bigint
`evidence_methods`	string
`identity_edge_conflict`	boolean
`value_basis`	varchar(39)
`enrollment_total_authorized`	boolean
`crosswalk_version`	varchar(125)

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state_code,observation_period,segment_id,parent_id,is_unmapped_bucket`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_mco_parent_share_monthly_v3")`
Raw door	Internal: the build definition. Attributed internal, so the customer door does not read it (a view of this shape plans for tens of seconds); read medicare_semantic.vw_medicaid_mco_parent_share_monthly.
Company names	`parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	THE CURRENT BUILD DEFINITION (registered 2026-09-27, lane B), not the served entry. Kept registered because the materialization is built from it; queryable in Athena for rebuilds.

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