Previous Topic: Wgn3EventIssueNext Topic: Wgn3EventQueue

Database Schema and Views Reference Guide › Database Tables › Wgn3EventParticipant

Wgn3EventParticipant

This table defines the relationship between an event and any users associated with the event. The user association may be via the Wgn3Address table and/or the WgnUserLogin table. Note that a user association via the WgnUserLogin table is true only for 'client-captured' events.

From schema version 3.50, the columns addressuid1 and addressuid2 are mandatory. You can therefore assume that all wgn3eventparticipant rows have a corresponding wgn3address row, irrespective of the type of event. Events that would not naturally have an associated address such as, a web event will have an address generated based on the user information.

Column

Primary Key

Datatype

Length

Notes

EventUID

Key used to uniquely identify a captured or imported event.

Yes

IDENTITYDEF

13

Foreign key: Wgn3Event

ParticipantIndex

Part-key used to identify an event participant.

Yes

INTEGER

4

 

EventTimestamp

The time at which the event occurred.

Yes

TIMESTAMP

8

Foreign key: Wgn3Event

AddressUID1

Part-key used to uniquely identify an email address or the address of an IM participant.

 

DECIMAL

13

Foreign key: Wgn3Address

AddressUID2

Part-key used to uniquely identify an email address or the address of an IM participant.

 

DECIMAL

13

Foreign key: Wgn3Address

ParticipantNodeUID

The classification of the participant.

 

INTEGER

4

Foreign key: Wgn3ClassificationNode

InterventionNodeUID

The classification that CA DataMinder assigns to the participant.

 

INTEGER

4

Foreign key: Wgn3ClassificationNode

LoginIDM

Part-key that indicates the participant who generated the event.

 

INTEGER

4

Foreign key: WgnUserLogin

LoginID

Part-key that indicates the participant who generated the event.

 

INTEGER

4

Foreign key: WgnUserLogin

QueryFlags

Denormalized column indicating if the event has associated Trigger and/or Audit Records

 

INTEGER

4

Possible values:

0 = None

1 = Trigger

2 = Issue

3 = Issue+Trigger

4 = Audit

5 = Audit+Trigger

6 = Audit+Issue

7 = Audit+Issue+Trigger