Insurer negotiated rates

Commercial Insurer MLR — issuer identity / NAIC crosswalk (CMS MLR PUF)

insurer_silver.dim_insurer_mlr_identity·live·silver

Rows

20,336

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The free entity crosswalk the CMS MLR PUF carries: hios_issuer_id, naic_group_code, naic_company_code, federal_ein, company_name, group_affiliation, dba_marketing_name per submission.
2Resolves an MLR financial filing to a payer BRAND + NAIC — the join key connecting insurer financials to negotiated rates (dim_payer).

Grain

Key	Grain
N/A	1One row per (business_year, mr_submission_template_id). 2Issuer identity + the free NAIC crosswalk. 320,336 rows across RY2017-2024 (Athena 51461b5b, 2026-10-13).

Columns (29)

Column	Type	Meaning
`business_year`	int
`mr_submission_template_id`	string
`hios_issuer_id`	string
`naic_group_code`	string
`naic_company_code`	string
`federal_ein`	string
`company_name`	string
`group_affiliation`	string
`dba_marketing_name`	string
`source_sha`	string
`domiciliary_state`	string
`business_state`	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_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string
`native_issuer_code`	string
`identity_row_locator`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`business_year,mr_submission_template_id`
Join	`how_to_join(source_fqn="insurer_silver.dim_insurer_mlr_identity")`
Raw door	Athena (read-only via query_substrate): insurer_silver.dim_insurer_mlr_identity
Note	Registered 2026-10-13 under register w4 cms_insurer_mlr_puf with a World (W4) by the Data Tracker registration lane (PR claude/tracker-registration-2026-10-13); until then internal only.

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