# MA plan payment, Part C (contract x plan x year), parser 0.4.0

`medicare_silver.ma_plan_payment_part_c_v2` · Medicare Advantage, Part D, Medicaid · status live · 65,872 rows

CMS Part C plan-payment summary per MA contract, plan and payment year: the average A/B payment PMPM standardized to a 1.0 risk score (avg_ab_pmpm_payment, an amount, not the benchmark and not dollars paid), the average Part C risk score and the average rebate PMPM, plus the average MSA monthly deposit (2006-2012). Parser 0.4.0 reload of the same CMS workbooks; get_plan_payment and get_ma_plan_payment read this table from 2026-10-05.

**Grain.** One row per (payment_year, contract_id, plan_id). 65,872 rows over 19 payment years 2006-2024, the served table's rows one for one (Athena 09c33b17, 2441fad6).

| column | type | meaning |
|---|---|---|
| payment_year | int |  |
| contract_id | string |  |
| plan_id | string |  |
| contract_name | string |  |
| plan_type | string |  |
| avg_ab_pmpm_payment | double |  |
| avg_part_c_risk_score | double |  |
| avg_rebate_pmpm_payment | double |  |
| avg_msa_monthly_deposit_pmpm | double |  |
| contract_level_row | boolean |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| bronze_publication_id | string |  |
| asserted_at | timestamp |  |
| parser_artifact_hash | string |  |

Tools that read it: get_quality_bonus

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