# Oklahoma Medicaid provider payments, actual: DSH, practitioner PIP and FFS hospital access by provider and period (OHCA, 2021-2026)

`medicare_semantic.vw_medicaid_ok_provider_actual_payments_v1` · State programs · status partial · 20,413 rows

What Oklahoma Medicaid actually paid in audited DSH (hospitals), practitioner PIP payment runs and FFS hospital access payments (interim, controlled typed actuals), by the publisher's own period, from OHCA reports and workbooks. Audited scope only; every amount carries its source and locator. Actual payments, not ceilings.

**Grain.** One row per provider x program x period_key (source_sha256 + source_locator unique). 20,413 rows: DSH 120 (2 rate years), PIP 19,673 (5 payment runs), FFS_HOSPITAL_ACCESS 620 (4 calendar quarters) (Athena 41d5e3c5, 2026-10-19).

| column | type | meaning |
|---|---|---|
| state | string |  |
| program | string |  |
| period_key | string |  |
| period_type | string |  |
| period_start | string |  |
| program_year | int |  |
| calendar_year | int |  |
| quarter | int |  |
| payment_period | string |  |
| payment_kind | varchar(30) |  |
| paid_usd | decimal(18,2) |  |
| amount_basis | string |  |
| amount_kind | string |  |
| provider_type | string |  |
| provider_name | string |  |
| ccn | string |  |
| ccn_missing_reason | string |  |
| npi | string |  |
| medicaid_provider_id | string |  |
| service | string |  |
| ce | string |  |
| identity_method | string |  |
| identity_confidence | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| source_locator | string |  |

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