Insurer negotiated rates

Canonical-graph rate lookup index

vlada_curated.idx_rate_lookup·partial·index

Rows

N/A

Columns

N/A

History

N/A

Card

nocolumns only

Typed tools

What it is

1Inverted index in the canonical-graph resolution engine.
2The resolution engine traverses it instead of materializing payer-wide rate x NPI edges. idx_tin_provider_group (2026-07-05 TIN identity engine Phase 1) adds the EIN entry point, one row per (source_file, pg_id, tin_value) with tin_scope_class fanout metadata and tin_index_path provenance ('membership' | 'bridge' -- bridge rows are npi-link-capped whole-system groups, system-shared evidence with lower-bound fanout).

Grain

Key	Grain
N/A	1Inverted index keyed by rate identity; traversed via idx_npi_provider_group (NPI entry) or idx_tin_provider_group (EIN entry, tin_type='ein' slice only) -> idx_pg_set_provider_group.

Columns (0)

Columns are not in the catalog for this source; describe_data_source("vlada_curated.idx_rate_lookup") reads them live.

Query it

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

Item	Value
Typed tools that read it	get_negotiated_rate, lookup_rates_for_npi, lookup_rates_for_tin
Identity key	`rate_id`
Join	`how_to_join(source_fqn="vlada_curated.idx_rate_lookup")`
Raw door	Internal — reached via services/api/resolution_engine.py, not direct SQL.
Note	No array<npi>; no LATERAL VIEW explode (flat-schema canonical-primitives lock).

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