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

See Also