State programs

Louisiana Medicaid hospital payments, actual: DSH and supplemental payments by hospital, year-to-date snapshots (LDH legislative report item F, SFY2023-2026)

medicare_semantic.vw_medicaid_la_hospital_actual_payments_v1·partial·semantic_view

Rows

119

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1What Louisiana Medicaid reported paying each hospital in disproportionate share (DSH) and other supplemental payments, from the Louisiana Department of Health's legislative hospital reports (item F, 'other supplemental'), as year-to-date snapshots for SFY2023-2026.
2DSH and supplemental are separate rows; the report's per-hospital total is a control, not served.
3Each row carries its coverage months and period, the Medicaid provider ID, a CCN only where CMS POS proves it active and unique, and the PDF (source_url, source_sha256), page and line.
4Actual reported payments, not ceilings and not modeled allocations.

Grain

Key	Grain
N/A	1One row per Medicaid provider ID x snapshot x program_component (DSH or SUPPLEMENTAL); row_key unique. 2119 rows, 42 providers, four year-to-date snapshots SFY2023_Q3, SFY2024_Q4, SFY2025_Q2, SFY2026_Q3 (Athena 7a3481e4, ac94dc27, 2026-10-19).

Columns (33)

Column	Type	Meaning
`state`	varchar(2)
`program_component`	string
`sfy`	bigint
`report_quarter`	bigint
`snapshot`	string
`coverage_months`	bigint
`period_start`	string
`period_end`	string
`period_coverage`	varchar(20)
`payment_kind`	varchar(30)
`amount_usd`	decimal(38,2)
`amount_status`	string
`money_direction`	string
`medicaid_provider_id`	string
`provider_name`	string
`ccn`	string
`identity_null_reason`	string
`identity_candidates`	string
`match_method`	string
`match_confidence`	string
`identity_temporal_limit`	string
`mapped_npi`	string
`native_period`	string
`period_rule`	string
`program_family`	string
`source_id`	string
`source_url`	string
`source_sha256`	string
`page`	string
`line`	string
`locator`	string
`raw_line`	string
`row_key`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`row_key`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_la_hospital_actual_payments_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_la_hospital_actual_payments_v1 (pin one snapshot and one program_component per sum; never with SDP ceilings)
Note	Registered 2026-10-19 under register w8 (la_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_la_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_la_hospital_actual_payments_v1.md · every page in one file: /llms-full.txt