SQL — Rate Selection

SQL Files

File	Description
main/combined_main_brit.sql	Rate selection core: scans all scored columns in the BRIT wide table per ROID and picks the highest-scoring non-NULL rate as canonical_rate; chunked by payer
main/combined_main_brit_union.sql	UNIONs rate selection chunks
main/combined_main.sql	Enriches the rate-selected output with rate type categories and additional columns; produces the per-payer chunk
main/combined_main_union.sql	UNIONs combined_main chunks
main/combined_main_add_whispers.sql	Joins whisper columns onto the combined output

Input Tables (params.py)

Variable	Table	Used in
RATE_OUTLIER_TABLE	tq_intermediate.cld_utils.outlier_bounds_negotiated_rate_2025_11_07	combined_main_brit.sql
RATE_TYPE_CATEGORIES	tq_intermediate.cld_utils.rate_type_categories	combined_main.sql