Result Set 13 - Defect Detail
The following table lists the parameters used in an Defect Details Result Set.
Order |
Field Name |
Req |
Values/Table Reference |
0 |
Result Set Type |
X |
13 |
1 |
PreDB |
X |
0 - Post-Update. Database Manager writes to db and sends to client. 1 - Pre-Update. Data already in database and sent to clients only. |
2 |
TransType |
X |
1 = Add 2 = Update 3 = Delete |
3 |
TransNum |
X |
0 – Update fields that are not null to the new values. 2 – Update all fields of Event_Details to the values in Result Set. Values of 0 for dimensions are set to null. |
4 |
DefectDetailId |
X |
Defect_Details (Defect_Detail_Id) |
5 |
DefectTypeId |
X |
Defect_Details (Defect_Type_Id) Defect_Types (Defect_Type_Id) |
6 |
Cause1 |
|
Defect_Details (Cause1), Event_Reasons (Reason_Id) |
7 |
Cause2 |
|
Defect_Details (Cause2), Event_Reasons (Reason_Id) |
8 |
Cause3 |
|
Defect_Details (Cause3), Event_Reasons (Reason_Id) |
9 |
Cause4 |
|
Defect_Details (Cause4), Event_Reasons (Reason_Id) |
10 |
CauseCommentId |
|
Defect_Details (Cause_Comment_Id), Comments (Comment_Id) |
11 |
Action1 |
|
Defect_Details (Action1), Event_Reasons (Reason_Id) |
12 |
Action2 |
|
Defect_Details (Action1), Event_Reasons (Reason_Id) |
13 |
Action3 |
|
Defect_Details (Action1), Event_Reasons (Reason_Id) |
14 |
Action4 |
|
Defect_Details (Action1), Event_Reasons (Reason_Id) |
15 |
ActionCommentId |
|
Defect_Details (Action_Comment_Id), Comments (Comment_Id) |
16 |
ResearchStatusId |
|
Defect_Details (Research_Status_Id) |
17 |
ResearchCommentId |
|
Defect_Details (Research_Comment_Id), Comments (Comment_Id) |
18 |
ResearchUserId |
|
Defect_Details (Research_User_Id), Users (User_Id) |
19 |
EventId |
|
Defect_Details (Event_Id), Events (Event_Id) |
20 |
SourcePUId |
|
Defect_Details (Source_PU_Id), Events (Event_Id) |
21 |
PUId |
|
Defect_Details (PU_Id), Prod_Units (PU_Id) |
22 |
EventSubtypeId |
|
Defect_Details (Event_Subtype_Id) Event_Subtypes (Event_Subtype_Id) |
23 |
UserId |
|
Defect_Details (User_Id), Users (User_Id) |
24 |
Severity |
|
Defect_Details (Severity) |
25 |
Repeat |
|
Defect_Details (Repeat) |
26 |
DimensionX |
|
Defect_Details (Dimension_X) |
27 |
DimensionY |
|
Defect_Details (Dimension_Y) |
28 |
DimensionZ |
|
Defect_Details (Dimension_Z) |
29 |
DimensionA |
|
Defect_Details (Dimension_A) |
30 |
Amount |
|
Defect_Details (Amount) |
31 |
StartCoordinateX |
|
Defect_Details (Start_Coordinate_X) |
32 |
StartCoordinateY |
|
Defect_Details (Start_Coordinate_Y) |
33 |
StartCoordinateZ |
|
Defect_Details (Start_Coordinate_Z) |
34 |
StartCoordinateA |
|
Defect_Details (Start_Coordiante_A) |
35 |
ResearchOpenDate |
|
Defect_Details (Research_Open_Date) |
36 |
ResearchCloseDate |
|
Defect_Details (Research_Close_Date) |
37 |
StartTime |
|
Defect_Details (Start_Time) |
38 |
EndTime |
|
Defect_Details (End_Time) |
39 |
EntryOn |
|
Defect_Details (Entry_On) |
40 |
ESignature |
|
Signature ID from the ESignature table |