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.