Medicare Advantage, Part D, Medicaid

PBP Section B18 — Hearing Exams / Aids (silver)

medicare_silver.pbp_section_b18_hearing_exams_aids·partial·silver·Medicare Advantage Plan Benefit Packages (PBP)

Rows

N/A

Columns

250

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicare Plan Benefit Package (PBP) Section B18 hearing-exam / hearing-aid silver table, built by pipelines/medicare/ingest/pbp_runner.py from the CMS PBP SAS source into a medicare_silver Iceberg table.
2This is the exact source surface the PBP benefit tools read for this section; the entry catalogues table identity only, not benefit semantics.

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, segment_id, version, report_year, quarter) PBP segment record.

Columns (250)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`segment_id`	string
`version`	double
`report_year`	double
`quarter`	double
`bid_id`	string
`orgtype`	string
`pbp_a_ben_cov`	string
`pbp_a_plan_type`	string
`pbp_b18a_auth`	string
`pbp_b18a_auth_pos`	string
`pbp_b18a_auth_yn`	string
`pbp_b18a_bendec_enh`	string
`pbp_b18a_bendec_yesno`	string
`pbp_b18a_bendesc_amo_fha`	string
`pbp_b18a_bendesc_amo_rht`	string
`pbp_b18a_bendesc_ehc`	string
`pbp_b18a_bendesc_enh`	string
`pbp_b18a_bendesc_fha_amo`	string
`pbp_b18a_bendesc_lim_fha`	string
`pbp_b18a_bendesc_lim_rht`	string
`pbp_b18a_bendesc_numv_cl`	double
`pbp_b18a_bendesc_numv_fha`	double
`pbp_b18a_bendesc_per_fha`	string
`pbp_b18a_bendesc_per_fha_d`	string
`pbp_b18a_bendesc_per_rht`	string
`pbp_b18a_bendesc_per_rht_d`	string
`pbp_b18a_bendesc_rht_amo`	string
`pbp_b18a_bendesc_yn`	string
`pbp_b18a_coins_cov`	string
`pbp_b18a_coins_cov_fha`	string
`pbp_b18a_coins_cov_pos`	string
`pbp_b18a_coins_cov_rht`	string
`pbp_b18a_coins_ehc`	string
`pbp_b18a_coins_pct_fha`	double
`pbp_b18a_coins_pct_max_fha`	double
`pbp_b18a_coins_pct_max_rht`	double
`pbp_b18a_coins_pct_pos`	double
`pbp_b18a_coins_pct_rht`	double
`pbp_b18a_coins_pctmax_pos`	double
`pbp_b18a_coins_yesno`	string
`pbp_b18a_coins_yesno_pos`	string
`pbp_b18a_coins_yn`	string
`pbp_b18a_copay_amt`	double
`pbp_b18a_copay_amt_fha`	double
`pbp_b18a_copay_amt_max_fha`	double
`pbp_b18a_copay_amt_max_rht`	double
`pbp_b18a_copay_amt_pos`	double
`pbp_b18a_copay_amt_rht`	double
`pbp_b18a_copay_amtmax_pos`	double
`pbp_b18a_copay_ehc`	string
`pbp_b18a_copay_yesno`	string
`pbp_b18a_copay_yesno_pos`	string
`pbp_b18a_copay_yn`	string
`pbp_b18a_ded_amt`	double
`pbp_b18a_ded_amt_pos`	double
`pbp_b18a_ded_nmc_amt`	double
`pbp_b18a_ded_nmc_yn`	string
`pbp_b18a_ded_yesno`	string
`pbp_b18a_ded_yesno_pos`	string
`pbp_b18a_ded_yn`	string
`pbp_b18a_maxenr_amt`	double
`pbp_b18a_maxenr_amt_pos`	double
`pbp_b18a_maxenr_per`	string
`pbp_b18a_maxenr_per_d`	string
`pbp_b18a_maxenr_yesno`	string
`pbp_b18a_maxenr_yn`	string
`pbp_b18a_maxenr_yn_pos`	string
`pbp_b18a_maxplan_amt`	double
`pbp_b18a_maxplan_cov`	string
`pbp_b18a_maxplan_in_oon`	string
`pbp_b18a_maxplan_per`	string
`pbp_b18a_maxplan_per_d`	string
`pbp_b18a_maxplan_yesno`	string
`pbp_b18a_maxplan_yesno_pos`	string
`pbp_b18a_maxplan_yn`	string
`pbp_b18a_maxpln_amt_pos`	double
`pbp_b18a_maxpln_cov_pos`	string
`pbp_b18a_maxpln_per_pos`	string
`pbp_b18a_med_coins_pct`	double
`pbp_b18a_med_coins_pct_max`	double
`pbp_b18a_med_copay_amt_max`	double
`pbp_b18a_refer_yn`	string
`pbp_b18b_auth`	string
`pbp_b18b_auth_pos`	string
`pbp_b18b_auth_yn`	string
`pbp_b18b_bendec_enh`	string
`pbp_b18b_bendec_yesno`	string
`pbp_b18b_bendesc_amo_at`	string
`pbp_b18b_bendesc_amo_ie`	string
`pbp_b18b_bendesc_amo_oe`	string
`pbp_b18b_bendesc_amo_ote`	string
`pbp_b18b_bendesc_ehc`	string
`pbp_b18b_bendesc_enh`	string
`pbp_b18b_bendesc_ie_amo`	string
`pbp_b18b_bendesc_lim_at`	string
`pbp_b18b_bendesc_lim_ie`	string
`pbp_b18b_bendesc_lim_oe`	string
`pbp_b18b_bendesc_lim_ote`	string
`pbp_b18b_bendesc_lim_rb`	string
`pbp_b18b_bendesc_numv_at`	double
`pbp_b18b_bendesc_numv_ie`	double
`pbp_b18b_bendesc_numv_oe`	double
`pbp_b18b_bendesc_numv_ote`	double
`pbp_b18b_bendesc_numv_rb`	double
`pbp_b18b_bendesc_oe_amo`	string
`pbp_b18b_bendesc_ote_amo`	string
`pbp_b18b_bendesc_per_at`	string
`pbp_b18b_bendesc_per_at_d`	string
`pbp_b18b_bendesc_per_ie`	string
`pbp_b18b_bendesc_per_ie_d`	string
`pbp_b18b_bendesc_per_oe`	string
`pbp_b18b_bendesc_per_oe_d`	string
`pbp_b18b_bendesc_per_ote`	string
`pbp_b18b_bendesc_per_ote_d`	string
`pbp_b18b_bendesc_per_rb`	string
`pbp_b18b_bendesc_rb_amo`	string
`pbp_b18b_bendesc_yn`	string
`pbp_b18b_coins_cov_at`	string
`pbp_b18b_coins_cov_ie`	string
`pbp_b18b_coins_cov_oe`	string
`pbp_b18b_coins_cov_ote`	string
`pbp_b18b_coins_ehc`	string
`pbp_b18b_coins_pct_at`	double
`pbp_b18b_coins_pct_at_max`	double
`pbp_b18b_coins_pct_at_min`	double
`pbp_b18b_coins_pct_ie`	double
`pbp_b18b_coins_pct_ie_max`	double
`pbp_b18b_coins_pct_ie_min`	double
`pbp_b18b_coins_pct_oe`	double
`pbp_b18b_coins_pct_oe_max`	double
`pbp_b18b_coins_pct_oe_min`	double
`pbp_b18b_coins_pct_ote`	double
`pbp_b18b_coins_pct_ote_max`	double
`pbp_b18b_coins_pct_ote_min`	double
`pbp_b18b_coins_yn`	string
`pbp_b18b_copay_amt_p2_ie_max`	double
`pbp_b18b_copay_amt_p2_ie_min`	double
`pbp_b18b_copay_amt_p2_oe_max`	double
`pbp_b18b_copay_amt_p2_oe_min`	double
`pbp_b18b_copay_amt_p2_ote_max`	double
`pbp_b18b_copay_amt_p2_ote_min`	double
`pbp_b18b_copay_amt_per2_ie`	double
`pbp_b18b_copay_amt_per2_oe`	double
`pbp_b18b_copay_amt_per2_ote`	double
`pbp_b18b_copay_amt_per2_rb`	double
`pbp_b18b_copay_amt_per_ie`	double
`pbp_b18b_copay_amt_per_ie_max`	double
`pbp_b18b_copay_amt_per_ie_min`	double
`pbp_b18b_copay_amt_per_oe`	double
`pbp_b18b_copay_amt_per_oe_max`	double
`pbp_b18b_copay_amt_per_oe_min`	double
`pbp_b18b_copay_amt_per_ote`	double
`pbp_b18b_copay_amt_per_ote_max`	double
`pbp_b18b_copay_amt_per_ote_min`	double
`pbp_b18b_copay_amt_per_rb`	double
`pbp_b18b_copay_amt_pos`	double
`pbp_b18b_copay_amtmax_pos`	double
`pbp_b18b_copay_at_max_amt`	double
`pbp_b18b_copay_at_min_amt`	double
`pbp_b18b_copay_ehc`	string
`pbp_b18b_copay_yesno`	string
`pbp_b18b_copay_yesno_pos`	string
`pbp_b18b_copay_yn`	string
`pbp_b18b_ded_amt`	double
`pbp_b18b_ded_amt_pos`	double
`pbp_b18b_ded_yesno`	string
`pbp_b18b_ded_yesno_pos`	string
`pbp_b18b_ded_yn`	string
`pbp_b18b_disct_cov_ie`	string
`pbp_b18b_disct_cov_oe`	string
`pbp_b18b_disct_cov_ote`	string
`pbp_b18b_disct_cov_pos`	string
`pbp_b18b_disct_cov_rb`	string
`pbp_b18b_disct_pct_ie`	double
`pbp_b18b_disct_pct_oe`	double
`pbp_b18b_disct_pct_ote`	double
`pbp_b18b_disct_pct_pos`	double
`pbp_b18b_disct_pct_rb`	double
`pbp_b18b_disct_pctmax_pos`	double
`pbp_b18b_disct_pctprp_pos`	double
`pbp_b18b_disct_yesno`	string
`pbp_b18b_disct_yesno_pos`	string
`pbp_b18b_maxenr_amt`	double
`pbp_b18b_maxenr_amt_pos`	double
`pbp_b18b_maxenr_per`	string
`pbp_b18b_maxenr_per_d`	string
`pbp_b18b_maxenr_type`	string
`pbp_b18b_maxenr_type_pos`	string
`pbp_b18b_maxenr_yesno`	string
`pbp_b18b_maxenr_yn`	string
`pbp_b18b_maxenr_yn_pos`	string
`pbp_b18b_maxplan_amt`	double
`pbp_b18b_maxplan_cov`	string
`pbp_b18b_maxplan_in_oon`	string
`pbp_b18b_maxplan_pct`	double
`pbp_b18b_maxplan_pctprp_pos`	double
`pbp_b18b_maxplan_per`	string
`pbp_b18b_maxplan_per_d`	string
`pbp_b18b_maxplan_perear`	string
`pbp_b18b_maxplan_perear_yn`	string
`pbp_b18b_maxplan_type`	string
`pbp_b18b_maxplan_type_pos`	string
`pbp_b18b_maxplan_yesno`	string
`pbp_b18b_maxplan_yesno_pos`	string
`pbp_b18b_maxplan_yn`	string
`pbp_b18b_maxpln_amt_pos`	double
`pbp_b18b_maxpln_cov_pos`	string
`pbp_b18b_maxpln_per_pos`	string
`pbp_b18b_otc_yn`	string
`pbp_b18b_refer_yn`	string
`pbp_b18c_auth_yn`	string
`pbp_b18c_bendesc_amo`	string
`pbp_b18c_bendesc_desc`	string
`pbp_b18c_bendesc_lim`	string
`pbp_b18c_bendesc_num`	double
`pbp_b18c_bendesc_per`	string
`pbp_b18c_coins_pct`	double
`pbp_b18c_coins_pct_max`	double
`pbp_b18c_coins_pct_min`	double
`pbp_b18c_coins_yn`	string
`pbp_b18c_copay_amt`	double
`pbp_b18c_copay_amt_max`	double
`pbp_b18c_copay_amt_min`	double
`pbp_b18c_copay_yn`	string
`pbp_b18c_ded_amt`	double
`pbp_b18c_ded_yn`	string
`pbp_b18c_maxenr_amt`	double
`pbp_b18c_maxenr_per`	string
`pbp_b18c_maxenr_per_desc`	string
`pbp_b18c_maxenr_yn`	string
`pbp_b18c_maxplan_aid_type`	string
`pbp_b18c_maxplan_amt`	double
`pbp_b18c_maxplan_in_oon`	string
`pbp_b18c_maxplan_per`	string
`pbp_b18c_maxplan_per_desc`	string
`pbp_b18c_maxplan_yn`	string
`pbp_b18c_refer_yn`	string
`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
`pbp_b18c_maxplan_choice`	string
`pbp_b18c_maxplan_type`	string

Query it

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

Item	Value
Typed tools that read it	get_pbp_benefit
Identity key	`contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_silver.pbp_section_b18_hearing_exams_aids")`
Raw door	athena
Note	Source-surface catalogue only. Null numeric benefit amounts are NOT $0 and field availability is not benefit semantics; consult docs/skills/pbp-semantics/SKILL.md before any benefit interpretation. Shared by compare_pbp_benefits, find_pbp_plans_by_benefit, get_pbp_benefit, and get_pbp_consumer_reconciliation_candidates.

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