# PBP plan deductible (cleaned view)

`medicare_semantic.vw_pbp_plan_deductible` · Medicare Advantage, Part D, Medicaid · status live · 163,670 rows

Plan-level deductible per plan, segment and plan year from PBP section D, era-normalized.

**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(26) |  |
| 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 | varchar(18) |  |
| benefit_amount_period_code | varchar(6) |  |
| benefit_amount_period_label | varchar(8) |  |
| benefit_amount_annualized | double |  |
| benefit_amount_pmpm | double |  |
| normalization_status | varchar(30) |  |
| normalization_basis | varchar(31) |  |
| aggregation_policy | varchar(38) |  |
| 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) |  |
| annual_deductible | boolean |  |
| annual_deductible_amount | double |  |
| annual_deductible_amount_type_code | string |  |
| annual_deductible_amount_type_label | varchar(79) |  |
| annual_deductible_benefit_groups | string |  |
| annual_deductible_combined_application_code | string |  |
| annual_deductible_combined_application_label | varchar(61) |  |
| annual_in_network_medicare_all_services | boolean |  |
| annual_in_network_medicare_categories | string |  |
| annual_in_network_non_medicare_all_services | boolean |  |
| annual_in_network_non_medicare_categories | string |  |
| annual_oon_zero_dollar_preventive_included | boolean |  |
| annual_out_of_network_non_medicare_all_services | boolean |  |
| annual_out_of_network_non_medicare_categories | string |  |
| applies_part_b_deductible | boolean |  |
| combined_deductible_benefit_groups | string |  |
| combined_in_network_medicare_all_services | boolean |  |
| combined_in_network_medicare_categories | string |  |
| combined_network_deductible | boolean |  |
| combined_network_deductible_amount | double |  |
| combined_out_of_network_medicare_all_services | boolean |  |
| combined_out_of_network_medicare_categories | string |  |
| combined_part_b_deductible | boolean |  |
| deductible_amount | double |  |
| deductible_amount_basis | string |  |
| deductible_amount_resolved | double |  |
| deductible_form | varchar(30) |  |
| deductible_scope | varchar(33) |  |
| differential_deductible | boolean |  |
| differential_deductible_categories | string |  |
| has_medical_deductible | boolean |  |
| in_network_deductible | boolean |  |
| in_network_deductible_amount | double |  |
| in_network_deductible_benefit_groups | string |  |
| in_network_medicare_all_services | boolean |  |
| in_network_medicare_categories | string |  |
| in_network_non_medicare_all_services | boolean |  |
| in_network_non_medicare_categories | string |  |
| in_network_part_b_deductible | boolean |  |
| mandatory_supplemental_deductible | boolean |  |
| mandatory_supplemental_deductible_categories | string |  |
| medical_deductible_amount | double |  |
| msa_deductible_amount | double |  |
| non_network_deductible | boolean |  |
| original_medicare_deductible_kind | varchar(35) |  |
| out_of_network_deductible | boolean |  |
| out_of_network_deductible_amount | double |  |
| out_of_network_deductible_benefit_groups | string |  |
| out_of_network_medicare_all_services | boolean |  |
| out_of_network_medicare_categories | string |  |
| out_of_network_part_b_deductible | boolean |  |
| part_a_deductible_amount_resolved | double |  |
| part_b_deductible_amount_resolved | double |  |
| plan_deductible_present | boolean |  |
| plan_deductible_sub_benefit | string |  |
| source_pbp_section | varchar(1) |  |
| source_silver_table | varchar(29) |  |
| 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_plan_deductible WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_pbp_plan_deductible")` first.