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

`insurer_silver.dim_insurer_mlr_identity` · Insurer negotiated rates · status live · 20,336 rows

The 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. Resolves an MLR financial filing to a payer BRAND + NAIC — the join key connecting insurer financials to negotiated rates (dim_payer).

**Grain.** One row per (business_year, mr_submission_template_id). Issuer identity + the free NAIC crosswalk. 20,336 rows across RY2017-2024 (Athena 51461b5b, 2026-10-13).

| 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: `query_substrate` with `SELECT ... FROM insurer_silver.dim_insurer_mlr_identity WHERE ... LIMIT 100`; read `describe_data_source("insurer_silver.dim_insurer_mlr_identity")` first.