# Medicare benchmark, effective-dated (what Medicare would have paid on a date)

`vlada_curated.vw_medicare_benchmark_effective` · Medicare Advantage, Part D, Medicaid · status live · 1,077,582 rows

The 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. The 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.** One row per (billing_code, billing_class, facility_class, pfs_modifier, effective_period_start): the Medicare allowed amount in force from that date.

| 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 |  |

Tools that read it: medicare_allowed

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