WGN_V_EVENT

Database Schema and Views Reference Guide › Database Views › Primary Views Definitions › WGN_V_EVENT_2

WGN_V_EVENT_2

This view and, with exceptions, WGN_V_EVENT_1, must always be used when a search wants to retrieve information from Wgn3Event. If a search attempts to retrieve rows directly from Wgn3Event, the search will fail because the search user does not have permission to select data from this table directly.

WGN_V_EVENT_1 removes duplicate rows from the view so that it only returns 1 row per event. WGN_V_EVENT_2 returns duplicate rows from the view so that it returns 1 row per participant. One row per event can then be achieved using some further SQL (such as DISTINCT). Here we have just moved the emphasis of where this de-duplication happens.

WGN_V_EVENT_2 is now the default view to use; it has essentially superseded WGN_V_EVENT_1. We strongly recommend that you use WGN_V_EVENT_2. This is primarily for performance reasons. While there is no current plan to deprecate WGN_V_EVENT_1, this may happen in the future. This is another reason for using WGN_V_EVENT_2. There may be some specific cases where WGN_V_EVENT_1 performs better, but this should only be tested if it is believed that WGN_V_EVENT_2 is causing a performance issue (for example, when retrieving events given the UID may perform better using WGN_V_EVENT_1).

The final column in either view, epeventtimestamp, was added because of performance issues, primarily on SQL Server 2000. This does not appear to be an issue in Oracle. The field reflects the same value as EventTimeStamp on Wgn3Event but on the table Wgn3EventParticipant. The problem is that SQL Server 2000 does not reliably perform predicate closure. It is highly likely that most searches will include a date range. These dates will be passed to the search as literal values. In these cases, it is important that these literal values are put against both EventTimeStamp and epEventTimeStamp, otherwise SQL Server does not recognize that the literal values apply to both columns from any join and this can produce a poor query plan.

Example

FROM WGN_V_EVENT_2 EV …
  WHERE EV.EventTimeStamp >= {start date} AND EV.EventTimeStamp <= {end date} …
  AND EV.epEventTimeStamp >= {start date} AND EV.epEventTimeStamp <= {end date} …

View Stack


Wgn_V_Event_2
→	wgn_v_m_event_2
	→	WGN_V_MD_EVENT_2
		→	wgn3event
			wgn3eventparticipant
			WGN_V_RLS_ADDR_1
			→	TMP_WGN3ADDRRLS

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.