State programs

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·partial·semantic_view

Rows

20,413

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1What 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.
2Audited scope only; every amount carries its source and locator.
3Actual payments, not ceilings.

Grain

Key	Grain
N/A	1One row per provider x program x period_key (source_sha256 + source_locator unique). 220,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).

Columns (26)

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

describe_data_source(source_fqn="medicare_semantic.vw_medicaid_ok_provider_actual_payments_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_medicaid_ok_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_ok_provider_actual_payments_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_ok_provider_actual_payments_v1 (program = <one> AND period_key = <one>)
Note	Registered 2026-10-19 under register w8 (ok_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_ok_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_ok_provider_actual_payments_v1.md · every page in one file: /llms-full.txt