# Payer dimension + carrier hierarchy

`vlada_curated.dim_payer` · Insurer negotiated rates · status live

Canonical payer slugs, human names, and carrier ownership hierarchy (e.g. Cigna Healthspring under Cigna). Resolves free-text payer names.

**Grain.** One row per canonical payer_id.

| column | type | meaning |
|---|---|---|
| payer_id | string |  |
| payer_name | string |  |
| payer_name_normalized | string |  |
| parent_company | string |  |
| covered_lives_millions | double |  |
| market_share_pct | string |  |
| toc_url | string |  |
| toc_format | string |  |
| mrf_format | string |  |
| extraction_status | string |  |
| extraction_started_at | string |  |
| extraction_completed_at | string |  |
| last_extraction_version | string |  |
| total_files | string |  |
| files_extracted | bigint |  |
| total_rates | bigint |  |
| total_providers | bigint |  |
| unique_codes | string |  |
| s3_base_path | string |  |
| status | string |  |
| created_at | timestamp |  |
| updated_at | timestamp |  |
| metadata | string |  |
| display_name | string |  |
| active_flag | boolean |  |
| priority_rank | bigint |  |
| national_flag | boolean |  |
| states_covered_count | string |  |
| regions_covered | string |  |
| toc_last_checked_at | timestamp |  |
| toc_file_count_current | double |  |
| toc_file_count_deduped | double |  |
| toc_total_bytes_current | double |  |
| toc_total_bytes_deduped | double |  |
| latest_version_id | string |  |
| linkage_status | string |  |
| normalization_status | string |  |
| aggregation_status | string |  |
| quality_status | string |  |
| serving_status | string |  |
| status_summary | string |  |
| raw_provider_count_current | bigint |  |
| raw_linkage_count_current | string |  |
| raw_bytes_current | string |  |
| normalized_bytes_current | string |  |
| aggregate_bytes_current | string |  |
| entity_assignment_pct | string |  |
| valid_code_pct | string |  |
| notes | string |  |
| payer_family | string |  |
| toc_snapshot_id_current | double |  |
| current_version_id | string |  |
| entity_compaction_status | string |  |
| raw_rates_count_current | bigint |  |
| quality_score_current | string |  |
| parent_payer_id | string |  |
| toc_s3_path | string |  |
| toc_verified_at | timestamp |  |
| toc_status | string |  |
| extraction_priority | bigint |  |
| last_toc_sync | timestamp |  |
| current_version | string |  |
| toc_file_count | bigint |  |
| toc_total_bytes | bigint |  |
| rates_extracted | bigint |  |
| npis_extracted | bigint |  |
| last_extraction_at | string |  |
| _synced_at | timestamp |  |

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