Production IShadowScoreAuditSink that writes MJ: Feature Values rows with
Role = 'Challenger'.
Why ValueKeyHash is null on Challenger rows
__mj.FeatureValue has a filtered unique index UQ_FeatureValue_ValueKey on
(RecordProcessID, ValueKeyHash) WHERE ValueKeyHash IS NOT NULL that deduplicates
production champion values by (EntityID, RecordID, FeatureName, Value*). If a challenger
computed the same prediction value as the champion and wrote a non-null ValueKeyHash,
saving the challenger row would collide with UQ_FeatureValue_ValueKey. Leaving
ValueKeyHash = null on Role = 'Challenger' rows guarantees challenger audit records
can never collide with or replace a champion row while keeping full lineage (RecordProcessID,
EntityID, RecordID, FeatureName, ProcessRunID, AIModelID, PromptID).
Production IShadowScoreAuditSink that writes
MJ: Feature Valuesrows withRole = 'Challenger'.Why
ValueKeyHashisnullon Challenger rows__mj.FeatureValuehas a filtered unique indexUQ_FeatureValue_ValueKeyon(RecordProcessID, ValueKeyHash) WHERE ValueKeyHash IS NOT NULLthat deduplicates production champion values by(EntityID, RecordID, FeatureName, Value*). If a challenger computed the same prediction value as the champion and wrote a non-nullValueKeyHash, saving the challenger row would collide withUQ_FeatureValue_ValueKey. LeavingValueKeyHash = nullonRole = 'Challenger'rows guarantees challenger audit records can never collide with or replace a champion row while keeping full lineage (RecordProcessID,EntityID,RecordID,FeatureName,ProcessRunID,AIModelID,PromptID).