# Canonical-graph rate lookup index

`vlada_curated.idx_rate_lookup` · Insurer negotiated rates · status partial

Inverted index in the canonical-graph resolution engine. The 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.** Inverted 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.

Tools that read it: get_negotiated_rate, lookup_rates_for_npi, lookup_rates_for_tin

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