# Medicare CLFS preliminary CY2027 rates (PAMA weighted medians, raw vs trimmed, capped)

`medicare_silver.fact_clfs_preliminary_rate` · Medicare Advantage, Part D, Medicaid · status live · 1,924 rows

CMS's preliminary CY2027 Clinical Laboratory Fee Schedule per code: the 2026 CLFS rate, the raw and trimmed private-payor weighted medians, the percent change, the reporting-TIN count (withheld under 10), and the CY2027 rate after the 15% payment-reduction cap. Published 2026-09-21; comment window 30 days; final rates post November 2026 and supersede this edition.

**Grain.** One row per HCPCS code in CMS's preliminary CY2027 CLFS rate calculation file (rate_year, hcpcs_code).

| column | type | meaning |
|---|---|---|
| rate_year | int |  |
| collection_year | int |  |
| stage | string |  |
| hcpcs_code | string |  |
| description | string |  |
| category | string |  |
| rate_2026 | double |  |
| raw_weighted_median | double |  |
| raw_pct_change | double |  |
| trimmed_weighted_median | double |  |
| trimmed_pct_change | double |  |
| rate_2027_preliminary | double |  |
| reporting_tins_text | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| vintage_tag | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_clfs_preliminary_rate WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_clfs_preliminary_rate")` first.