SD/Exclude No Longer Detected - Backend - Backfill detection_transitions

See the relevant discussion: #578566 (comment 2911271639)

TL;DR

We need to backfill detection_transitions

Acceptance Criteria

• Specific, testable criterion 1
• Specific, testable criterion 2

Implementation Details

Technical specifics e.g. files to change, functions, API endpoints, or data model updates.

Testing Approach

• Unit tests
• Integration tests
• Manual validation steps

Estimate