# Medicaid state directed payments, national: certified program-year amounts, operative version (42 CFR 438.6(c) preprints, 32 states)

`medicare_semantic.vw_medicaid_sdp_program_year_operative_v1` · State programs · status partial · 729 rows

Every state directed payment (SDP) CMS approved under 42 CFR 438.6(c) in 32 states, one row per certified program-year, ready to add up: the preprint's Q4 total, federal and non-federal shares, the approval letter's figure, the payment type and provider class, and the PDF hash, page and locator behind every amount. A Vlada certified layer over CMS's posted approval packages (approval letter + the state's preprint): each amount was read by two independent PDF engines, checked against the letter and against later CMS versions, and passed a third independent audit (SDP-AUDIT-3, PASS). The amounts are approved or proposed ceilings, not payments.

**Grain.** One operative row per program-year (program_year_key unique = state|program_id|rating_period; the operative version_id). 729 rows, 32 states, all certification_status = certified, rating periods starting 2021-2027 (Athena 9c08dac4, 2026-10-13).

| column | type | meaning |
|---|---|---|
| state | string |  |
| program_id | string |  |
| program_name | string |  |
| cms_summary | string |  |
| provider_class | string |  |
| provider_class_basis | string |  |
| payment_type | string |  |
| payment_type_basis | string |  |
| rating_period_start | string |  |
| rating_period_end | string |  |
| period_note | string |  |
| certification_status | string |  |
| status_cause | string |  |
| counts_as_program_year | boolean |  |
| program_year_key | string |  |
| version_id | string |  |
| is_operative | boolean |  |
| version_role | string |  |
| operative_version_id | string |  |
| supersedes_version_id | string |  |
| supersession_rule | string |  |
| cms_approval_date | string |  |
| approval_date_source | string |  |
| total_amount | decimal(20,2) |  |
| federal_share | decimal(20,2) |  |
| nonfederal_share | decimal(20,2) |  |
| shares_certified | boolean |  |
| tie_class | string |  |
| tie_residual | decimal(20,2) |  |
| tie_tolerance | decimal(20,4) |  |
| printed_total | string |  |
| scale_as_printed | string |  |
| amount_kind | string |  |
| includes_premium_tax | boolean |  |
| q4_amount_kind | string |  |
| letter_check | string |  |
| letter_ceiling | decimal(20,2) |  |
| letter_ceiling_kind | string |  |
| preprint_edition | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| bytes_verified | boolean |  |
| q4_page | string |  |
| q4_locator | string |  |
| letter_page | string |  |
| engine_a | string |  |
| engine_a_values | string |  |
| engine_b | string |  |
| engine_b_values | string |  |
| proof_file | string |  |
| audit3_sample_ids | string |  |
| listing_status | string |  |
| cms_control_number | string |  |

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