# States M1S SFY final enrollment by parent: fact_tx_medicaid_mco_parent_share_sfy_final_v1

`medicare_silver.fact_tx_medicaid_mco_parent_share_sfy_final_v1` · State programs · status partial · 781 rows

Medicaid product M1S (SFY final enrollment by parent) of the States lane: Medicaid and CHIP managed care members by parent by state fiscal year: the state's final SFY average monthly enrollment, with each parent's share of the state total. ANNUAL, NOT MONTHLY: measure sfy_average_monthly_final is the state fiscal year's average monthly enrollment, HHSC final (Texas SFY runs September to August; period_start and period_end bound it). Never mix it into the monthly M1 series and never chart it as months. Filter state_fiscal_year and program (or segment_id) before summing: programs overlap (All = Medicaid + CHIP; CHIP = CHIP Perinatal + CHIP Regular; Medicaid = STAR, STAR+PLUS, STAR Kids, STAR Health, Dual Demo), so summing across programs double counts. One row per year x program x parent; is_unmapped_bucket rows hold members not yet bound to a parent. Parents sum to statewide_total_printed, the state's own total for that year and program. 1 state(s): TX.

**Grain.** Medicaid and CHIP managed care members by parent by state fiscal year: the state's final SFY average monthly enrollment, with each parent's share of the state total. 781 rows (Athena, 2026-10-29). Period 2019 to 2025 (state_fiscal_year).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| period_start | date |  |
| period_end | date |  |
| state_fiscal_year | int |  |
| segment_id | string |  |
| program | string |  |
| measure | string |  |
| measure_label | string |  |
| value_unit | string |  |
| source_time_basis | string |  |
| resolution_date | date |  |
| parent_id | string |  |
| parent_name | string |  |
| is_unmapped_bucket | boolean |  |
| plan_rows | bigint |  |
| plan_labels | string |  |
| parent_reported_value_sum | double |  |
| state_plan_row_sum | double |  |
| statewide_total_printed | double |  |
| state_mapped_sum | double |  |
| state_unmapped_sum | double |  |
| parent_share | double |  |
| unmapped_share | double |  |
| crosswalk_row_ids | string |  |
| crosswalk_csv_sha256 | string |  |
| source_sha256 | string |  |
| source_file | string |  |
| source_url | string |  |
| source_locator | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_tx_medicaid_mco_parent_share_sfy_final_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_tx_medicaid_mco_parent_share_sfy_final_v1")` first.