Medicare Advantage, Part D, Medicaid
Medicare benchmark view (allowed by code × class)
vlada_curated.vw_medicare_benchmark·live·semantic_viewRows
N/A
Columns
5
History
N/A
Card
nocolumns only
Typed tools
2
What it is
- 1A unified Medicare-allowed benchmark view by billing code + class, with the medicare_source (PFS/OPPS/etc.) and year.
- 2The single benchmark surface the RBP pricing router reads for "Medicare allowed for this code".
Grain
| Key | Grain |
|---|---|
| N/A |
|
Columns (5)
| Column | Type | Meaning |
|---|---|---|
billing_code | string | |
billing_class | varchar(13) | |
medicare_allowed | double | |
medicare_source | varchar(19) | |
medicare_year | int |
Query it
describe_data_source(source_fqn="vlada_curated.vw_medicare_benchmark") # the card, live query_substrate(sql="SELECT * FROM vlada_curated.vw_medicare_benchmark WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | compare_hospital_rates, medicare_allowed |
| Identity key | billing_code |
| Join | how_to_join(source_fqn="vlada_curated.vw_medicare_benchmark") |
| Raw door | Athena (read-only via query_substrate): vlada_curated.vw_medicare_benchmark |
This page as markdown: /docs-md/data/vlada_curated_vw_medicare_benchmark.md · every page in one file: /llms-full.txt