# Medicare IPPS inpatient acuity (MS-DRG relative weights)

`drug_silver.dim_msdrg` · Medicare Advantage, Part D, Medicaid · status live · 764 rows

The Medicare INPATIENT acuity benchmark — MS-DRG relative weight (weight_after_cap = final applied weight) + geometric/arithmetic LOS. RELATIVE weight only; an ABSOLUTE IPPS dollar payment is NOT computable (the IPPS base operating rate + hospital wage index are NOT loaded). Match hospital inpatient charges on MS-DRG, present relative acuity — do NOT quote an absolute Medicare inpatient payment. Physically in drug_silver (M-2 envelope sharing) but it is the Medicare inpatient benchmark.

**Grain.** One row per (ms_drg, effective_period_start/fiscal-year) — CMS IPPS Table 5 relative weight + LOS. CERTIFIED 2026-06-03.

| column | type | meaning |
|---|---|---|
| ms_drg | string |  |
| title | string |  |
| mdc | string |  |
| type_code | string |  |
| post_acute_flag | boolean |  |
| special_pay_flag | boolean |  |
| weight_before_cap | double |  |
| weight_after_cap | double |  |
| los_geometric | double |  |
| los_arithmetic | 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 drug_silver.dim_msdrg WHERE ... LIMIT 100`; read `describe_data_source("drug_silver.dim_msdrg")` first.