Medicare Advantage, Part D, Medicaid

MA HEDIS national benchmark rates, documented names

medicare_semantic.vw_hedis_national_rates_v2·live·semantic_view
Rows
471
Columns
16
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1CMS's national enrollment-weighted HEDIS rate per measure indicator and report year, from the MA HEDIS PUF national_rates sheet, under the names CMS documents (HEDIS2025Documentation.pdf, REPORTING LEVEL - National, p.3): report_year (NR-0010), measure_code (-0020), indicator_name (-0030 "Field"), indicator_key (-0040), weighted_rate (-0050, the national rate), contracts_count (-0060, contracts with a numeric rate) and reporting_contract_enrollment (-0070, the enrollees of those contracts: TotE, the weight of the average).
  2. 2The national sheet publishes no eligible population.

Grain

KeyGrain
N/A
  1. 1One row per (report_year, measure_code, indicator_key);
  2. 20 duplicate keys;
  3. 368 / 64 / 85 / 82 / 88 / 84 rows in 2019 / 2021-2025 = the rows of medicare_silver.hedis_national_rates (Athena 206a952a-ffad-4240-a192-075b9b1d34d7).

Columns (16)

ColumnTypeMeaning
report_yearint
measure_codestring
indicator_namestring
indicator_keystring
weighted_ratedouble
contracts_countint
reporting_contract_enrollmentint
observed_perioddate
asserted_atdate
effective_period_startdate
effective_period_enddate
cms_vintage_sequenceint
parse_revisionint
parser_artifact_hashstring
source_urlstring
sha256_content_hashstring

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hedis_national_rates_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hedis_national_rates_v2 WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keymeasure_code
Joinhow_to_join(source_fqn="medicare_semantic.vw_hedis_national_rates_v2")
Raw doorTools: get_hedis (the benchmark), get_hedis_national_benchmark; Athena: medicare_semantic.vw_hedis_national_rates_v2
NoteDocumented-name view (Data Tracker served-defect lane, 2026-09-30, defects MAHEDIS-NR-1 / NR-2 / NR-3); supersedes the column names of medicare_silver.hedis_national_rates. Versioned, never overwritten. Record docs/reference/source-audit/source-mastery/records/ma_hedis.json served_corrections.

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