Medicare Advantage, Part D, Medicaid

CMS Hospice PPS Per-Diem Rates (Federal Register final rule)

medicare_silver.fact_hospice_pps_rate·live·silver·Medicare Hospice Prospective Payment Rates

Rows

164

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS Hospice PPS per-diem payment rates, extracted from CMS transmittals and Federal Register final-rule tables: Routine Home Care, Continuous Home Care (+ hourly), Inpatient Respite Care, General Inpatient Care — full rates + reduced rates for hospices not meeting quality reporting.
2The hospice repricing benchmark for the 9k+ hospices we roster (dim_hospice); wage index applies by CBSA on top.
3Each load is VALIDATED against the rule's stated rate.
4FY2005-FY2026 are live and proven: FY2005-FY2013 standard pre-HQRP CMS transmittal years, FY2014-FY2015 legacy single-RHC years, FY2016's exact Oct-Dec single-RHC plus Jan-Sep two-tier transition, and FY2017-FY2026 modern two-tier-RHC years.

Grain

Key	Grain
N/A	1One row per (fiscal_year, quality_compliant, level_of_care) — hospice per-diem rate.

Columns (23)

Column	Type	Meaning
`fiscal_year`	int
`quality_compliant`	boolean
`level_of_care`	string
`revenue_code`	string
`level_description`	string
`base_rate`	double
`final_rate`	double
`hourly_rate`	double
`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_hospice_pps_rate")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_hospice_pps_rate WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`level_of_care`
Join	`how_to_join(source_fqn="medicare_silver.fact_hospice_pps_rate")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_hospice_pps_rate
Note	Iceberg medicare_silver.fact_hospice_pps_rate, partition by fiscal_year, replace. Sourced via pipelines/medicare/ingest/hospice_pps_runner.py using CMS transmittal PDFs, structured FR XML, explicitly accepted PDF text, or SHA-locked verified image-table maps. Parser 1.0.3 adds the SHA-locked FY2016 transition adapter plus a pre-write natural-key/effective-period guard.

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