Medicare Advantage, Part D, Medicaid

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

medicare_silver.ma_plan_payment_part_c_v2·live·silver

Rows

65,872

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS 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).
2Parser 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

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

Columns (15)

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

Query it

describe_data_source(source_fqn="medicare_silver.ma_plan_payment_part_c_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_plan_payment_part_c_v2 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	get_quality_bonus
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_silver.ma_plan_payment_part_c_v2")`
Raw door	Tools: get_plan_payment, get_ma_plan_payment; Athena: medicare_silver.ma_plan_payment_part_c_v2 (pin payment_year)
Note	Wave-1A reload (Data Tracker, docs/data-tracker/RELOAD-PLAN-WAVE1A-MA-LOADERS-2026-10-01.md, defects MAPAY-2/-4). Versioned, never overwritten; the legacy card stays live as the rollback.

This page as markdown: /docs-md/data/medicare_silver_ma_plan_payment_part_c_v2.md · every page in one file: /llms-full.txt