Medicare Advantage, Part D, Medicaid

PBP Section B17 — Eye Exams / Eyewear (silver)

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

Rows

N/A

Columns

258

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicare Plan Benefit Package (PBP) Section B17 eye-exam / eyewear 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 (258)

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_b17a_addl_service_other`	string
`pbp_b17a_auth`	string
`pbp_b17a_auth_pos`	string
`pbp_b17a_auth_yn`	string
`pbp_b17a_bendec_enh`	string
`pbp_b17a_bendec_yesno`	string
`pbp_b17a_bendesc_amo_other`	string
`pbp_b17a_bendesc_amo_rex`	string
`pbp_b17a_bendesc_ehc`	string
`pbp_b17a_bendesc_enh`	string
`pbp_b17a_bendesc_lim`	string
`pbp_b17a_bendesc_lim_other`	string
`pbp_b17a_bendesc_lim_rex`	string
`pbp_b17a_bendesc_num_other`	double
`pbp_b17a_bendesc_num_rex`	double
`pbp_b17a_bendesc_numv`	double
`pbp_b17a_bendesc_per`	string
`pbp_b17a_bendesc_per_other`	string
`pbp_b17a_bendesc_per_other_d`	string
`pbp_b17a_bendesc_per_rex`	string
`pbp_b17a_bendesc_per_rex_d`	string
`pbp_b17a_bendesc_rex_amo`	string
`pbp_b17a_bendesc_yn`	string
`pbp_b17a_coins_cov__pos`	string
`pbp_b17a_coins_cov_mc`	string
`pbp_b17a_coins_ehc`	string
`pbp_b17a_coins_mccov`	string
`pbp_b17a_coins_mcmax_pct`	double
`pbp_b17a_coins_mcmin_pct`	double
`pbp_b17a_coins_pct_mc_max`	double
`pbp_b17a_coins_pct_mc_min`	double
`pbp_b17a_coins_pct_other_max`	double
`pbp_b17a_coins_pct_other_min`	double
`pbp_b17a_coins_pct_pos`	double
`pbp_b17a_coins_pct_rex_max`	double
`pbp_b17a_coins_pct_rex_min`	double
`pbp_b17a_coins_rexcov`	string
`pbp_b17a_coins_rexmax_pct`	double
`pbp_b17a_coins_rexmin_pct`	double
`pbp_b17a_coins_yesno`	string
`pbp_b17a_coins_yesno_pos`	string
`pbp_b17a_coins_yn`	string
`pbp_b17a_copay_amt_mc_max`	double
`pbp_b17a_copay_amt_mc_min`	double
`pbp_b17a_copay_amt_other_max`	double
`pbp_b17a_copay_amt_other_min`	double
`pbp_b17a_copay_amt_rex_max`	double
`pbp_b17a_copay_amt_rex_min`	double
`pbp_b17a_copay_ehc`	string
`pbp_b17a_copay_mcmax_amt`	double
`pbp_b17a_copay_mcmaxamt`	double
`pbp_b17a_copay_mcmin_amt`	double
`pbp_b17a_copay_mcminamt`	double
`pbp_b17a_copay_rexamt_pos`	double
`pbp_b17a_copay_rexmax_amt`	double
`pbp_b17a_copay_rexmin_amt`	double
`pbp_b17a_copay_yesno`	string
`pbp_b17a_copay_yesno_pos`	string
`pbp_b17a_copay_yn`	string
`pbp_b17a_cost_share`	string
`pbp_b17a_cost_share_coins_max`	double
`pbp_b17a_cost_share_coins_min`	double
`pbp_b17a_cost_share_coins_yn`	string
`pbp_b17a_cost_share_copay_max`	double
`pbp_b17a_cost_share_copay_min`	double
`pbp_b17a_cost_share_copay_yn`	string
`pbp_b17a_ded_amt`	double
`pbp_b17a_ded_amt_pos`	double
`pbp_b17a_ded_nmc_amt`	double
`pbp_b17a_ded_nmc_yn`	string
`pbp_b17a_ded_yesno`	string
`pbp_b17a_ded_yesno_pos`	string
`pbp_b17a_ded_yn`	string
`pbp_b17a_maxenr_amt`	double
`pbp_b17a_maxenr_amt_pos`	double
`pbp_b17a_maxenr_per`	string
`pbp_b17a_maxenr_per_d`	string
`pbp_b17a_maxenr_yesno`	string
`pbp_b17a_maxenr_yn`	string
`pbp_b17a_maxenr_yn_pos`	string
`pbp_b17a_maxplan_amt`	double
`pbp_b17a_maxplan_cov`	string
`pbp_b17a_maxplan_in_oon`	string
`pbp_b17a_maxplan_per`	string
`pbp_b17a_maxplan_per_d`	string
`pbp_b17a_maxplan_yesno`	string
`pbp_b17a_maxplan_yesno_pos`	string
`pbp_b17a_maxplan_yn`	string
`pbp_b17a_maxpln_amt_pos`	double
`pbp_b17a_maxpln_cov_pos`	string
`pbp_b17a_maxpln_per_pos`	string
`pbp_b17a_refer_yn`	string
`pbp_b17b_auth`	string
`pbp_b17b_auth_pos`	string
`pbp_b17b_auth_yn`	string
`pbp_b17b_bendec_enh`	string
`pbp_b17b_bendec_yesno`	string
`pbp_b17b_bendesc_amo_cl`	string
`pbp_b17b_bendesc_amo_egf`	string
`pbp_b17b_bendesc_amo_egi`	string
`pbp_b17b_bendesc_amo_egs`	string
`pbp_b17b_bendesc_amo_upg`	string
`pbp_b17b_bendesc_cl_amo`	string
`pbp_b17b_bendesc_ehc`	string
`pbp_b17b_bendesc_enh`	string
`pbp_b17b_bendesc_lim_cl`	string
`pbp_b17b_bendesc_lim_egf`	string
`pbp_b17b_bendesc_lim_egl`	string
`pbp_b17b_bendesc_lim_egs`	string
`pbp_b17b_bendesc_numv_cl`	double
`pbp_b17b_bendesc_numv_egf`	double
`pbp_b17b_bendesc_numv_egl`	double
`pbp_b17b_bendesc_numv_egs`	double
`pbp_b17b_bendesc_per_cl`	string
`pbp_b17b_bendesc_per_cl_d`	string
`pbp_b17b_bendesc_per_egf`	string
`pbp_b17b_bendesc_per_egf_d`	string
`pbp_b17b_bendesc_per_egl`	string
`pbp_b17b_bendesc_per_egl_d`	string
`pbp_b17b_bendesc_per_egs`	string
`pbp_b17b_bendesc_per_egs_d`	string
`pbp_b17b_bendesc_yn`	string
`pbp_b17b_coins_cov_cl`	string
`pbp_b17b_coins_cov_egf`	string
`pbp_b17b_coins_cov_egl`	string
`pbp_b17b_coins_cov_egs`	string
`pbp_b17b_coins_cov_mc`	string
`pbp_b17b_coins_cov_upg`	string
`pbp_b17b_coins_ehc`	string
`pbp_b17b_coins_pct_cl`	double
`pbp_b17b_coins_pct_cl_max`	double
`pbp_b17b_coins_pct_cl_min`	double
`pbp_b17b_coins_pct_egf`	double
`pbp_b17b_coins_pct_egf_max`	double
`pbp_b17b_coins_pct_egf_min`	double
`pbp_b17b_coins_pct_egl`	double
`pbp_b17b_coins_pct_egl_max`	double
`pbp_b17b_coins_pct_egl_min`	double
`pbp_b17b_coins_pct_egs`	double
`pbp_b17b_coins_pct_egs_max`	double
`pbp_b17b_coins_pct_egs_min`	double
`pbp_b17b_coins_pct_mc`	double
`pbp_b17b_coins_pct_mc_max`	double
`pbp_b17b_coins_pct_mc_min`	double
`pbp_b17b_coins_pct_upg`	double
`pbp_b17b_coins_pct_upg_max`	double
`pbp_b17b_coins_pct_upg_min`	double
`pbp_b17b_coins_yn`	string
`pbp_b17b_comb_maxplan_amt`	double
`pbp_b17b_comb_maxplan_per`	string
`pbp_b17b_comb_maxplan_per_d`	string
`pbp_b17b_comb_maxplan_yn`	string
`pbp_b17b_copay_amt_cl`	double
`pbp_b17b_copay_amt_cl_max`	double
`pbp_b17b_copay_amt_cl_min`	double
`pbp_b17b_copay_amt_egf`	double
`pbp_b17b_copay_amt_egf_max`	double
`pbp_b17b_copay_amt_egf_min`	double
`pbp_b17b_copay_amt_egl`	double
`pbp_b17b_copay_amt_egl_max`	double
`pbp_b17b_copay_amt_egl_min`	double
`pbp_b17b_copay_amt_egs`	double
`pbp_b17b_copay_amt_egs_max`	double
`pbp_b17b_copay_amt_egs_min`	double
`pbp_b17b_copay_amt_mc`	double
`pbp_b17b_copay_amt_mc_max`	double
`pbp_b17b_copay_amt_mc_min`	double
`pbp_b17b_copay_amt_pos`	double
`pbp_b17b_copay_amt_upg`	double
`pbp_b17b_copay_amt_upg_max`	double
`pbp_b17b_copay_amt_upg_min`	double
`pbp_b17b_copay_amtmax_pos`	double
`pbp_b17b_copay_ehc`	string
`pbp_b17b_copay_yesno`	string
`pbp_b17b_copay_yesno_pos`	string
`pbp_b17b_copay_yn`	string
`pbp_b17b_ded_amt`	double
`pbp_b17b_ded_amt_pos`	double
`pbp_b17b_ded_nmc_amt`	double
`pbp_b17b_ded_nmc_yn`	string
`pbp_b17b_ded_yesno`	string
`pbp_b17b_ded_yesno_pos`	string
`pbp_b17b_ded_yn`	string
`pbp_b17b_disct_cov__pos`	string
`pbp_b17b_disct_cov_cl`	string
`pbp_b17b_disct_cov_egf`	string
`pbp_b17b_disct_cov_egl`	string
`pbp_b17b_disct_cov_egs`	string
`pbp_b17b_disct_cov_mc`	string
`pbp_b17b_disct_cov_upg`	string
`pbp_b17b_disct_pct_cl`	double
`pbp_b17b_disct_pct_egf`	double
`pbp_b17b_disct_pct_egl`	double
`pbp_b17b_disct_pct_egs`	double
`pbp_b17b_disct_pct_mc`	double
`pbp_b17b_disct_pct_pos`	double
`pbp_b17b_disct_pct_upg`	double
`pbp_b17b_disct_pctmax_pos`	double
`pbp_b17b_disct_yesno`	string
`pbp_b17b_disct_yesno_pos`	string
`pbp_b17b_ind_maxplan_per_egf_d`	string
`pbp_b17b_ind_maxplan_per_egl_d`	string
`pbp_b17b_ind_maxplan_per_egs_d`	string
`pbp_b17b_ind_maxplan_per_upg_d`	string
`pbp_b17b_indv_maxplan_amt_cl`	double
`pbp_b17b_indv_maxplan_amt_egf`	double
`pbp_b17b_indv_maxplan_amt_egl`	double
`pbp_b17b_indv_maxplan_amt_egs`	double
`pbp_b17b_indv_maxplan_amt_upg`	double
`pbp_b17b_indv_maxplan_bendesc`	string
`pbp_b17b_indv_maxplan_per_cl`	string
`pbp_b17b_indv_maxplan_per_cl_d`	string
`pbp_b17b_indv_maxplan_per_egf`	string
`pbp_b17b_indv_maxplan_per_egl`	string
`pbp_b17b_indv_maxplan_per_egs`	string
`pbp_b17b_indv_maxplan_per_upg`	string
`pbp_b17b_maxenr_amt`	double
`pbp_b17b_maxenr_amt_pos`	double
`pbp_b17b_maxenr_per`	string
`pbp_b17b_maxenr_per_d`	string
`pbp_b17b_maxenr_type`	string
`pbp_b17b_maxenr_type_pos`	string
`pbp_b17b_maxenr_yesno`	string
`pbp_b17b_maxenr_yn`	string
`pbp_b17b_maxenr_yn_pos`	string
`pbp_b17b_maxplan_amt`	double
`pbp_b17b_maxplan_cov`	string
`pbp_b17b_maxplan_in_oon`	string
`pbp_b17b_maxplan_pct`	double
`pbp_b17b_maxplan_pctprp_pos`	double
`pbp_b17b_maxplan_per`	string
`pbp_b17b_maxplan_type`	string
`pbp_b17b_maxplan_yesno`	string
`pbp_b17b_maxplan_yesno_pos`	string
`pbp_b17b_maxplan_yn`	string
`pbp_b17b_maxpln_amt_pos`	double
`pbp_b17b_maxpln_cov_pos`	string
`pbp_b17b_maxpln_per_pos`	string
`pbp_b17b_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

Query it

describe_data_source(source_fqn="medicare_silver.pbp_section_b17_eye_exams_wear")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.pbp_section_b17_eye_exams_wear 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_b17_eye_exams_wear")`
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_b17_eye_exams_wear.md · every page in one file: /llms-full.txt