Medicare Advantage, Part D, Medicaid

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

medicare_silver.fact_clfs_preliminary_rate·live·silver

Rows

1,924

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS'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.
2Published 2026-09-21; comment window 30 days; final rates post November 2026 and supersede this edition.

Grain

Key	Grain
N/A	1One row per HCPCS code in CMS's preliminary CY2027 CLFS rate calculation file (rate_year, hcpcs_code).

Columns (20)

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

describe_data_source(source_fqn="medicare_silver.fact_clfs_preliminary_rate")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_clfs_preliminary_rate WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`hcpcs_code`
Join	`how_to_join(source_fqn="medicare_silver.fact_clfs_preliminary_rate")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_clfs_preliminary_rate
Note	Iceberg, one edition (rate_year 2027, stage preliminary). Loaded 2026-09-22 by CTAS from the CMS HCPCS_Prelim_Wgt_Meds_Simple tab.

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