Medicare Advantage, Part D, Medicaid

PBP combined benefit groups (cleaned view)

medicare_semantic.vw_pbp_combined_benefits_group·live·semantic_view

Rows

62,626

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The benefit groups pooled under one combined allowance per plan and plan year, from PBP section D, 2021 on.

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, segment_id, report_year, quarter, benefit_category) cleaned row.

Columns (19)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`segment_id`	string
`version`	double
`report_year`	double
`quarter`	double
`group_index`	int
`group_name`	string
`shared_max_amount`	double
`max_amount_period_code`	string
`shared_visit_count`	double
`delivery_mode`	string
`enrollee_limited`	boolean
`member_categories_raw`	string
`member_families`	string
`member_family_count`	bigint
`is_cross_benefit`	boolean
`source_silver_table`	varchar(29)
`source_pbp_section`	varchar(1)

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_pbp_combined_benefits_group")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_pbp_combined_benefits_group
Note	Cleaned PBP reasoning surface; register source cms_ma_pbp; raw is medicare_silver.pbp_section_d. Rows measured 2026-09-28 (Athena).

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