Medicare Advantage, Part D, Medicaid
CMS SNF PPS PDPM Case-Mix-Adjusted Rates (urban & rural)
Rows
350
Columns
30
History
N/A
Card
nocolumns only
Typed tools
0
What it is
- 1CMS Skilled Nursing Facility PPS PDPM case-mix-adjusted federal rates by fiscal year and urban/rural setting.
- 2The complete PDPM program era FY2020-FY2026 is live: FY2020-FY2022 are SHA-locked Federal Register final-rule tables and FY2023-FY2026 are CMS 508 CSV ZIPs.
- 3Each year has the 25-row A-Y wide grid for PT, OT, SLP, Nursing, and NTA CMIs and adjusted component rates.
Grain
| Key | Grain |
|---|---|
| N/A |
|
Columns (30)
| Column | Type | Meaning |
|---|---|---|
fiscal_year | int | |
urban_rural | string | |
row_seq | bigint | |
pdpm_group | string | |
nursing_cmg | string | |
pt_cmi | double | |
pt_component_rate | double | |
ot_cmi | double | |
ot_component_rate | double | |
slp_cmi | double | |
slp_component_rate | double | |
nursing_cmi | double | |
nursing_component_rate | double | |
nta_cmi | double | |
nta_component_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_snf_pdpm_rate") # the card, live query_substrate(sql="SELECT * FROM medicare_silver.fact_snf_pdpm_rate WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | none; raw SQL |
| Identity key | pdpm_group |
| Join | how_to_join(source_fqn="medicare_silver.fact_snf_pdpm_rate") |
| Raw door | Athena (read-only via query_substrate): medicare_silver.fact_snf_pdpm_rate |
| Note | Iceberg medicare_silver.fact_snf_pdpm_rate, partition by fiscal_year, replace. FY2020-FY2022 source = SHA-locked GovInfo Federal Register PDFs; FY2023-FY2026 source = CMS urban/rural 508 CSV ZIPs. |
This page as markdown: /docs-md/data/medicare_silver_fact_snf_pdpm_rate.md · every page in one file: /llms-full.txt