# Arizona Medicaid (AHCCCS) hospital payments, actual: inpatient, outpatient, DSH, GME, CAH, Prop202 and other components by hospital and year (FFY2019-2024)

`medicare_semantic.vw_medicaid_az_provider_actual_payments_v1` · State programs · status partial · 4,461 rows

What Arizona Medicaid paid each hospital by payment component and year, from the AHCCCS Hospital Payment Summary (current edition), with native FFY / SFY / academic-year periods. Re-audited scope only; RHIF is held for its period relabel. Actual payments (DSH and HEALTHII interim), not ceilings.

**Grain.** One row per hospital x program (component) x period_key from the current summary edition (source_sha256 + source_locator unique); 4,461 rows, 9 programs, 12 periods (Athena 11b1c28f, 2026-10-19).

| column | type | meaning |
|---|---|---|
| state | varchar(2) |  |
| program | string |  |
| component | string |  |
| period_key | string |  |
| year_basis | string |  |
| program_year | string |  |
| basis | string |  |
| payment_kind | varchar(30) |  |
| paid_usd | decimal(38,2) |  |
| value_status | string |  |
| provider_name | string |  |
| medicaid_provider_id | string |  |
| ccn | string |  |
| match_method | string |  |
| match_confidence | string |  |
| npi_printed | string |  |
| representation_group | string |  |
| source_id | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| source_locator | string |  |
| worksheet | string |  |

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