BI presentation mart for matched-payer contracting exploration. Grain: one row per canonical_payer_id, hospital_id, and exact comparison context (service_code_key, setting, billing_class, modifier_signature, comparison_methodology, drug unit context — equivalently service_context_key); negotiated dollar rates only. The negotiated amount is the payer-hospital representative: the median of the payer's deduplicated, unambiguous contract amounts for the exact context. Payer market medians are hospital-weighted and methodology-specific. Cash comparisons carry cash_comparison_status — a per-diem (daily) rate is never labeled above or below a cash amount. Unmatched payer names are excluded by design; they remain countable through the blocker summary.
Where this negotiated rate sits vs. the same payer's market median for this exact context: well_below/below/near/above/well_above payer market (thresholds +/-10% and +/-25%), insufficient_denominator when the payer has fewer than 3 hospitals for the context, or ambiguous_negotiated_context when the payer's contracts could not be represented safely.