# CMS LTCH PPS MS-LTC-DRG Relative Weights (Table 11)

`medicare_silver.fact_ltch_pps_drg_weight` · Medicare Advantage, Part D, Medicaid · status live · 772 rows

CMS Long-Term Care Hospital PPS MS-LTC-DRG case-mix table (Table 11) — per MS-LTC-DRG: the relative weight, geometric average length of stay, and the short-stay-outlier threshold. The LTCH repricing case-mix table for the 655 LTCHs we roster (dim_ltch): payment = relative_weight x LTCH standard federal rate x wage index. Sourced from the CMS-1833-F MS-LTC-DRG File zip (clean XLSX) and anchor-VALIDATED (DRG 003 = 3.644). FY2026 live (772 DRGs). Seventh non-acute repricer — COMPLETES the non-acute PPS rate family (SNF/HH/IRF/LTCH/hospice/ ESRD-base/FQHC + ambulance).

**Grain.** One row per (fiscal_year, MS-LTC-DRG) — relative weight + geometric LOS + short-stay-outlier threshold.

| column | type | meaning |
|---|---|---|
| fiscal_year | int |  |
| ms_ltc_drg | string |  |
| drg_title | string |  |
| relative_weight | double |  |
| geometric_avg_los | double |  |
| short_stay_outlier_threshold | 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: `query_substrate` with `SELECT ... FROM medicare_silver.fact_ltch_pps_drg_weight WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_ltch_pps_drg_weight")` first.