States M1L Limited benefit plans: vw_medicaid_limited_benefit_parent_state_month_v1

What it is

1. 1Medicaid product M1L (Limited benefit plans) of the States lane: Medicaid limited-benefit plan members by plan and parent by state and month: behavioral health, dental, PACE, non-emergency transportation and other limited plans.
2. 2NEVER SUM WITH THE COMPREHENSIVE OR MLTSS TRACKER (M1), OR ACROSS benefit_type: one person can be in a medical MCO, a dental plan, a behavioral health plan and NEMT at once.
3. 3Filter benefit_type and measure_class and never add across measure_class: rows mix enrollment, CMS July point-in-time, member months, Colorado RAE attributed caseload, Michigan capitation eligibles and Pennsylvania's derived behavioral health (Physical HealthChoices county enrollment x the BH-MCO county map, basis derived). basis says the source: observed (the state's report), derived (PA), cms_annual (July point in time), observed_cms_monthly (PACE: MEDICARE enrollment in PACE contracts, not the Medicaid count). also_in_flagship = true rows (Arizona RBHA, Wisconsin Care4Kids) are already inside the M1 totals.
4. 4Michigan's PIHPs are monthly only 2015-10..2021-10 (Section 918 reports via Wayback).
5. 5The parent view vw_medicaid_limited_benefit_parent_state_month_v1 carries series_rank and the sum_rule on every row, and keeps only in_segment_series = true rows: where a state has its own monthly series, its CMS July row is in_segment_series = false (replaced by the state series under measure_class enrollment), so the view's cms_july figures cover ONLY states without a monthly series.
6. 6For a CMS July national figure read the view's cms_july_total column (the CMS July count for that state x benefit_type x parent, whether or not a monthly series replaces it; null outside July and where CMS has no row): 2024-07 DentaQuest 5,282,870, ModivCare 4,505,110, MCNA 3,447,425 (measured 2026-11-01).
7. 7Never add cms_july_total and members together, and never add across benefit_type.
8. 845 state(s): AL AR CA CO DC DE FL GA HI IA ID IL IN KS KY LA MA MD ME MI MO MT NC ND NE NH NJ NM NV NY OH OK OR PA RI SC TN TX UT VA VT WA WI WV WY.

Grain

Columns (13)

Query it

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