# PBP Section B18 — Hearing Exams / Aids (silver)

`medicare_silver.pbp_section_b18_hearing_exams_aids` · Medicare Advantage, Part D, Medicaid · status partial

Medicare 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. This is the exact source surface the PBP benefit tools read for this section; the entry catalogues table identity only, not benefit semantics.

**Grain.** One row per (contract_id, plan_id, segment_id, version, report_year, quarter) PBP segment record.

| 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 |  |

Tools that read it: get_pbp_benefit

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.pbp_section_b18_hearing_exams_aids WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.pbp_section_b18_hearing_exams_aids")` first.