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 Data Protection 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 bitwise column indicating if the event has associated trigger and issue records.

 

INTEGER

4

Possible values:

0 = Trigger (Decimal 1)

1 = Issue (Decimal 2) - Deprecated

2 = Audit (Decimal 4) - Deprecated

3 = IssueParticipant (Decimal 8)

4 = Event based review (Decimal 16) - Event with no Wgn3EventParticipants

5 = Event based review (Decimal 32) - Event with no Wgn3IssueTriggers