WGN_V_RQ_EVENTRY_ALL_1

→

WGN_V_m_RQ_EVENTRY_ALL_1

→

WGN_V_MD_RQ_EVENTRY_ALL_1

→

WGN3Event

WGN_V_MD_RQ_ENTRY_ALL_1

→

WGN_V_AD_RQ_ENTRY_ALL_1

→

Wgn3ReviewQueue

WGN_V_RLS_1

→

TMP_Wgn3RLS

Column

Data Type

Length

Description

EventUID

IDENTITYDEF

13

Key used to uniquely identify a captured or imported event.

EventTimestamp

TIMESTAMP

8

The time at which the event occurred.

SequenceIDM

INTEGER

4

Part-key used to identify the owning sequence and also uniquely identify the event.

SequenceID

INTEGER

4

Part-key used to identify the owning sequence and also uniquely identify the event.

EventIndex

INTEGER

4

Part-key used to uniquely identify the event.

EventMajorType

INTEGER

4

Identifies the 'major' event type (such as, email or web page)

EventMinorType

INTEGER

4

Identifies the 'minor' event type (such as, email sent)

EventSubType

INTEGER

4

Identifies the 'direction' of the event (such as, incoming or outgoing)

AesMajorType

INTEGER

4

Part-key that identifies the source object (software package) that captured the sequence.

AesMinorType

INTEGER

4

Part-key that identifies the source object (software package) that captured the sequence.

AesSubType

INTEGER

4

Part-key that identifies the source object (software package) that captured the sequence.

EventText1

LONGVARCHAR

255

Event specific string identifying the event.

EventText2

LONGVARCHAR

4000

Event specific string identifying the event.

EventAttributes

VARCHAR

255

Attributes of the event.

ExternalID

VARCHAR

255

This attribute contains an external (non-CA DataMinder) unique ID of an event to enable matching with duplicates of the same event captured elsewhere.

Duration

INTEGER

4

The length of time for which the event occurred.

ExpiryTimestamp

TIMESTAMP

8

Stores the time at which the event expires. Expired events are removed by the next scheduled database purge.

IsPermanent

BIT

1

If this column has a non-zero (true) value, then the event will never be deleted by a scheduled database purge.

UpdateTimestamp

TIMESTAMP

8

The time that the event was last modified.

PurgeState

INTEGER

4

Indicates whether the row can be purged if 'Purge On Replicate' is enabled. This column is ignored on a CMS.

GMTOffset

INTEGER

4

Specifies the difference (in minutes) between UTC time and the time zone in which an events source machine resides.

DSTOffset

INTEGER

4

Specifies the size of the daylight saving offset (in minutes) for the source machine's timezone.

BlobType

INTEGER

4

Identifies the type of the blob (such as a file based blob).

BlobLocation

VARCHAR

255

The location of the blob data. The format of this string depends on the BlobType.

BlobSize

DECIMAL

13

The size of the blob (in bytes) before encryption/compression.

BLOBPhysicalSize

DECIMAL

13

The size of the blob (in bytes) after encryption/compression.

epeventtimestamp

TIMESTAMP

8

Same as EventTimeStamp but this is taken from Wgn3EventParticipants instead of Wgn3Event. Used to ensure predicates commute.

GroupIDM

INTEGER

4

Part-key used to uniquely identify a group within the installation.

GroupID

INTEGER

4

Part-key used to uniquely identify a group within the installation.

ParticipantIndex

INTEGER

4

Part-key used to identify an event participant.

UserIDM

INTEGER

4

Part-key identifying the CA DataMinder user associated with the login.

UserID

INTEGER

4

Part-key identifying the CA DataMinder user associated with the login.

Category

INTEGER

4

Indicates which category of metric caused the entry to be written to the queue

Precedence

INTEGER

4

Not used, reserved for possible future use.