# Medicare IPPS Base Rate (operating + capital standardized amounts)

`medicare_silver.fact_ipps_base_rate` · Medicare Advantage, Part D, Medicaid · status live · 66 rows

The CMS IPPS base payment rates per fiscal year: operating standardized amount, capital standardized amount, and labor-related share. The MISSING LEG that makes an ABSOLUTE Medicare inpatient dollar computable — combine with the MS-DRG relative weight (drug_silver.dim_msdrg) and the hospital wage index (vlada/rbp/ref) to localize: payment ≈ base × DRG weight × (labor_share × wage_index + non_labor_share).

**Grain.** One row per (fiscal_year, capital_area, rate_context vintage) -- national IPPS standardized base = operating_std_amount + capital_std_amount. DEEP FY2006-2026; select capital_area=national, final_rule (a correction supersedes only when no final rule loaded), as-of fiscal year. The shallow dim_ipps_base_rate is deprecated.

| column | type | meaning |
|---|---|---|
| fiscal_year | int |  |
| rate_context | string |  |
| wage_index_regime | string |  |
| operating_std_amount | decimal(38,12) |  |
| capital_std_amount | decimal(38,12) |  |
| labor_share | decimal(38,12) |  |
| labor_amount | decimal(38,12) |  |
| nonlabor_amount | decimal(38,12) |  |
| operating_totals_match | boolean |  |
| source_member | string |  |
| sheet_name | string |  |
| table_1a_label | string |  |
| table_1b_label | string |  |
| source_note | string |  |
| capital_area | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

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