Medicare Advantage, Part D, Medicaid

Medicare IPPS Base Rate (operating + capital standardized amounts)

medicare_silver.fact_ipps_base_rate·live·dim·Medicare Inpatient Prospective Payment System (IPPS)

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The CMS IPPS base payment rates per fiscal year: operating standardized amount, capital standardized amount, and labor-related share.
2The 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

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

Columns (30)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`fiscal_year`
Join	`how_to_join(source_fqn="medicare_silver.fact_ipps_base_rate")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_ipps_base_rate
Note	Completes absolute IPPS pricing with dim_msdrg (weights) + the wage index.

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