# PBP optional supplemental packages (cleaned view)

`medicare_semantic.vw_pbp_optional_package` · Medicare Advantage, Part D, Medicaid · status live · 51,694 rows

Optional supplemental packages (extra premium, opt-in) per plan and plan year from PBP section D-OPT, 2018 on; also reads the step 16/17b/18b worksheets where the package detail lives.

**Grain.** One row per (contract_id, plan_id, segment_id, report_year, quarter, benefit_category) cleaned row.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| version | double |  |
| report_year | double |  |
| quarter | double |  |
| benefit_category | string |  |
| cost_share_string | string |  |
| copay_amount | double |  |
| coinsurance_pct | double |  |
| limit_text | string |  |
| auth_required | boolean |  |
| referral_required | boolean |  |
| network_type | varchar(14) |  |
| max_oop_applies | boolean |  |
| limit_quantity | double |  |
| limit_unit | string |  |
| limit_period_code | string |  |
| limit_period_label | string |  |
| limit_quantity_per_year | double |  |
| benefit_amount | double |  |
| benefit_amount_kind | string |  |
| benefit_amount_period_code | string |  |
| benefit_amount_period_label | string |  |
| benefit_amount_annualized | double |  |
| benefit_amount_pmpm | double |  |
| normalization_status | varchar(41) |  |
| normalization_basis | varchar(20) |  |
| aggregation_policy | varchar(40) |  |
| offered_status | varchar(15) |  |
| numeric_amount_observability | varchar(31) |  |
| null_amount_reason | varchar(30) |  |
| annualization_policy | varchar(17) |  |
| combined_limit_policy | varchar(29) |  |
| consumer_document_reconciliation_status | varchar(11) |  |
| confidence_tier | varchar(23) |  |
| optional_base_benefit_code | string |  |
| optional_base_benefit_label | string |  |
| optional_base_category | string |  |
| optional_base_l2_id | string |  |
| optional_benefit_type_code | string |  |
| optional_benefit_type_label | string |  |
| optional_coinsurance_pct_max | double |  |
| optional_coinsurance_pct_min | double |  |
| optional_copay_amount_max | double |  |
| optional_copay_amount_min | double |  |
| optional_cost_share_basis | string |  |
| optional_cost_share_same_as_mandatory | boolean |  |
| optional_cost_share_tiers_code | string |  |
| optional_day_interval1_begin_day | double |  |
| optional_day_interval1_end_day | double |  |
| optional_day_interval_count | double |  |
| optional_limit_unlimited | boolean |  |
| optional_maxplan_in_oon_code | string |  |
| optional_oon_offered | boolean |  |
| optional_oon_same_as_in_network | boolean |  |
| optional_oon_type_id | string |  |
| optional_package_benefit_codes | string |  |
| optional_package_deductible_amount | double |  |
| optional_package_detail_level | varchar(22) |  |
| optional_package_id | string |  |
| optional_package_in_latest_roster | boolean |  |
| optional_package_includes_dental | boolean |  |
| optional_package_includes_hearing | boolean |  |
| optional_package_includes_vision | boolean |  |
| optional_package_name | string |  |
| optional_package_offered | boolean |  |
| optional_package_premium_monthly | double |  |
| optional_package_sub_benefit | string |  |
| optional_package_targeting | varchar(28) |  |
| optional_per_ear_code | string |  |
| optional_service_detail | string |  |
| optional_service_maxplan_amount | double |  |
| optional_service_maxplan_period_code | string |  |
| source_amount_column | string |  |
| source_pbp_section | string |  |
| source_silver_table | string |  |
| lmi_authorities | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |

Tools that read it: get_pbp_benefit

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