# CMS CCIIO Benefits & Cost Sharing PUF — Marketplace benefit-template history

`medicare_semantic.vw_benefits_cost_sharing_current` · Insurer negotiated rates · status live · 19,692,051 rows

CMS Marketplace plan-variant benefit, coverage, raw cost-sharing, limit, exclusion, EHB-variance, and MOOP-exclusion text across PY2014-PY2026. The served view selects the latest reviewed revision for each business year and maps each era's ordered raw-cell array to named raw-text columns without amount parsing or blank-to-zero coercion.

**Grain.** One publisher benefit row of the current selected revision, keyed by (business_year, plan_id, benefit_name, source_row_number). A plan may list the same benefit more than once (e.g. per tier or cost-sharing variant); every such row is preserved — no plan/benefit collapse. The underlying physical history remains one row per source, year, member SHA-256, archive member, and source-row ordinal across all revisions.

| column | type | meaning |
|---|---|---|
| business_year | int |  |
| state_code | string |  |
| issuer_id | string |  |
| source_name | string |  |
| import_date | string |  |
| standard_component_id | string |  |
| plan_id | string |  |
| benefit_name | string |  |
| version_num | string |  |
| publisher_row_number | string |  |
| copay_inn_tier1_raw | string |  |
| copay_inn_tier2_raw | string |  |
| copay_out_of_net_raw | string |  |
| coins_inn_tier1_raw | string |  |
| coins_inn_tier2_raw | string |  |
| coins_out_of_net_raw | string |  |
| is_ehb_raw | string |  |
| is_covered_raw | string |  |
| quant_limit_on_svc_raw | string |  |
| limit_qty_raw | string |  |
| limit_unit_raw | string |  |
| minimum_stay_raw | string |  |
| exclusions_raw | string |  |
| explanation_raw | string |  |
| ehb_var_reason_raw | string |  |
| is_state_mandate_raw | string |  |
| is_subj_to_ded_tier1_raw | string |  |
| is_subj_to_ded_tier2_raw | string |  |
| is_excl_from_inn_moop_raw | string |  |
| is_excl_from_oon_moop_raw | string |  |
| schema_era | string |  |
| source_row_number | bigint |  |
| raw_row_sha256 | string |  |
| artifact_id | string |  |
| archive_member | string |  |
| archive_member_sha256 | string |  |
| cms_vintage_sequence | int |  |
| asserted_at | date |  |
| observed_period | date |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| raw_values_json | string |  |
| ordered_header_json | string |  |

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