States M1S SFY final enrollment by parent: fact_tx_medicaid_mco_parent_share_sfy_final_v1

What it is

1. 1Medicaid 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.
2. 2ANNUAL, 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).
3. 3Never mix it into the monthly M1 series and never chart it as months.
4. 4Filter state_fiscal_year and program (or segment_id) before summing: programs overlap (All = Medicaid + CHIP;
5. 5CHIP = CHIP Perinatal + CHIP Regular;
6. 6Medicaid = STAR, STAR+PLUS, STAR Kids, STAR Health, Dual Demo), so summing across programs double counts.
7. 7One row per year x program x parent; is_unmapped_bucket rows hold members not yet bound to a parent.
8. 8Parents sum to statewide_total_printed, the state's own total for that year and program.
9. 91 state(s): TX.

Grain

Columns (29)

Query it

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