Finish incomplete work on state management logic, testing, and test fixtures

Description

This issue represents the follow-up work related to state management logic, testing, and test fixtures.

See the following MRs for a partial, incomplete implementation of this work:

• Add status fixtures for different state transit... (!117520 - merged)
• Add test coverage of rails_info reconciliation ... (!117136 - merged)