Result Set 8 - User-Defined Event
The following table lists the parameters used in a User-Defined Event Result Set.
|
Order |
Field Name |
Req |
Values/Table Reference |
|
0 |
Result Set Type |
X |
8 |
|
1 |
Update Type |
X |
0 - Post-Update. Data already in db and sent to clients only. 1 - Pre-Update. Database Manager writes to db and sends to client. |
|
2 |
User Defined Event Id |
X |
User_Defined_Events (UDE_Id) |
|
3 |
UD Event Number |
X |
User_Defined_Events (UDE_Desc) |
|
4 |
Unit Id |
X |
User_Defined_Events (PU_Id), Prod_Units (PU_Id) |
|
5 |
Event Subtype Id |
X |
User_Defined_Events (Event_Subtype_Id) |
|
6 |
Start Time |
X |
User_Defined_Events (Start_Time) |
|
7 |
End Time |
|
User_Defined_Events (End_Time) |
|
8 |
Duration |
|
User_Defined_Events (Duration) |
|
9 |
Acknowledged |
|
User_Defined_Events (Ack) |
|
10 |
Ack Timestamp |
|
User_Defined_Events (Ack_On) |
|
11 |
Acknowledged By |
|
User_Defined_Events (Ack_By) |
|
12 |
Cause 1 |
|
User_Defined_Events (Cause1), Event_Reasons (Reason_Id) |
|
13 |
Cause 2 |
|
User_Defined_Events (Cause2), Event_Reasons (Reason_Id) |
|
14 |
Cause 3 |
|
User_Defined_Events (Cause3), Event_Reasons (Reason_Id) |
|
15 |
Cause 4 |
|
User_Defined_Events (Cause4), Event_Reasons (Reason_Id) |
|
16 |
Cause Comment Id |
|
User_Defined_Events (Cause_Comment_Id), Comments (Comment_Id) |
|
17 |
Action 1 |
|
User_Defined_Events (Action1), Event_Reasons (Reason_Id) |
|
18 |
Action 2 |
|
User_Defined_Events (Action1), Event_Reasons (Reason_Id |
|
19 |
Action 3 |
|
User_Defined_Events (Action1), Event_Reasons (Reason_Id) |
|
20 |
Action 4 |
|
User_Defined_Events (Action1), Event_Reasons (Reason_Id) |
|
21 |
Action Comment Id |
|
User_Defined_Events (Action_Comment_Id), Comments (Comment_Id) |
|
22 |
Research User Id |
|
User_Defined_Events (Research_User_Id), Users (User_Id) |
|
23 |
Research Status Id |
|
User_Defined_Events (Research_Status_Id) |
|
24 |
Research Open Date |
|
User_Defined_Events (Research_Open_Date) |
|
25 |
Research Close Date |
|
User_Defined_Events (Research_Close_Date) |
|
26 |
Research Comment Id |
|
User_Defined_Events (Research_Comment_Id), Comments (Comment_Id) |
|
27 |
UD Event Comment Id |
|
User_Defined_Events (Comment_Id) |
|
28 |
Transaction Type |
|
1 = Add 2 = Update 3 = Delete |
|
29 |
Event Sub Type Desc |
|
Event_Subtypes (Event_Subtype_Desc) |
|
30 |
Transaction Number |
|
0 – Update fields that are not null to the new values. 2 – Update all fields of User_Defined_Events to the values in Result Set. |
|
31 |
User Id |
|
User_Defined_Events (User_Id) Users (User_Id) |
|
32 |
ESignature |
|
Signature ID from the ESignature table |