Medicare Advantage, Part D, Medicaid

PBP Section B16 — Dental (silver)

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

Rows

N/A

Columns

565

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicare Plan Benefit Package (PBP) Section B16 dental-benefit 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 (565)

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_b16a_auth`	string
`pbp_b16a_auth_mc_yn`	string
`pbp_b16a_auth_pos`	string
`pbp_b16a_auth_yn`	string
`pbp_b16a_bendec_ehc`	string
`pbp_b16a_bendesc_amo_dx`	string
`pbp_b16a_bendesc_amo_ft`	string
`pbp_b16a_bendesc_amo_oe`	string
`pbp_b16a_bendesc_amo_pc`	string
`pbp_b16a_bendesc_ehc`	string
`pbp_b16a_bendesc_lim_dx`	string
`pbp_b16a_bendesc_lim_ft`	string
`pbp_b16a_bendesc_lim_oe`	string
`pbp_b16a_bendesc_lim_pc`	string
`pbp_b16a_bendesc_numv_dx`	double
`pbp_b16a_bendesc_numv_ft`	double
`pbp_b16a_bendesc_numv_oe`	double
`pbp_b16a_bendesc_numv_pc`	double
`pbp_b16a_bendesc_per_dx`	string
`pbp_b16a_bendesc_per_dx_d`	string
`pbp_b16a_bendesc_per_ft`	string
`pbp_b16a_bendesc_per_ft_d`	string
`pbp_b16a_bendesc_per_oe`	string
`pbp_b16a_bendesc_per_oe_d`	string
`pbp_b16a_bendesc_per_pc`	string
`pbp_b16a_bendesc_per_pc_d`	string
`pbp_b16a_bendesc_yesno`	string
`pbp_b16a_bendesc_yn`	string
`pbp_b16a_coins_cov__pos`	string
`pbp_b16a_coins_cov_dx`	string
`pbp_b16a_coins_cov_ft`	string
`pbp_b16a_coins_cov_oe`	string
`pbp_b16a_coins_cov_pc`	string
`pbp_b16a_coins_cov_sc_pov`	string
`pbp_b16a_coins_cserv_sc_pov`	string
`pbp_b16a_coins_cserv_sc_pov_yn`	string
`pbp_b16a_coins_ehc`	string
`pbp_b16a_coins_mc_pct`	double
`pbp_b16a_coins_mc_pct_max`	double
`pbp_b16a_coins_mc_pct_min`	double
`pbp_b16a_coins_mc_yn`	string
`pbp_b16a_coins_pct_dx`	double
`pbp_b16a_coins_pct_ft`	double
`pbp_b16a_coins_pct_maxdx`	double
`pbp_b16a_coins_pct_maxft`	double
`pbp_b16a_coins_pct_maxoe`	double
`pbp_b16a_coins_pct_maxov`	double
`pbp_b16a_coins_pct_maxpc`	double
`pbp_b16a_coins_pct_minov`	double
`pbp_b16a_coins_pct_oe`	double
`pbp_b16a_coins_pct_ov`	double
`pbp_b16a_coins_pct_pc`	double
`pbp_b16a_coins_pct_pos`	double
`pbp_b16a_coins_pctmax_pos`	double
`pbp_b16a_coins_yesno`	string
`pbp_b16a_coins_yesno_pos`	string
`pbp_b16a_coins_yn`	string
`pbp_b16a_copay_amt_dxmax`	double
`pbp_b16a_copay_amt_dxmin`	double
`pbp_b16a_copay_amt_ftmax`	double
`pbp_b16a_copay_amt_ftmin`	double
`pbp_b16a_copay_amt_oemax`	double
`pbp_b16a_copay_amt_oemin`	double
`pbp_b16a_copay_amt_ovmax`	double
`pbp_b16a_copay_amt_ovmin`	double
`pbp_b16a_copay_amt_pcmax`	double
`pbp_b16a_copay_amt_pcmin`	double
`pbp_b16a_copay_cserv_sc_pov`	string
`pbp_b16a_copay_cserv_sc_pov_yn`	string
`pbp_b16a_copay_ehc`	string
`pbp_b16a_copay_maxamt_pos`	double
`pbp_b16a_copay_mc_amt`	double
`pbp_b16a_copay_mc_amt_max`	double
`pbp_b16a_copay_mc_amt_min`	double
`pbp_b16a_copay_mc_yn`	string
`pbp_b16a_copay_minamt_pos`	double
`pbp_b16a_copay_ov_amt`	double
`pbp_b16a_copay_yesno`	string
`pbp_b16a_copay_yesno_pos`	string
`pbp_b16a_copay_yn`	string
`pbp_b16a_ded_amt`	double
`pbp_b16a_ded_amt_pos`	double
`pbp_b16a_ded_mc_amt`	double
`pbp_b16a_ded_mc_yn`	string
`pbp_b16a_ded_yesno`	string
`pbp_b16a_ded_yesno_pos`	string
`pbp_b16a_ded_yn`	string
`pbp_b16a_maxenr_amt`	double
`pbp_b16a_maxenr_amt_pos`	double
`pbp_b16a_maxenr_mc_amt`	double
`pbp_b16a_maxenr_mc_per`	string
`pbp_b16a_maxenr_mc_per_desc`	string
`pbp_b16a_maxenr_mc_yn`	string
`pbp_b16a_maxenr_per`	string
`pbp_b16a_maxenr_per_desc`	string
`pbp_b16a_maxenr_yesno`	string
`pbp_b16a_maxenr_yn`	string
`pbp_b16a_maxenr_yn_pos`	string
`pbp_b16a_maxplan_amt`	double
`pbp_b16a_maxplan_cov`	string
`pbp_b16a_maxplan_in_oon`	string
`pbp_b16a_maxplan_per`	string
`pbp_b16a_maxplan_per_desc`	string
`pbp_b16a_maxplan_yesno`	string
`pbp_b16a_maxplan_yesno_pos`	string
`pbp_b16a_maxplan_yn`	string
`pbp_b16a_maxpln_amt_pos`	double
`pbp_b16a_maxpln_cov_pos`	string
`pbp_b16a_maxpln_per_pos`	string
`pbp_b16a_refer_mc_yn`	string
`pbp_b16a_refer_yn`	string
`pbp_b16b_auth`	string
`pbp_b16b_auth_dx_yn`	string
`pbp_b16b_auth_ft_yn`	string
`pbp_b16b_auth_ods_yn`	string
`pbp_b16b_auth_oe_yn`	string
`pbp_b16b_auth_ops_yn`	string
`pbp_b16b_auth_pc_yn`	string
`pbp_b16b_auth_pos`	string
`pbp_b16b_auth_yn`	string
`pbp_b16b_bendec_ehc`	string
`pbp_b16b_bendesc_amo_ds`	string
`pbp_b16b_bendesc_amo_end`	string
`pbp_b16b_bendesc_amo_epe`	string
`pbp_b16b_bendesc_amo_es`	string
`pbp_b16b_bendesc_amo_ext`	string
`pbp_b16b_bendesc_amo_peri`	string
`pbp_b16b_bendesc_amo_poo`	string
`pbp_b16b_bendesc_amo_rs`	string
`pbp_b16b_bendesc_dx_amo`	string
`pbp_b16b_bendesc_dx_desc`	string
`pbp_b16b_bendesc_dx_lim`	string
`pbp_b16b_bendesc_dx_num`	double
`pbp_b16b_bendesc_dx_per`	string
`pbp_b16b_bendesc_ehc`	string
`pbp_b16b_bendesc_ft_amo`	string
`pbp_b16b_bendesc_ft_desc`	string
`pbp_b16b_bendesc_ft_lim`	string
`pbp_b16b_bendesc_ft_num`	double
`pbp_b16b_bendesc_ft_per`	string
`pbp_b16b_bendesc_lim_ds`	string
`pbp_b16b_bendesc_lim_end`	string
`pbp_b16b_bendesc_lim_epe`	string
`pbp_b16b_bendesc_lim_es`	string
`pbp_b16b_bendesc_lim_ext`	string
`pbp_b16b_bendesc_lim_peri`	string
`pbp_b16b_bendesc_lim_poo`	string
`pbp_b16b_bendesc_lim_rs`	string
`pbp_b16b_bendesc_num_end`	double
`pbp_b16b_bendesc_num_ext`	double
`pbp_b16b_bendesc_num_peri`	double
`pbp_b16b_bendesc_numv_ds`	double
`pbp_b16b_bendesc_numv_epe`	double
`pbp_b16b_bendesc_numv_es`	double
`pbp_b16b_bendesc_numv_poo`	double
`pbp_b16b_bendesc_numv_rs`	double
`pbp_b16b_bendesc_ods_amo`	string
`pbp_b16b_bendesc_ods_desc`	string
`pbp_b16b_bendesc_ods_lim`	string
`pbp_b16b_bendesc_ods_num`	double
`pbp_b16b_bendesc_ods_per`	string
`pbp_b16b_bendesc_oe_amo`	string
`pbp_b16b_bendesc_oe_desc`	string
`pbp_b16b_bendesc_oe_lim`	string
`pbp_b16b_bendesc_oe_num`	double
`pbp_b16b_bendesc_oe_per`	string
`pbp_b16b_bendesc_ops_amo`	string
`pbp_b16b_bendesc_ops_desc`	string
`pbp_b16b_bendesc_ops_lim`	string
`pbp_b16b_bendesc_ops_num`	double
`pbp_b16b_bendesc_ops_per`	string
`pbp_b16b_bendesc_pc_amo`	string
`pbp_b16b_bendesc_pc_desc`	string
`pbp_b16b_bendesc_pc_lim`	string
`pbp_b16b_bendesc_pc_num`	double
`pbp_b16b_bendesc_pc_per`	string
`pbp_b16b_bendesc_per_ds`	string
`pbp_b16b_bendesc_per_ds_d`	string
`pbp_b16b_bendesc_per_end`	string
`pbp_b16b_bendesc_per_end_d`	string
`pbp_b16b_bendesc_per_epe`	string
`pbp_b16b_bendesc_per_es`	string
`pbp_b16b_bendesc_per_es_d`	string
`pbp_b16b_bendesc_per_ext`	string
`pbp_b16b_bendesc_per_ext_d`	string
`pbp_b16b_bendesc_per_peri`	string
`pbp_b16b_bendesc_per_peri_d`	string
`pbp_b16b_bendesc_per_poo`	string
`pbp_b16b_bendesc_per_poo_d`	string
`pbp_b16b_bendesc_per_rs`	string
`pbp_b16b_bendesc_per_rs_d`	string
`pbp_b16b_bendesc_yesno`	string
`pbp_b16b_bendesc_yn`	string
`pbp_b16b_coins_cov__pos`	string
`pbp_b16b_coins_cov_ds`	string
`pbp_b16b_coins_cov_epe`	string
`pbp_b16b_coins_cov_es`	string
`pbp_b16b_coins_cov_mc`	string
`pbp_b16b_coins_cov_poo`	string
`pbp_b16b_coins_cov_rs`	string
`pbp_b16b_coins_dx_pct`	double
`pbp_b16b_coins_dx_pct_max`	double
`pbp_b16b_coins_dx_pct_min`	double
`pbp_b16b_coins_dx_yn`	string
`pbp_b16b_coins_ehc`	string
`pbp_b16b_coins_ft_pct`	double
`pbp_b16b_coins_ft_pct_max`	double
`pbp_b16b_coins_ft_pct_min`	double
`pbp_b16b_coins_ft_yn`	string
`pbp_b16b_coins_ods_pct`	double
`pbp_b16b_coins_ods_pct_max`	double
`pbp_b16b_coins_ods_pct_min`	double
`pbp_b16b_coins_ods_yn`	string
`pbp_b16b_coins_oe_pct`	double
`pbp_b16b_coins_oe_pct_max`	double
`pbp_b16b_coins_oe_pct_min`	double
`pbp_b16b_coins_oe_yn`	string
`pbp_b16b_coins_ops_pct`	double
`pbp_b16b_coins_ops_pct_max`	double
`pbp_b16b_coins_ops_pct_min`	double
`pbp_b16b_coins_ops_yn`	string
`pbp_b16b_coins_ov_pct`	double
`pbp_b16b_coins_ov_pct_max`	double
`pbp_b16b_coins_ov_pct_min`	double
`pbp_b16b_coins_ov_svcs`	string
`pbp_b16b_coins_ov_yn`	string
`pbp_b16b_coins_pc_pct`	double
`pbp_b16b_coins_pc_pct_max`	double
`pbp_b16b_coins_pc_pct_min`	double
`pbp_b16b_coins_pc_yn`	string
`pbp_b16b_coins_pct_ds`	double
`pbp_b16b_coins_pct_ds_max`	double
`pbp_b16b_coins_pct_ds_min`	double
`pbp_b16b_coins_pct_end_max`	double
`pbp_b16b_coins_pct_end_min`	double
`pbp_b16b_coins_pct_epe`	double
`pbp_b16b_coins_pct_es`	double
`pbp_b16b_coins_pct_es_max`	double
`pbp_b16b_coins_pct_es_min`	double
`pbp_b16b_coins_pct_ext_max`	double
`pbp_b16b_coins_pct_ext_min`	double
`pbp_b16b_coins_pct_max_mc`	double
`pbp_b16b_coins_pct_maxds`	double
`pbp_b16b_coins_pct_maxepe`	double
`pbp_b16b_coins_pct_maxes`	double
`pbp_b16b_coins_pct_maxpoo`	double
`pbp_b16b_coins_pct_maxrs`	double
`pbp_b16b_coins_pct_mc`	double
`pbp_b16b_coins_pct_mc_max`	double
`pbp_b16b_coins_pct_mc_min`	double
`pbp_b16b_coins_pct_peri_max`	double
`pbp_b16b_coins_pct_peri_min`	double
`pbp_b16b_coins_pct_poo`	double
`pbp_b16b_coins_pct_poo_max`	double
`pbp_b16b_coins_pct_poo_min`	double
`pbp_b16b_coins_pct_pos`	double
`pbp_b16b_coins_pct_rs`	double
`pbp_b16b_coins_pct_rs_max`	double
`pbp_b16b_coins_pct_rs_min`	double
`pbp_b16b_coins_pctmax_mc`	double
`pbp_b16b_coins_pctmax_pos`	double
`pbp_b16b_coins_yesno`	string
`pbp_b16b_coins_yesno_pos`	string
`pbp_b16b_coins_yn`	string
`pbp_b16b_copay_amt_ds_max`	double
`pbp_b16b_copay_amt_ds_min`	double
`pbp_b16b_copay_amt_dsmax`	double
`pbp_b16b_copay_amt_dsmin`	double
`pbp_b16b_copay_amt_end_max`	double
`pbp_b16b_copay_amt_end_min`	double
`pbp_b16b_copay_amt_epemax`	double
`pbp_b16b_copay_amt_epemin`	double
`pbp_b16b_copay_amt_es_max`	double
`pbp_b16b_copay_amt_es_min`	double
`pbp_b16b_copay_amt_esmax`	double
`pbp_b16b_copay_amt_esmin`	double
`pbp_b16b_copay_amt_ext_max`	double
`pbp_b16b_copay_amt_ext_min`	double
`pbp_b16b_copay_amt_mc_max`	double
`pbp_b16b_copay_amt_mc_min`	double
`pbp_b16b_copay_amt_peri_max`	double
`pbp_b16b_copay_amt_peri_min`	double
`pbp_b16b_copay_amt_poo_max`	double
`pbp_b16b_copay_amt_poo_min`	double
`pbp_b16b_copay_amt_poomax`	double
`pbp_b16b_copay_amt_poomin`	double
`pbp_b16b_copay_amt_rs_max`	double
`pbp_b16b_copay_amt_rs_min`	double
`pbp_b16b_copay_amt_rsmax`	double
`pbp_b16b_copay_amt_rsmin`	double
`pbp_b16b_copay_dx_amt`	double
`pbp_b16b_copay_dx_amt_max`	double
`pbp_b16b_copay_dx_amt_min`	double
`pbp_b16b_copay_dx_yn`	string
`pbp_b16b_copay_ehc`	string
`pbp_b16b_copay_ft_amt`	double
`pbp_b16b_copay_ft_amt_max`	double
`pbp_b16b_copay_ft_amt_min`	double
`pbp_b16b_copay_ft_yn`	string
`pbp_b16b_copay_maxamt_pos`	double
`pbp_b16b_copay_mc_amt`	double
`pbp_b16b_copay_mcmax_amt`	double
`pbp_b16b_copay_minamt_pos`	double
`pbp_b16b_copay_ods_amt`	double
`pbp_b16b_copay_ods_amt_max`	double
`pbp_b16b_copay_ods_amt_min`	double
`pbp_b16b_copay_ods_yn`	string
`pbp_b16b_copay_oe_amt`	double
`pbp_b16b_copay_oe_amt_max`	double
`pbp_b16b_copay_oe_amt_min`	double
`pbp_b16b_copay_oe_yn`	string
`pbp_b16b_copay_ops_amt`	double
`pbp_b16b_copay_ops_amt_max`	double
`pbp_b16b_copay_ops_amt_min`	double
`pbp_b16b_copay_ops_yn`	string
`pbp_b16b_copay_ov_amt`	double
`pbp_b16b_copay_ov_amt_max`	double
`pbp_b16b_copay_ov_amt_min`	double
`pbp_b16b_copay_ov_svcs`	string
`pbp_b16b_copay_ov_yn`	string
`pbp_b16b_copay_pc_amt`	double
`pbp_b16b_copay_pc_amt_max`	double
`pbp_b16b_copay_pc_amt_min`	double
`pbp_b16b_copay_pc_yn`	string
`pbp_b16b_copay_yesno`	string
`pbp_b16b_copay_yesno_pos`	string
`pbp_b16b_copay_yn`	string
`pbp_b16b_cost_share`	string
`pbp_b16b_cost_share_coins_max`	double
`pbp_b16b_cost_share_coins_min`	double
`pbp_b16b_cost_share_coins_yn`	string
`pbp_b16b_cost_share_copay_max`	double
`pbp_b16b_cost_share_copay_min`	double
`pbp_b16b_cost_share_copay_yn`	string
`pbp_b16b_ded_amt`	double
`pbp_b16b_ded_amt_pos`	double
`pbp_b16b_ded_pv_amt`	double
`pbp_b16b_ded_pv_yn`	string
`pbp_b16b_ded_yesno`	string
`pbp_b16b_ded_yesno_pos`	string
`pbp_b16b_ded_yn`	string
`pbp_b16b_maxbene_type`	string
`pbp_b16b_maxenr_amt`	double
`pbp_b16b_maxenr_amt_pos`	double
`pbp_b16b_maxenr_per`	string
`pbp_b16b_maxenr_per_desc`	string
`pbp_b16b_maxenr_pv_amt`	double
`pbp_b16b_maxenr_pv_per`	string
`pbp_b16b_maxenr_pv_per_desc`	string
`pbp_b16b_maxenr_pv_yn`	string
`pbp_b16b_maxenr_type`	string
`pbp_b16b_maxenr_type_pos`	string
`pbp_b16b_maxenr_yesno`	string
`pbp_b16b_maxenr_yesno_pos`	string
`pbp_b16b_maxenr_yn`	string
`pbp_b16b_maxplan_amt`	double
`pbp_b16b_maxplan_covb`	string
`pbp_b16b_maxplan_in_oon`	string
`pbp_b16b_maxplan_per`	string
`pbp_b16b_maxplan_per_desc`	string
`pbp_b16b_maxplan_pv_amt`	double
`pbp_b16b_maxplan_pv_in_oon`	string
`pbp_b16b_maxplan_pv_per`	string
`pbp_b16b_maxplan_pv_per_desc`	string
`pbp_b16b_maxplan_pv_yn`	string
`pbp_b16b_maxplan_type_pos`	string
`pbp_b16b_maxplan_yesno`	string
`pbp_b16b_maxplan_yesno_pos`	string
`pbp_b16b_maxplan_yn`	string
`pbp_b16b_maxpln_amt_pos`	double
`pbp_b16b_maxpln_cov_pos`	string
`pbp_b16b_maxpln_per_pos`	string
`pbp_b16b_refer_dx_yn`	string
`pbp_b16b_refer_ft_yn`	string
`pbp_b16b_refer_ods_yn`	string
`pbp_b16b_refer_oe_yn`	string
`pbp_b16b_refer_ops_yn`	string
`pbp_b16b_refer_pc_yn`	string
`pbp_b16b_refer_yn`	string
`pbp_b16c_auth_ags_yn`	string
`pbp_b16c_auth_end_yn`	string
`pbp_b16c_auth_impl_yn`	string
`pbp_b16c_auth_mxpr_yn`	string
`pbp_b16c_auth_omsg_yn`	string
`pbp_b16c_auth_orth_yn`	string
`pbp_b16c_auth_peri_yn`	string
`pbp_b16c_auth_prf_yn`	string
`pbp_b16c_auth_prm_yn`	string
`pbp_b16c_auth_rs_yn`	string
`pbp_b16c_bendesc_ags_amo`	string
`pbp_b16c_bendesc_ags_desc`	string
`pbp_b16c_bendesc_ags_lim`	string
`pbp_b16c_bendesc_ags_num`	double
`pbp_b16c_bendesc_ags_per`	string
`pbp_b16c_bendesc_end_amo`	string
`pbp_b16c_bendesc_end_desc`	string
`pbp_b16c_bendesc_end_lim`	string
`pbp_b16c_bendesc_end_num`	double
`pbp_b16c_bendesc_end_per`	string
`pbp_b16c_bendesc_impl_amo`	string
`pbp_b16c_bendesc_impl_desc`	string
`pbp_b16c_bendesc_impl_lim`	string
`pbp_b16c_bendesc_impl_num`	double
`pbp_b16c_bendesc_impl_per`	string
`pbp_b16c_bendesc_mxpr_amo`	string
`pbp_b16c_bendesc_mxpr_desc`	string
`pbp_b16c_bendesc_mxpr_lim`	string
`pbp_b16c_bendesc_mxpr_num`	double
`pbp_b16c_bendesc_mxpr_per`	string
`pbp_b16c_bendesc_omsg_amo`	string
`pbp_b16c_bendesc_omsg_desc`	string
`pbp_b16c_bendesc_omsg_lim`	string
`pbp_b16c_bendesc_omsg_num`	double
`pbp_b16c_bendesc_omsg_per`	string
`pbp_b16c_bendesc_orth_amo`	string
`pbp_b16c_bendesc_orth_desc`	string
`pbp_b16c_bendesc_orth_lim`	string
`pbp_b16c_bendesc_orth_num`	double
`pbp_b16c_bendesc_orth_per`	string
`pbp_b16c_bendesc_peri_amo`	string
`pbp_b16c_bendesc_peri_desc`	string
`pbp_b16c_bendesc_peri_lim`	string
`pbp_b16c_bendesc_peri_num`	double
`pbp_b16c_bendesc_peri_per`	string
`pbp_b16c_bendesc_prf_amo`	string
`pbp_b16c_bendesc_prf_desc`	string
`pbp_b16c_bendesc_prf_lim`	string
`pbp_b16c_bendesc_prf_num`	double
`pbp_b16c_bendesc_prf_per`	string
`pbp_b16c_bendesc_prm_amo`	string
`pbp_b16c_bendesc_prm_desc`	string
`pbp_b16c_bendesc_prm_lim`	string
`pbp_b16c_bendesc_prm_num`	double
`pbp_b16c_bendesc_prm_per`	string
`pbp_b16c_bendesc_rs_amo`	string
`pbp_b16c_bendesc_rs_desc`	string
`pbp_b16c_bendesc_rs_lim`	string
`pbp_b16c_bendesc_rs_num`	double
`pbp_b16c_bendesc_rs_per`	string
`pbp_b16c_coins_ags_pct`	double
`pbp_b16c_coins_ags_pct_max`	double
`pbp_b16c_coins_ags_pct_min`	double
`pbp_b16c_coins_ags_yn`	string
`pbp_b16c_coins_end_pct`	double
`pbp_b16c_coins_end_pct_max`	double
`pbp_b16c_coins_end_pct_min`	double
`pbp_b16c_coins_end_yn`	string
`pbp_b16c_coins_impl_pct`	double
`pbp_b16c_coins_impl_pct_max`	double
`pbp_b16c_coins_impl_pct_min`	double
`pbp_b16c_coins_impl_yn`	string
`pbp_b16c_coins_mxpr_pct`	double
`pbp_b16c_coins_mxpr_pct_max`	double
`pbp_b16c_coins_mxpr_pct_min`	double
`pbp_b16c_coins_mxpr_yn`	string
`pbp_b16c_coins_omsg_pct`	double
`pbp_b16c_coins_omsg_pct_max`	double
`pbp_b16c_coins_omsg_pct_min`	double
`pbp_b16c_coins_omsg_yn`	string
`pbp_b16c_coins_orth_pct`	double
`pbp_b16c_coins_orth_pct_max`	double
`pbp_b16c_coins_orth_pct_min`	double
`pbp_b16c_coins_orth_yn`	string
`pbp_b16c_coins_peri_pct`	double
`pbp_b16c_coins_peri_pct_max`	double
`pbp_b16c_coins_peri_pct_min`	double
`pbp_b16c_coins_peri_yn`	string
`pbp_b16c_coins_prf_pct`	double
`pbp_b16c_coins_prf_pct_max`	double
`pbp_b16c_coins_prf_pct_min`	double
`pbp_b16c_coins_prf_yn`	string
`pbp_b16c_coins_prm_pct`	double
`pbp_b16c_coins_prm_pct_max`	double
`pbp_b16c_coins_prm_pct_min`	double
`pbp_b16c_coins_prm_yn`	string
`pbp_b16c_coins_rs_pct`	double
`pbp_b16c_coins_rs_pct_max`	double
`pbp_b16c_coins_rs_pct_min`	double
`pbp_b16c_coins_rs_yn`	string
`pbp_b16c_copay_ags_amt`	double
`pbp_b16c_copay_ags_amt_max`	double
`pbp_b16c_copay_ags_amt_min`	double
`pbp_b16c_copay_ags_yn`	string
`pbp_b16c_copay_end_amt`	double
`pbp_b16c_copay_end_amt_max`	double
`pbp_b16c_copay_end_amt_min`	double
`pbp_b16c_copay_end_yn`	string
`pbp_b16c_copay_impl_amt`	double
`pbp_b16c_copay_impl_amt_max`	double
`pbp_b16c_copay_impl_amt_min`	double
`pbp_b16c_copay_impl_yn`	string
`pbp_b16c_copay_mxpr_amt`	double
`pbp_b16c_copay_mxpr_amt_max`	double
`pbp_b16c_copay_mxpr_amt_min`	double
`pbp_b16c_copay_mxpr_yn`	string
`pbp_b16c_copay_omsg_amt`	double
`pbp_b16c_copay_omsg_amt_max`	double
`pbp_b16c_copay_omsg_amt_min`	double
`pbp_b16c_copay_omsg_yn`	string
`pbp_b16c_copay_orth_amt`	double
`pbp_b16c_copay_orth_amt_max`	double
`pbp_b16c_copay_orth_amt_min`	double
`pbp_b16c_copay_orth_yn`	string
`pbp_b16c_copay_peri_amt`	double
`pbp_b16c_copay_peri_amt_max`	double
`pbp_b16c_copay_peri_amt_min`	double
`pbp_b16c_copay_peri_yn`	string
`pbp_b16c_copay_prf_amt`	double
`pbp_b16c_copay_prf_amt_max`	double
`pbp_b16c_copay_prf_amt_min`	double
`pbp_b16c_copay_prf_yn`	string
`pbp_b16c_copay_prm_amt`	double
`pbp_b16c_copay_prm_amt_max`	double
`pbp_b16c_copay_prm_amt_min`	double
`pbp_b16c_copay_prm_yn`	string
`pbp_b16c_copay_rs_amt`	double
`pbp_b16c_copay_rs_amt_max`	double
`pbp_b16c_copay_rs_amt_min`	double
`pbp_b16c_copay_rs_yn`	string
`pbp_b16c_ded_cmp_amt`	double
`pbp_b16c_ded_cmp_yn`	string
`pbp_b16c_maxenr_cmp_amt`	double
`pbp_b16c_maxenr_cmp_per`	string
`pbp_b16c_maxenr_cmp_per_desc`	string
`pbp_b16c_maxenr_cmp_type`	string
`pbp_b16c_maxenr_cmp_yn`	string
`pbp_b16c_maxplan_cmp_amt`	double
`pbp_b16c_maxplan_cmp_in_oon`	string
`pbp_b16c_maxplan_cmp_per`	string
`pbp_b16c_maxplan_cmp_per_desc`	string
`pbp_b16c_maxplan_cmp_type`	string
`pbp_b16c_maxplan_cmp_yn`	string
`pbp_b16c_refer_ags_yn`	string
`pbp_b16c_refer_end_yn`	string
`pbp_b16c_refer_impl_yn`	string
`pbp_b16c_refer_mxpr_yn`	string
`pbp_b16c_refer_omsg_yn`	string
`pbp_b16c_refer_orth_yn`	string
`pbp_b16c_refer_peri_yn`	string
`pbp_b16c_refer_prf_yn`	string
`pbp_b16c_refer_prm_yn`	string
`pbp_b16c_refer_rs_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_b16b_maxplan_csg_groups`	string
`pbp_b16b_maxplan_excl_csg_yn`	string
`pbp_b16c_maxplan_csg_groups`	string
`pbp_b16c_maxplan_excl_csg_yn`	string

Query it

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