Medicare Advantage, Part D, Medicaid
Medicare benchmark, effective-dated (what Medicare would have paid on a date)
vlada_curated.vw_medicare_benchmark_effective·live·semantic_viewRows
1,077,582
Columns
15
History
N/A
Card
nocolumns only
Typed tools
1
What it is
- 1The effective-dated Medicare benchmark: the allowed amount per billing code and setting for every effective period since 2001 (93 monthly periods), with the source schedule (PFS, OPPS, ASC, CLFS, DME) and the rate semantics.
- 2The current-only view vlada_curated.vw_medicare_benchmark is a projection of this; use this one for 'what would Medicare have paid on this date'.
Grain
| Key | Grain |
|---|---|
| N/A |
|
Columns (15)
| Column | Type | Meaning |
|---|---|---|
billing_code | string | |
billing_class | varchar(13) | |
facility_class | varchar(26) | |
pfs_modifier | string | |
medicare_allowed | double | |
medicare_source | varchar(19) | |
benchmark_year | int | |
priority | int | |
effective_period_start | date | |
effective_period_end | date | |
pfs_payment_track | string | |
rate_semantics | varchar(34) | |
cms_vintage_sequence | bigint | |
asserted_at | date | |
parse_revision | int |
Query it
describe_data_source(source_fqn="vlada_curated.vw_medicare_benchmark_effective") # the card, live query_substrate(sql="SELECT * FROM vlada_curated.vw_medicare_benchmark_effective WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | medicare_allowed |
| Identity key | billing_code,billing_class,facility_class,pfs_modifier,effective_period_start |
| Join | how_to_join(source_fqn="vlada_curated.vw_medicare_benchmark_effective") |
| Raw door | Athena (read-only via query_substrate): vlada_curated.vw_medicare_benchmark_effective |
| Note | Product lane 2026-09-28: 1,077,582 rows, effective periods 2001-01-01 to 2026-07-01 (93), measured on Athena. Register source vlada_w2_medicare_benchmarks. |
This page as markdown: /docs-md/data/vlada_curated_vw_medicare_benchmark_effective.md · every page in one file: /llms-full.txt