# 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` · State programs · status partial · 1,831 rows

What 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. For 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. Every amount carries the report (source_url, source_sha256), page and locator. Actual publisher-reported payments, not ceilings.

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

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_medicaid_va_hospital_actual_payments_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_medicaid_va_hospital_actual_payments_v1")` first.