Insurer negotiated rates

Payer dimension + carrier hierarchy

vlada_curated.dim_payer·live·dim·Payer Directory

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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

Grain

Key	Grain
N/A	1One row per canonical payer_id.

Columns (68)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`payer_id`
Join	`how_to_join(source_fqn="vlada_curated.dim_payer")`
Raw door	Athena: vlada_curated.dim_payer
Company names	`payer_name` `payer_name_normalized` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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