Medicare Advantage, Part D, Medicaid

Medicare DMEPOS fee schedule, every release October 1998 - October 2026

medicare_silver.fact_dmepos_fee_schedule·live·silver

Rows

14,503,024

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicare's DMEPOS fee schedule as CMS published it in 95 quarterly and corrective releases: per HCPCS code, modifiers and state, the non-rural fee and (2016 on) rural fee, ceiling, floor, category, jurisdiction and gap-fill indicator.
2October 2026 (dme26-d): CPAP E0601 rental $50.04 non-rural / $97.02 rural in NY.

Grain

Key	Grain
N/A	1One row per (release_id, hcpcs, modifier_1, modifier_2, state).

Columns (41)

Column	Type	Meaning
`release_id`	string
`release_order`	int
`effective_start`	date
`source_format`	string
`source_layout`	string
`source_row_number`	int
`fee_schedule_year`	int
`hcpcs`	string
`modifier_1`	string
`modifier_2`	string
`jurisdiction`	string
`category`	string
`hcpcs_status`	string
`region`	string
`state`	string
`fee`	double
`fee_status`	string
`rural_fee`	double
`rural_fee_status`	string
`original_base_fee`	double
`ceiling`	double
`floor`	double
`gap_fill_indicator`	string
`pricing_change_indicator`	string
`description`	string
`release_title`	string
`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_dmepos_fee_schedule")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_dmepos_fee_schedule WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`release_id,hcpcs,modifier_1,modifier_2,state`
Join	`how_to_join(source_fqn="medicare_silver.fact_dmepos_fee_schedule")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_dmepos_fee_schedule
Note	Register source cms_dmepos_fee_schedule (w2, serve raw). RAW. Loaded 2026-09-30 (verify_tracker_loads PASS 2026-10-01: 14,503,024 rows over 95 releases, zero and rural fees per release equal the TXT reader, 1,060 late dme22-r keys start 2022-10-01; Athena 99c5d166, 782d81d2, 71728d80). Cell reconciliation PASS on 16 releases (every amount >= $100,000 compared). Registered 2026-10-01 in W2.

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