# MA pbp mrx, current parse revision per year and quarter

`medicare_silver.vw_pbp_mrx_current_v20261013a` · Medicare Advantage, Part D, Medicaid · status partial · 270,466 rows

The read side of the append-only pbp_mrx contract (#3630): a parser fix for unchanged CMS bytes is appended as a new parse_revision of its (report_year, quarter) slice, never written over it, and this view returns only each slice's latest revision, so a superseded parse is never read beside its correction. Defined in pipelines/medicare/semantic/pbp/adhoc_views/vw_pbp_mrx_current_v20261013a.sql.

**Grain.** The rows of medicare_silver.pbp_mrx of each (report_year, quarter) slice's latest parse_revision, plus slice_latest_parse_revision: 270,466 rows on 2026-10-13, equal to the table while no slice holds two revisions (Athena 057d2d5a).

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| version | double |  |
| report_year | double |  |
| quarter | double |  |
| bid_id | string |  |
| max_rai_ann_partd_rew_amt_1rx | double |  |
| max_rai_ann_partd_rew_amt_2rx | double |  |
| max_rai_ann_partd_rew_amt_3rx | double |  |
| max_rai_frq_rew_incent_1rx | string |  |
| max_rai_frq_rew_incent_2rx | string |  |
| max_rai_frq_rew_incent_3rx | string |  |
| max_rai_partd_rew_inc_amt_1rx | double |  |
| max_rai_partd_rew_inc_amt_2rx | double |  |
| max_rai_partd_rew_inc_amt_3rx | double |  |
| mrx_ae_copay_lesser_yn | string |  |
| mrx_ae_cstshr_apply | string |  |
| mrx_ae_cstshr_grps | double |  |
| mrx_ae_oon_cstshr_struct | string |  |
| mrx_ae_ooptcs_apply | string |  |
| mrx_ae_ot_grps | double |  |
| mrx_alt_copay_lesser_yn | string |  |
| mrx_alt_cov_lmt_amt | double |  |
| mrx_alt_cov_lmt_yn | string |  |
| mrx_alt_cstshr_post_oopt | string |  |
| mrx_alt_cstshr_post_oopt_mmp | string |  |
| mrx_alt_ded_amount | double |  |
| mrx_alt_ded_charge | string |  |
| mrx_alt_ded_tier_cstshr_yn | string |  |
| mrx_alt_ded_type_yn | string |  |
| mrx_alt_drug_type | string |  |
| mrx_alt_excl_drugs_maxplan_yn | string |  |
| mrx_alt_excl_drugs_yn | string |  |
| mrx_alt_excl_max_plan_amt | double |  |
| mrx_alt_fulfill_desc | string |  |
| mrx_alt_gap_covg_brand | string |  |
| mrx_alt_gap_covg_gen | string |  |
| mrx_alt_gap_covg_tier | string |  |
| mrx_alt_gap_covg_yn | string |  |
| mrx_alt_gap_drug_type | string |  |
| mrx_alt_gen_coins_pct | double |  |
| mrx_alt_gen_copay_amt | double |  |
| mrx_alt_gen_cstshr_struct | string |  |
| mrx_alt_ira_covg_tier | string |  |
| mrx_alt_lim_amt | double |  |
| mrx_alt_max_enroll_mmp_amt | double |  |
| mrx_alt_max_enroll_mmp_yn | string |  |
| mrx_alt_no_ded_tier | string |  |
| mrx_alt_oon_cstshr_struct | string |  |
| mrx_alt_post_icl_yn | string |  |
| mrx_alt_pre_icl_cost_share | string |  |
| mrx_alt_pre_icl_cost_share_mmp | string |  |
| mrx_alt_pre_icl_exclud_only_yn | string |  |
| mrx_alt_pre_icl_lis_mmp_tiers | string |  |
| mrx_alt_pre_icl_lis_mmp_yn | string |  |
| mrx_alt_red_cost_sharing | string |  |
| mrx_alt_red_cost_sharing_items | string |  |
| mrx_auth_ynba | string |  |
| mrx_avg_exp_cost_share_attest | string |  |
| mrx_b_auth_yn | string |  |
| mrx_b_coins_amt_maacqcost | double |  |
| mrx_b_coins_awp_disc | double |  |
| mrx_b_coins_covbasis | string |  |
| mrx_b_coins_max_dispfee | double |  |
| mrx_b_coins_min_dispfee | double |  |
| mrx_b_coins_pct | double |  |
| mrx_b_coins_prp_disc | double |  |
| mrx_b_coins_yn | string |  |
| mrx_b_copay_max_amt | double |  |
| mrx_b_copay_min_amt | double |  |
| mrx_b_copay_yn | string |  |
| mrx_b_ded_amt | double |  |
| mrx_b_ded_yn | string |  |
| mrx_b_max_oop_amt | double |  |
| mrx_b_max_oop_per | string |  |
| mrx_b_max_oop_yn | string |  |
| mrx_ba_cov_lmt_amt | double |  |
| mrx_ba_cov_lmt_yn | string |  |
| mrx_ba_cstshr_apply | string |  |
| mrx_ba_cstshr_grps | double |  |
| mrx_ba_ded_amount | double |  |
| mrx_ba_ded_charge | string |  |
| mrx_ba_ooptcs_apply | string |  |
| mrx_ba_ot_grps | double |  |
| mrx_basic_plan_yn | string |  |
| mrx_basic_plan_zero_prem_yn | string |  |
| mrx_benefit_type | string |  |
| mrx_ceiling_price_yn | string |  |
| mrx_d_adher_goal | string |  |
| mrx_d_adher_goal_desc | string |  |
| mrx_d_elig_freq_other | string |  |
| mrx_d_eligcrit_chk | string |  |
| mrx_d_eligcrit_other | string |  |
| mrx_d_pmm_flex_chk | string |  |
| mrx_d_red_cs_lisb_detail | string |  |
| mrx_d_ri_amt | double |  |
| mrx_d_ri_elig_rdo | string |  |
| mrx_d_ri_max_amt | double |  |
| mrx_d_ri_type_chk | string |  |
| mrx_d_ri_type_other | string |  |
| mrx_demo_type | string |  |
| mrx_demo_yn | string |  |
| mrx_drug_ben_yn | string |  |
| mrx_ea_cov_lmt_amt | double |  |
| mrx_ea_cov_lmt_yn | string |  |
| mrx_ea_cstshr_apply | string |  |
| mrx_ea_cstshr_group | double |  |
| mrx_ea_cstshr_group_sec | double |  |
| mrx_ea_cstshr_grps | double |  |
| mrx_ea_cstshr_post_oopt | string |  |
| mrx_ea_cstshr_post_oopt_sec | string |  |
| mrx_ea_ded_amount | double |  |
| mrx_ea_ded_charge | string |  |
| mrx_ea_oop_th_amt | double |  |
| mrx_ea_oop_th_amt_sec | double |  |
| mrx_ea_oop_th_yn | string |  |
| mrx_ea_oop_th_yn_sec | string |  |
| mrx_ea_sec_covlmt_icl_amt | double |  |
| mrx_ea_sec_covlmt_icl_yn | string |  |
| mrx_excluded_tiers_yn | string |  |
| mrx_first_fill | string |  |
| mrx_floor_price_yn | string |  |
| mrx_form_model_desc | string |  |
| mrx_form_model_type | string |  |
| mrx_form_tier_model_2 | string |  |
| mrx_form_tier_model_2_mmp | string |  |
| mrx_form_tier_model_3 | string |  |
| mrx_form_tier_model_3_mmp | string |  |
| mrx_form_tier_model_4 | string |  |
| mrx_form_tier_model_4_mmp | string |  |
| mrx_form_tier_model_5 | string |  |
| mrx_form_tier_model_5_mmp | string |  |
| mrx_form_tier_model_5_opt1 | string |  |
| mrx_form_tier_model_5_opt2 | string |  |
| mrx_form_tier_model_5_opt3 | string |  |
| mrx_form_tier_model_5_opt4 | string |  |
| mrx_form_tier_model_5_opt5 | string |  |
| mrx_form_tier_model_5_opt6 | string |  |
| mrx_form_tier_model_6 | string |  |
| mrx_form_tier_model_6_mmp | string |  |
| mrx_form_tier_model_6_opt1 | string |  |
| mrx_form_tier_model_6_opt2 | string |  |
| mrx_form_tier_model_6_opt3 | string |  |
| mrx_form_tier_model_6_opt4 | string |  |
| mrx_form_tier_model_6_opt5 | string |  |
| mrx_formulary_tiers_num | string |  |
| mrx_formulary_yn | string |  |
| mrx_free_gnrc_max_amt | double |  |
| mrx_free_gnrc_yn | string |  |
| mrx_gen_extd_first_fill | string |  |
| mrx_gen_in_1m | double |  |
| mrx_gen_in_2m | double |  |
| mrx_gen_in_3m | double |  |
| mrx_gen_innpp_1m | double |  |
| mrx_gen_innpp_2m | double |  |
| mrx_gen_innpp_3m | double |  |
| mrx_gen_innpp_os | double |  |
| mrx_gen_inp_1m | double |  |
| mrx_gen_inp_2m | double |  |
| mrx_gen_inp_3m | double |  |
| mrx_gen_inp_os | double |  |
| mrx_gen_inpp_1m | double |  |
| mrx_gen_inpp_2m | double |  |
| mrx_gen_inpp_3m | double |  |
| mrx_gen_inpp_os | double |  |
| mrx_gen_ira_ltcp_coins_1m | double |  |
| mrx_gen_ira_ltcp_copay_1m | double |  |
| mrx_gen_ira_mostd_coins_1m | double |  |
| mrx_gen_ira_mostd_coins_2m | double |  |
| mrx_gen_ira_mostd_coins_3m | double |  |
| mrx_gen_ira_mostd_copay_1m | double |  |
| mrx_gen_ira_mostd_copay_2m | double |  |
| mrx_gen_ira_mostd_copay_3m | double |  |
| mrx_gen_ira_oonp_coins_1m | double |  |
| mrx_gen_ira_oonp_coins_othnum | double |  |
| mrx_gen_ira_oonp_copay_1m | double |  |
| mrx_gen_ira_oonp_copay_othnum | double |  |
| mrx_gen_ira_rstd_coins_1m | double |  |
| mrx_gen_ira_rstd_coins_2m | double |  |
| mrx_gen_ira_rstd_coins_3m | double |  |
| mrx_gen_ira_rstd_copay_1m | double |  |
| mrx_gen_ira_rstd_copay_2m | double |  |
| mrx_gen_ira_rstd_copay_3m | double |  |
| mrx_gen_loc | string |  |
| mrx_gen_loc_in | string |  |
| mrx_gen_loc_inp | string |  |
| mrx_gen_loc_ltc | string |  |
| mrx_gen_loc_mo | string |  |
| mrx_gen_loc_mop | string |  |
| mrx_gen_loc_mostd | string |  |
| mrx_gen_loc_oon | string |  |
| mrx_gen_loc_rstd | string |  |
| mrx_gen_ltc_1m | double |  |
| mrx_gen_ltcp_1m | double |  |
| mrx_gen_ltcp_b_1m | double |  |
| mrx_gen_ltcp_b_os | double |  |
| mrx_gen_ltcp_g_1m | double |  |
| mrx_gen_ltcp_g_os | double |  |
| mrx_gen_mo_1m | double |  |
| mrx_gen_mo_2m | double |  |
| mrx_gen_mo_3m | double |  |
| mrx_gen_mo_os | double |  |
| mrx_gen_monpp_1m | double |  |
| mrx_gen_monpp_2m | double |  |
| mrx_gen_monpp_3m | double |  |
| mrx_gen_monpp_os | double |  |
| mrx_gen_mop_1m | double |  |
| mrx_gen_mop_2m | double |  |
| mrx_gen_mop_3m | double |  |
| mrx_gen_mopp_1m | double |  |
| mrx_gen_mopp_2m | double |  |
| mrx_gen_mopp_3m | double |  |
| mrx_gen_mopp_os | double |  |
| mrx_gen_mostd_1m | double |  |
| mrx_gen_mostd_2m | double |  |
| mrx_gen_mostd_3m | double |  |
| mrx_gen_oon_1m | double |  |
| mrx_gen_oon_os | double |  |
| mrx_gen_oonp_1m | double |  |
| mrx_gen_oonp_3m | double |  |
| mrx_gen_oonp_os | double |  |
| mrx_gen_rstd_1m | double |  |
| mrx_gen_rstd_2m | double |  |
| mrx_gen_rstd_3m | double |  |
| mrx_grp_coins_yn | string |  |
| mrx_grp_copay_yn | string |  |
| mrx_grp_id | string |  |
| mrx_grp_innpp_1m_num | double |  |
| mrx_grp_innpp_3m_num | double |  |
| mrx_grp_innpp_coins_1m | double |  |
| mrx_grp_innpp_coins_3m | double |  |
| mrx_grp_innpp_coins_os | double |  |
| mrx_grp_innpp_copay_1m | double |  |
| mrx_grp_innpp_copay_3m | double |  |
| mrx_grp_innpp_copay_os | double |  |
| mrx_grp_innpp_othnum | double |  |
| mrx_grp_innpp_presup | string |  |
| mrx_grp_inpp_1m_num | double |  |
| mrx_grp_inpp_3m_num | double |  |
| mrx_grp_inpp_co_num | double |  |
| mrx_grp_inpp_coins_1m | double |  |
| mrx_grp_inpp_coins_3m | double |  |
| mrx_grp_inpp_coins_os | double |  |
| mrx_grp_inpp_copay_1m | double |  |
| mrx_grp_inpp_copay_3m | double |  |
| mrx_grp_inpp_copay_os | double |  |
| mrx_grp_inpp_ps | string |  |
| mrx_grp_lbl | string |  |
| mrx_grp_lbl1 | string |  |
| mrx_grp_lbl2 | string |  |
| mrx_grp_locat | string |  |
| mrx_grp_mo_1m_num | double |  |
| mrx_grp_mo_3m_num | double |  |
| mrx_grp_mo_coins_1m | double |  |
| mrx_grp_mo_coins_3m | double |  |
| mrx_grp_mo_coins_os | double |  |
| mrx_grp_mo_copay_1m | double |  |
| mrx_grp_mo_copay_3m | double |  |
| mrx_grp_mo_copay_os | double |  |
| mrx_grp_mo_othnum | double |  |
| mrx_grp_mo_presup | string |  |
| mrx_grp_oonp_1m_num | double |  |
| mrx_grp_oonp_3m_num | double |  |
| mrx_grp_oonp_coins_1m | double |  |
| mrx_grp_oonp_coins_3m | double |  |
| mrx_grp_oonp_coins_os | double |  |
| mrx_grp_oonp_copay_1m | double |  |
| mrx_grp_oonp_copay_3m | double |  |
| mrx_grp_oonp_copay_os | double |  |
| mrx_grp_oonp_othnumn | double |  |
| mrx_grp_oonp_presup | string |  |
| mrx_grp_tier_lbl1 | string |  |
| mrx_grp_tier_lbl2 | string |  |
| mrx_grp_tierlbl | string |  |
| mrx_grp_type | string |  |
| mrx_grp_type_id | string |  |
| mrx_innpp_1m_num | double |  |
| mrx_innpp_3m_num | double |  |
| mrx_innpp_othnum | double |  |
| mrx_innpp_presup | string |  |
| mrx_inpp_1m_num | double |  |
| mrx_inpp_3m_num | double |  |
| mrx_inpp_co_num | double |  |
| mrx_inpp_ps | string |  |
| mrx_insulin_attest | string |  |
| mrx_limit_ofc_yn | string |  |
| mrx_locat | string |  |
| mrx_ltc_attest_flag | string |  |
| mrx_mo_1m_num | double |  |
| mrx_mo_3m_num | double |  |
| mrx_mo_othnum | double |  |
| mrx_mo_presup | string |  |
| mrx_nat_rx_cov_yn | string |  |
| mrx_oonp_1m_num | double |  |
| mrx_oonp_3m_num | double |  |
| mrx_oonp_othnumn | double |  |
| mrx_oonp_presup | string |  |
| mrx_otc_meds_attest_flag | string |  |
| mrx_otc_meds_pay_ump_yn | string |  |
| mrx_otc_step_therapy_yn | string |  |
| mrx_partd_network_loc | string |  |
| mrx_pen_lessexpen_yn | string |  |
| mrx_pen_oonpharm_yn | string |  |
| mrx_post_exclud_only_yn | string |  |
| mrx_pro_part_fill | string |  |
| mrx_ptd_nat_avg | double |  |
| mrx_quantity_limits | string |  |
| mrx_rai_adh_goal_notes_1rx | string |  |
| mrx_rai_adh_goal_notes_2rx | string |  |
| mrx_rai_adh_goal_notes_3rx | string |  |
| mrx_rai_elig_crit_1rx | string |  |
| mrx_rai_elig_crit_2rx | string |  |
| mrx_rai_elig_crit_3rx | string |  |
| mrx_rai_elig_crit_notes_1rx | string |  |
| mrx_rai_elig_crit_notes_2rx | string |  |
| mrx_rai_elig_crit_notes_3rx | string |  |
| mrx_rai_frq_ri_desc_1rx | string |  |
| mrx_rai_frq_ri_desc_2rx | string |  |
| mrx_rai_frq_ri_desc_3rx | string |  |
| mrx_rai_meet_adh_goal_yn_1rx | string |  |
| mrx_rai_meet_adh_goal_yn_2rx | string |  |
| mrx_rai_meet_adh_goal_yn_3rx | string |  |
| mrx_rai_num_partd_offrd | string |  |
| mrx_rai_off_rew_incent_yn | string |  |
| mrx_rai_rew_inc_notes_1rx | string |  |
| mrx_rai_rew_inc_notes_2rx | string |  |
| mrx_rai_rew_inc_notes_3rx | string |  |
| mrx_rai_type_partd_rew_1rx | string |  |
| mrx_rai_type_partd_rew_2rx | string |  |
| mrx_rai_type_partd_rew_3rx | string |  |
| mrx_reduct_cost_yn | string |  |
| mrx_snp_zerocost_attest | string |  |
| mrx_sp_access_yn | string |  |
| mrx_step_ther_drugs_yn | string |  |
| mrx_tier_extd_days_gen_yn | string |  |
| mrx_tier_form_ex | string |  |
| mrx_tier_form_ex_2 | double |  |
| mrx_tier_form_ex_2_yn | string |  |
| mrx_tier_group_num | double |  |
| mrx_v_bid_attestation | string |  |
| mrx_vaccine_attest | string |  |
| orgtype | string |  |
| part_d_enhncd_cvrg_demo | string |  |
| part_d_model_demo | string |  |
| pbp_a_ben_cov | string |  |
| pbp_a_plan_type | 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 |  |
| source_row_ordinal | double |  |
| mrx_bal_model_attest | string |  |
| mrx_bal_opt_flex | string |  |
| mrx_bal_opt_flex_other_desc | string |  |
| mrx_balance_covg_tier | string |  |
| mrx_balance_cstshr_struc_type | string |  |
| mrx_balance_deductible_amt | double |  |
| mrx_balance_deductible_opt | string |  |
| mrx_balance_extended_tier | string |  |
| mrx_balance_mo_tier | string |  |
| mrx_dsnp_buydown_attest | string |  |
| slice_latest_parse_revision | int |  |

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