Downtime

The main data tables for downtime are:

Table_Name Description
Timed_Event_Details Downtime records

The main configuration tables for downtime are:

Table Name Description
Prod_Units Production units
Timed_Event_Faults Downtime faults
Event_Reasons Reasons
Event_Reason_Tree_Data Reason tree
Event_Reason_Category_Data Reason tree category assignments
Event_Reason_Categories Categories

Records in the Timed_Event_Details table are unique by PU_Id and Start_Time. They must also always be in sequence and cannot overlap (for example, the Start_Time of a record cannot be less than the End_Time of the previous record). In the Timed_Event_Details table the End_Time will be NULL for an open downtime record. Duration should always be calculated as the difference between the Start_Time and End_Time fields as the Duration field is not consistently updated.