WGN_V_RQ_EVENT_ALL

Database Schema and Views Reference Guide › Database Views › Review Queue Views Definitions › WGN_V_RQ_EVENT_ALL_1

WGN_V_RQ_EVENT_ALL_1

This returns all the columns from Wgn3Event for events that are in the review queue. This view only returns one row per event.

View Stack


WGN_V_RQ_EVENT_ALL_1
→	WGN_V_m_RQ_EVENT_ALL_1
	→	WGN_V_MD_RQ_EVENT_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 Details

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.