# States M5 RFP / procurement tracker: vw_medicaid_procurement_contract_runway

`medicare_semantic.vw_medicaid_procurement_contract_runway` · State programs · status partial · 220 rows

Medicaid product M5 (RFP / procurement tracker) of the States lane: Medicaid managed care procurements: each contract's award, go-live, base and option term and the months left, with current members. One row per state x program x procurement x winning entity. term_end_base and term_end_max are the contract's base and outside dates; extension_exercise_status says whether an option was used. Dates read 'not_published' where the state does not print them: that text is a finding, not a date. current_members is the latest enrollment month (current_enrollment_month), not the award. 43 state(s): AR AZ CA CO DC DE FL GA HI IA ID IL IN KS KY LA MA MD MI MO MS NC ND NE NH NJ NM NV NY OH OK OR PA PR RI SC TN TX UT VA WA WI WV.

**Grain.** Medicaid managed care procurements: each contract's award, go-live, base and option term and the months left, with current members. 220 rows (Athena, 2026-10-29). Period 2014-01-01 to not_published (term_start).

| column | type | meaning |
|---|---|---|
| state | string |  |
| program | string |  |
| program_type | string |  |
| procurement_class | string |  |
| procurement_id | string |  |
| winning_legal_entity | string |  |
| parent_id | string |  |
| parent_name | string |  |
| award_outcome | string |  |
| award_source_url | string |  |
| go_live | string |  |
| go_live_source_url | string |  |
| term_start | string |  |
| term_end_base | string |  |
| term_end_max | string |  |
| term_source | string |  |
| term_source_page | string |  |
| term_scope_evidence | string |  |
| term_period_kind | string |  |
| option_schedule | string |  |
| ordinary_option_end | string |  |
| absolute_max_status | string |  |
| extension_exercise_status | string |  |
| extension_effective_date | string |  |
| extension_end | string |  |
| extension_source_url | string |  |
| extension_source_page | string |  |
| as_of_date | string |  |
| months_remaining_base | string |  |
| months_remaining_max | string |  |
| current_enrollment_month | string |  |
| current_members | string |  |
| current_enrollment_measure | string |  |
| enrollment_source_url | string |  |
| enrollment_query_id | string |  |
| enrollment_status | string |  |
| parent_unknown_reason | string |  |
| coverage_status | varchar(16) |  |

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