Result Set 5 - Downtime Events
The following table lists the parameters used in a Downtime Event Result Set.
|
Order |
Field Name |
Req |
Values/Table Reference |
|
0 |
Result Set Type |
X |
5 |
|
1 |
Production Unit Id |
X |
Timed_Event_Details.PU_Id, Prod_Units.PU_Id |
|
2 |
Location |
X |
Timed_Event_Details.Source_PU_Id, Prod_Units.PU_Id |
|
3 |
Status Id |
X |
Timed_Event_Details.TEStatus_Id, Timed_Event_Status.TEStatus_Id |
|
4 |
Fault Id |
|
Timed_Event_Details.TEFault_Id, Timed_Event_Faults.TEFault_Id |
|
5 |
Reason 1 Id |
|
Timed_Event_Details.Reason_Level1, Event_Reasons.Reason_Id |
|
6 |
Reason 2 Id |
|
Timed_Event_Details.Reason_Level2, Event_Reasons.Reason_Id |
|
7 |
Reason 3 Id |
|
Timed_Event_Details.Reason_Level3, Event_Reasons.Reason_Id |
|
8 |
Reason 4 Id |
|
Timed_Event_Details.Reason_Level4, Event_Reasons.Reason_Id |
|
9 |
Production Rate |
|
Timed_Event_Details (Production_Rate) |
|
10 |
Duration |
|
Timed_Event_Details (Duration) This is a calculated (end_time – start_time) column in the database. It is not used by the SP. |
|
11 |
Transaction Type |
X |
1 = Add 2 = Update 3 = Delete 4 = Close |
|
12 |
Start Time |
X |
Timed_Event_Details.Start_Time |
|
13 |
End time |
|
Timed_Event_Details.End_Time |
|
14 |
Downtime Event Id |
|
Timed_Event_Details.TEDet_Id |
|
15 |
Update Type |
|
0 – Pre Update. Database Manager writes to db and sends to client. 1 – Post Update. Data already in db and sent to clients only. |
|
16 |
TransNum |
|
0 = Coalesce all input values with values from database before updating 2 = Update database using only input values to this stored procedure |
|
17 |
Action1 |
|
Timed_Event_Details.Action_Level1, Event_Reasons.Reason_Id |
|
18 |
Action2 |
|
Timed_Event_Details.Action_Level2, Event_Reasons.Reason_Id |
|
19 |
Action3 |
|
Timed_Event_Details.Action_Level3, Event_Reasons.Reason_Id |
|
20 |
Action4 |
|
Timed_Event_Details.Action_Level4, Event_Reasons.Reason_Id |
|
21 |
ActionCommentId |
|
Timed_Event_Details.Action_Comment_Id, Comments.Comment_Id |
|
22 |
ResearchStatusId |
|
Timed_Event_Details.Research_Status_Id |
|
23 |
ResearchCommentId |
|
Timed_Event_Details.Research_Comment_Id, Comments.Comment_Id |
|
24 |
ResearchOpenDate |
|
Timed_Event_Details.Research_Open_Date |
|
25 |
ResearchCloseDate |
|
Timed_Event_Details.Research_Close_Date |
|
26 |
CommentId |
|
Timed_Event_Details.Cause_Comment_Id, Comments.Comment_Id |
|
27 |
TargetProdRate |
|
Not Used |
|
28 |
DimensionX1 |
|
Not Used |
|
29 |
DimensionX2 |
|
Not Used |
|
30 |
DimensionY1 |
|
Not Used |
|
31 |
DimensionY2 |
|
Not Used |
|
32 |
DimensionZ1 |
|
Not Used |
|
33 |
DimensionZ2 |
|
Not Used |
|
34 |
ResearchUserId |
|
Timed_Event_Details.Research_User_Id |
|
35 |
RsnTreeDataId |
|
Identifies what Node on the Reason Tree this Downtime event corresponds to. Used in reporting. |
|
36 |
ESignature |
|
Signature ID from the ESignature table |