Medicare Advantage, Part D, Medicaid

MA HEDIS contract file (general sheet), documented names

medicare_semantic.vw_hedis_general_v2·live·semantic_view

Rows

3,549

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The MA HEDIS PUF general sheet per contract and report year, under the names CMS documents for each code: organization_type (General-0010), plan_type (-0011), offers_snp (-0014, Yes/No/N/A), offers_part_d (-0016 in the workbook, documented as -0015), enrollment (-0050, December of report_year - 1, MARx), region / region_name (-0060 / -0070), patient_population (-0080), submitted_hedis_to_ncqa (-0085), included_in_hos (-0087).

Grain

Key	Grain
N/A	1One row per (report_year, contract_id); 20 duplicate keys in every year (451 / 530 / 592 / 648 / 667 / 661 rows in 2019 / 2021-2025 = publisher rows).

Columns (22)

Column	Type	Meaning
`contract_id`	string
`plan_name_raw`	string
`organization_type`	string
`plan_type`	string
`offers_snp`	string
`offers_part_d`	string
`enrollment`	int
`region`	string
`region_name`	string
`patient_population`	string
`submitted_hedis_to_ncqa`	string
`included_in_hos`	string
`report_year`	int
`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

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hedis_general_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hedis_general_v2 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_hedis_general_v2")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hedis_general_v2
Note	Documented-name view (HEDIS-fix lane 2026-09-29); supersedes the column names of medicare_silver.hedis_general. Versioned, never overwritten.

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