Medicare Advantage, Part D, Medicaid

PBP worldwide emergency, urgent care and transport benefit (cleaned view)

medicare_semantic.vw_pbp_worldwide·live·semantic_view
Rows
100,805
Columns
24
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1Worldwide coverage per plan and plan year from PBP section B4c: emergency, urgent care and emergency transport, each with offered status, copay minimum and maximum and coinsurance, plus the combined maximum with its period and annualized value.
  2. 2Built by the benefits lane (Lane CI, 2026-09-29; checked against raw B4C, 5,365 matched) as a versioned view; the bare name is a pointer to the newest version.

Grain

KeyGrain
N/A
  1. 1One row per (contract_id, plan_id, segment_id, report_year, quarter, benefit_category) cleaned row;
  2. 2100,805 rows, report_year 2018-2026, 876 contracts (measured 2026-09-29, Athena 88ad3222).

Columns (24)

ColumnTypeMeaning
contract_idstring
plan_idstring
segment_idstring
versiondouble
report_yeardouble
quarterdouble
benefit_categorystring
worldwide_emergency_offeredboolean
worldwide_emergency_copay_mindouble
worldwide_emergency_copay_maxdouble
worldwide_emergency_coinsurance_pctdouble
worldwide_urgent_offeredboolean
worldwide_urgent_copay_mindouble
worldwide_urgent_copay_maxdouble
worldwide_urgent_coinsurance_pctdouble
worldwide_transport_offeredboolean
worldwide_transport_copay_mindouble
worldwide_transport_copay_maxdouble
worldwide_transport_coinsurance_pctdouble
worldwide_combined_max_amountdouble
worldwide_combined_max_period_labelstring
worldwide_combined_max_annualizeddouble
source_pbp_sectionstring
source_viewstring

Query it

describe_data_source(source_fqn="medicare_semantic.vw_pbp_worldwide")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_pbp_worldwide WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keycontract_id,plan_id,segment_id
Joinhow_to_join(source_fqn="medicare_semantic.vw_pbp_worldwide")
Raw doorAthena (read-only via query_substrate): medicare_semantic.vw_pbp_worldwide
NoteCleaned PBP reasoning surface; register source cms_ma_pbp. Rows measured 2026-09-29 (Athena).

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