# States M1L Limited benefit plans: medicaid_limited_benefit_plan_enrollment_v1

`medicare_silver.medicaid_limited_benefit_plan_enrollment_v1` · State programs · status partial · 52,589 rows

Medicaid 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. NEVER 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. Filter 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. Michigan's PIHPs are monthly only 2015-10..2021-10 (Section 918 reports via Wayback). The 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. For 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). Never add cms_july_total and members together, and never add across benefit_type. 46 state(s): AL AR AZ 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.** Medicaid limited-benefit plan members by plan and parent by state and month: behavioral health, dental, PACE, non-emergency transportation and other limited plans. 52,589 rows (Athena, 2026-11-01). Period 2006-08-01 to 2026-10-01 (month).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| program | string |  |
| benefit_type | string |  |
| plan_id | string |  |
| plan_name_raw | string |  |
| plan_display_name | string |  |
| plan_registry_status | string |  |
| canonical_parent_id | string |  |
| canonical_parent_name | string |  |
| parent_status | string |  |
| parent_name_raw | string |  |
| month | date |  |
| members | double |  |
| value_status | string |  |
| basis | string |  |
| measure_class | string |  |
| geography_level | string |  |
| geography_name | string |  |
| in_segment_series | boolean |  |
| series_rank | int |  |
| also_in_flagship | boolean |  |
| notes | string |  |
| source_table_fqn | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| source_locator | string |  |
| source_row_key | string |  |
| build_id | string |  |
| built_at | string |  |

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