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

`vlada_curated.vw_ipps_hospital_base` · Medicare Advantage, Part D, Medicaid · status live · 81,029 rows

Each 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. FY2006 to FY2026.

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

| 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: `query_substrate` with `SELECT ... FROM vlada_curated.vw_ipps_hospital_base WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.vw_ipps_hospital_base")` first.