State programs

Virginia Medicaid hospital payments, actual: DSH, medical education, UPL and private-acute enhanced payments by hospital and state fiscal year (DMAS reports, SFY2016-2025)

medicare_semantic.vw_medicaid_va_hospital_actual_payments_v1·partial·semantic_view

Rows

1,831

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1What Virginia Medicaid actually paid each hospital, by program and state fiscal year, as DMAS printed it in its reports to the General Assembly: disproportionate share (DSH), graduate and indirect medical education, upper payment limit supplemental payments and the private-acute enhanced payments, SFY2016-2025.
2For each program component x year the one canonical edition is kept (the latest whose printed total passes and ties to its rows), so a sum within one component and one year is that report's printed total.
3Every amount carries the report (source_url, source_sha256), page and locator.
4Actual publisher-reported payments, not ceilings.

Grain

Key	Grain
N/A	1One row per printed provider x program_component x sfy from the one canonical edition of that component-year (observation_id unique). 21,831 rows, 43 component-years, SFY2016-2025, 181 printed provider names (Athena a1d0bb29, d8a57f90, 2026-10-19).

Columns (40)

Column	Type	Meaning
`state`	varchar(2)
`program_component`	string
`program_family`	string
`sfy`	bigint
`sfy_start`	string
`sfy_end`	string
`payment_kind`	varchar(30)
`amount_usd`	decimal(38,12)
`amount_status`	varchar(19)
`missing_reason`	string
`ffs_mco_scope`	string
`provider_name`	string
`provider_ccn_raw`	string
`ccn`	string
`ccn_match_method`	string
`ccn_match_confidence`	string
`identity_warning`	string
`identity_period_note`	string
`provider_medicaid_id`	string
`provider_npi`	string
`provider_system`	string
`canonical_cohort_id`	string
`cohort_equals_printed_total`	boolean
`cross_component_additivity`	string
`exhibit`	string
`exhibit_title`	string
`native_label`	string
`native_period`	string
`raw_value`	string
`locator`	string
`source_id`	string
`source_url`	string
`source_sha256`	string
`source_s3_key`	string
`report_latest_year`	bigint
`publication_version`	string
`era`	string
`second_engine`	string
`second_engine_pass`	boolean
`observation_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`observation_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_va_hospital_actual_payments_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_va_hospital_actual_payments_v1 (pin one program_component and one sfy per sum; never with SDP ceilings)
Note	Registered 2026-10-19 under register w8 (va_medicaid_hospital_actual_payments) as the only read surface (PR claude/medicaid-payments-va-la-load). Door RAW, World W8, status partial, class unversioned. The base table medicare_silver.medicaid_va_hospital_actual_payments_v1 is internal: no card, no World, refused NO_COVERAGE (the #3612 lesson: required_filters do not refuse). Ship via the MCP release lane; production needs Ben's yes.

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