State programs

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·partial·semantic_view

Rows

729

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Every 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.
2A 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).
3The amounts are approved or proposed ceilings, not payments.

Grain

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

Columns (53)

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

describe_data_source(source_fqn="medicare_semantic.vw_medicaid_sdp_program_year_operative_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_medicaid_sdp_program_year_operative_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`program_year_key`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_sdp_program_year_operative_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_sdp_program_year_operative_v1 (pin state and rating_period_start; one basis per sum)
Note	Registered 2026-10-13 under register w8 cms_medicaid_state_directed_payments as the only SDP read surface (PR claude/medicaid-sdp-operative-view), after the MCP lane staging gate (mcp-bridge-6771cbd2) found an unfiltered sum over the version table answering $534.3B with no caveat. Door RAW, World W8, status partial, class unversioned. The version table medicare_silver.medicaid_sdp_program_year_versions_v1 is internal: no card, no World, refused NO_COVERAGE. Ship via the MCP release lane.

This page as markdown: /docs-md/data/medicare_semantic_vw_medicaid_sdp_program_year_operative_v1.md · every page in one file: /llms-full.txt