Result Set 9 - Waste Event
The following table lists the parameters used in a Waste Event Result Set.
|
Order |
Field Name |
Req |
Values/Table Reference |
|
0 |
Result Set Type |
X |
9 |
|
1 |
PreDB |
X |
The update type. 0 - Post-Update. Data already in database and sent to clients only. 1 - Pre-Update. Database Manager writes to database and sends to client. |
|
2 |
TransNum |
X |
The transaction number. 0 - Update fields that are not null to the new values. 2 - Update all fields of Event_Details to the values in Result Set. |
|
3 |
UserId |
X |
The user ID. Waste_Event_Details (User_Id) Users (User_Id) |
|
4 |
TransType |
X |
The transaction type. 1 = Add 2 = Update 3 = Delete |
|
5 |
WasteEventId |
X |
Waste_Event_Details (WED_Id) |
|
6 |
PUId |
X |
Waste_Event_Details (PU_Id) Prod_Units (PU_Id) |
|
7 |
SourcePUId |
X |
The location. Waste_Event_Details (Source_PU_Id) Prod_Units (PU_Id) |
|
8 |
TypeId |
|
Waste_Event_Details (WET_Id) Waste_Event_Types (WET_Id) |
|
9 |
MeasId |
|
Waste_Event_Details (WEMT_Id) Waste_Event_Meas (WEMT_Id) |
|
10 |
Reason1 |
|
Waste_Event_Details (Reason1) Event_Reasons (Reason_Id) |
|
11 |
Reason2 |
|
Waste_Event_Details (Reason2) Event_Reasons (Reason_Id) |
|
12 |
Reason3 |
|
Waste_Event_Details (Reason3) Event_Reasons (Reason_Id) |
|
13 |
Reason4 |
X |
Waste_Event_Details (Reason4) Event_Reasons (Reason_Id) |
|
14 |
EventId |
X |
Waste_Event_Details (Event_Id) Events (Event_Id) |
|
15 |
Amount |
|
Waste_Event_Details (Amount) |
|
16 |
Marker1 |
|
Waste_Event_Details (Marker1) |
|
17 |
Marker2 |
|
Waste_Event_Details (Marker2) |
|
18 |
Timestamp |
|
Waste_Event_Details (TimeStamp) |
|
19 |
Action1 |
|
Waste_Event_Details (Action1) Event_Reasons (Reason_Id) |
|
20 |
Action2 |
|
Waste_Event_Details (Action1) Event_Reasons (Reason_Id) |
|
21 |
Action3 |
|
Waste_Event_Details (Action1) Event_Reasons (Reason_Id) |
|
22 |
Action4 |
|
Waste_Event_Details (Action1) Event_Reasons (Reason_Id) |
|
23 |
ActionCommentId |
|
Waste_Event_Details (Action_Comment_Id) Comments (Comment_Id) |
|
24 |
ResearchCommentId |
|
Waste_Event_Details (Research_Comment_Id) Comments (Comment_Id) |
|
25 |
ResearchStatusId |
|
Waste_Event_Details (Research_Status_Id) |
|
26 |
ResearchOpenDate |
|
Waste_Event_Details (Research_Open_Date) |
|
27 |
ResearchCloseDate |
|
Waste_Event_Details (Research_Close_Date) |
|
28 |
CommentId |
|
Waste_n_Timed_Comments (WTC_Id) |
|
29 |
TargetProdRate |
|
Waste_Event_Details (Target_Prod_Rate) |
|
30 |
ResearchUserId |
|
Waste_Event_Details (Research_User_Id) Users (User_Id) |
|
31 |
FaultId |
|
Waste_Event_Details (Fault_Id), Waste_Event_Fault (Fault_Id) |
|
32 |
RsnTreeDataId |
|
Waste_Event_Details (Event_Reason_Tree_Data_Id), Event_Reason_Tree_Data (Event_Reason_Tree_Data_Id) |
|
33 |
DimensionX |
|
|
|
34 |
DimensionY |
|
|
|
35 |
DimensionZ |
|
|
|
36 |
DimensionA |
|
|
|
37 |
StartCoordinateX |
|
|
|
38 |
StartCoordinateY |
|
|
|
39 |
StartCoordinateZ |
|
|
|
40 |
StartCoordinateA |
|
|
|
41 |
General1 |
|
|
|
42 |
General2 |
|
|
|
43 |
General3 |
|
|
|
44 |
General4 |
|
|
|
45 |
General5 |
|
|
|
46 |
OrderNum |
|
|
|
47 |
ESignature |
|
Signature ID from the ESignature table |
See Also