# Medicaid managed care capitation rate cycle, every state (cross-state layer), rating periods 2018-2027

`medicare_silver.medicaid_capitation_rate_cycle_v2` · State programs · status partial · 347 rows

Capitation is the fixed per-member-per-month (PMPM) payment a state Medicaid agency pays each managed care organization (MCO) for every enrollee, priced by rate cell (population, eligibility category, age/sex band, region), set for a rating period and certified as actuarially sound by an actuary. This table holds the rate CYCLE: one row per state x program x rating period x amendment, with the cycle basis (calendar_year, state_fiscal_year, other), certification_date, actuary_firm, the overall rate change the document itself states (percent points, with its basis in rate_change_basis_raw, never computed by us) and the document_url, SHA-256 and page/line evidence_locator behind the row. The published rates themselves are medicare_silver.medicaid_capitation_rate_cell_v2. A Vlada cross-state layer read from 44 jurisdictions' own rate certifications, contract rate exhibits, rate schedules and CMS approval letters; for FL, NC, OH and CA it re-reads the same documents as the state's own table. v2 restates v1 whole with the served defects CAP-1..21 fixed (#3243).

**Grain.** One row per state_code x program_name_raw x rating_period_start x rating_period_end x amendment_seq; 347 rows in 44 jurisdictions (42 states, DC and PR), rating periods 2018-01-01 to 2027-09-30 (Athena 36a441e4); 0 duplicate keys (verify_tracker_loads --lane CAP, gates run 20261007T092022Z-92425b52).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| program_name_raw | string |  |
| program_class | string |  |
| rating_period_start | date |  |
| rating_period_end | date |  |
| cycle_basis | string |  |
| certification_date | date |  |
| actuary_firm | string |  |
| document_title | string |  |
| document_url | string |  |
| sha256_content_hash | string |  |
| cms_approval_date | date |  |
| overall_rate_change_pct_reported | double |  |
| rate_change_basis_raw | string |  |
| amendment_seq | int |  |
| evidence_locator | string |  |

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