Medicare Advantage, Part D, Medicaid

IPPS hospital base payment per DRG weight, by hospital and fiscal year

vlada_curated.vw_ipps_hospital_base·live·semantic_view

Rows

81,029

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Each IPPS hospital's payment base per DRG weight for a fiscal year, from the standardized amounts and its wage index: multiply by a DRG's relative weight for the unadjusted payment.
2FY2006 to FY2026.

Grain

Key	Grain
N/A	1One row per (fiscal_year, ccn): the hospital's wage-adjusted operating base, capital base, and base payment per DRG weight.

Columns (10)

Column	Type	Meaning
`fiscal_year`	int
`ccn`	string
`wage_index`	double
`operating_base_wage_adjusted`	double
`capital_base`	double
`ipps_base_per_drg_weight`	double
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	bigint
`asserted_at`	date

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`fiscal_year,ccn`
Join	`how_to_join(source_fqn="vlada_curated.vw_ipps_hospital_base")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_ipps_hospital_base
Note	Product lane 2026-09-28: 81,029 rows, FY2006-FY2026, measured on Athena. Register source vlada_w2_medicare_benchmarks.

This page as markdown: /docs-md/data/vlada_curated_vw_ipps_hospital_base.md · every page in one file: /llms-full.txt