# Medicaid managed care rate timing by certified cycle and amendment

`medicare_semantic.vw_medicaid_mco_rate_timing_v1` · State programs · status partial

Source-linked rate periods, certification dates, actuary and publisher-reported program change percentages with explicit nulls for unrecovered CMS submission, approval and amendment details. Successor dates distinguish published periods from period-end projections.

**Grain.** One capitation v2 state, program, rating period and amendment key.

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| program_name_raw | string |  |
| program_class | string |  |
| rating_period_start | date |  |
| rating_period_end | date |  |
| rate_period_convention | string |  |
| amendment_seq | int |  |
| certification_date | date |  |
| cms_submission_date | date |  |
| cms_approval_date | date |  |
| amendment_effective_date | date |  |
| amendment_reason | string |  |
| amendment_retroactive | boolean |  |
| actuary_firm | string |  |
| rate_change_pct_reported | double |  |
| rate_change_basis_raw | string |  |
| expected_next_cycle_date | date |  |
| expected_next_cycle_basis | varchar(49) |  |
| next_cycle_date_published | boolean |  |
| document_title | string |  |
| document_url | string |  |
| sha256_content_hash | string |  |
| evidence_locator | string |  |
| source_table_fqn | varchar(49) |  |

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