Insurer negotiated rates

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

medicare_semantic.vw_benefits_cost_sharing_current·live·semantic_view·Individual Exchange

Rows

19,692,051

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS Marketplace plan-variant benefit, coverage, raw cost-sharing, limit, exclusion, EHB-variance, and MOOP-exclusion text across PY2014-PY2026.
2The 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

Key	Grain
N/A	1One publisher benefit row of the current selected revision, keyed by (business_year, plan_id, benefit_name, source_row_number). 2A 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. 3The underlying physical history remains one row per source, year, member SHA-256, archive member, and source-row ordinal across all revisions.

Key

Grain

N/A

1One publisher benefit row of the current selected revision, keyed by (business_year, plan_id, benefit_name, source_row_number).
2A 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.
3The underlying physical history remains one row per source, year, member SHA-256, archive member, and source-row ordinal across all revisions.

Columns (43)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`business_year,plan_id,benefit_name,source_row_number`
Join	`how_to_join(source_fqn="medicare_semantic.vw_benefits_cost_sharing_current")`
Raw door	query_substrate (read-only SQL) over medicare_semantic.vw_benefits_cost_sharing_current. Revision-history access to medicare_silver.fact_benefits_cost_sharing_puf_history requires a separate operator-approved entitlement.
Note	The physical history table contains 45,082,577 rows across PY2014-PY2026 and all reviewed revisions; the served view surfaces the 19,692,051-row current selection. The served view maps 32-column PY2014-PY2015 display headers, the 30-column PY2016 compact header, and the 24-column PY2017-PY2026 header through ordered_header_json plus raw_values_json. The view DDL is deployed to medicare_semantic and count-verified (2026-07-17); this change entitles the served FQN.

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