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

`medicare_semantic.vw_medicaid_mco_parent_share_monthly_v3` · State programs · status partial · 28,970 rows

The 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. The 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.** One parent (or the unmapped bucket) x state x month x measure segment; 28,970 rows, 38 states, 4,315 state-months (the current materialization).

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_medicaid_mco_parent_share_monthly_v3 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_medicaid_mco_parent_share_monthly_v3")` first.