State programs

Utah Medicaid provider payments, actual: DSH and nursing-facility / outpatient UPL by provider and period (DHHS, 2018-2026)

medicare_semantic.vw_medicaid_ut_provider_actual_payments_v1·partial·semantic_view

Rows

2,061

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1What Utah Medicaid actually paid each hospital and nursing facility in disproportionate share (DSH) and upper payment limit supplemental payments, by the publisher's own period, from Utah DHHS workbooks.
2Audited canonical scope only; every amount carries its workbook (source_url, source_sha256) and cell.
3Actual payments, not ceilings.

Grain

Key	Grain
N/A	1One row per printed provider x program x period_key (source_sha256 + source_locator unique). 22,061 rows: DSH 161 (4 rate years), NF_UPL 1,178 (16 quarters), OP_PRIVATE_UPL 722 (19 quarters) (Athena 19491e1b, 2026-10-19).

Columns (24)

Column	Type	Meaning
`state`	string
`program`	string
`period_key`	string
`period_type`	string
`period_start`	string
`rate_year`	int
`program_year`	int
`sfy_quarter`	string
`payment_kind`	varchar(30)
`paid_usd`	decimal(18,2)
`amount_basis`	string
`provider_type`	string
`provider_name`	string
`owner_payee`	string
`ccn`	string
`npi`	string
`medicaid_provider_id`	string
`facility_id`	string
`identity_method`	string
`identity_confidence`	string
`publisher_note_1_recoup_planned`	boolean
`source_url`	string
`source_sha256`	string
`source_locator`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_sha256,source_locator`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_ut_provider_actual_payments_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_ut_provider_actual_payments_v1 (program = <one> AND period_key = <one>)
Note	Registered 2026-10-19 under register w8 (ut_medicaid_provider_actual_payments) as the only read surface (PR claude/medicaid-payments-ut-ok-load). Door RAW, World W8, status partial, class unversioned. The base table medicare_silver.medicaid_ut_provider_actual_payments_v1 is internal: no card, no World, refused NO_COVERAGE. Ships with the MCP lane's next main-based release.

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