Production Event Status Transitions

The Event_Status_Transitions table provides an easy way to query the timestamps of each status change for a production event. Whenever the production event status changes, a record will be created in the Event_Status_Transitions table that records the start and end of the status. This simplifies queries for status changes that would have previously been made against the Event_History table.

For the Start_Time and End_Time fields in the Event_Status_Transitions record, the value is retrieved from the Entry_On field in the Events table and not the Time Stamp field. This allows for capture of manual status changes by the operators where the Time Stamp of the event record does not change.

However, for certain applications such as automatically tracking the status of a batch by changing the status, it can cause some unexpected behavior because the Events.Entry_On is automatically set when the change is committed to the database, not when the change was effected. As such, there would typically be a slight lag between the Start_Time in the Event_Status_Transitions record and the Time Stamp in the Events record.