Previous Topic: TimePeriodOffsetNext Topic: WgnStatEventList (Deprecated)


WgnStatEvent (Deprecated)

This table is deprecated and will be removed in a future release.

This table defines all event list values for all event lists.

Column

Primary Key

Datatype

Length

Notes

EventListID

Identifies the event list that the event belongs to.

Yes

INTEGER

4

Foreign key: WgnStatEventList

PhysicalIndex

The physical event list slot entry storing the event.

Yes

INTEGER

 

 

VirtualIndex

The virtual index of the event list entry.

 

INTEGER

 

 

EventTimestamp

The time that the underlying captured data event was generated.

 

TIMESTAMP

8

Foreign key: Wgn3Event

Events may appear out of order against the relevant index value. This is because events from different client machines are processed by the CMS at different times.

StringValue

A statistic specific description of the event.

 

VARCHAR

255

 

SequenceIDM

Part-key identifying the associated capture event.

 

INTEGER

 

Foreign key: Wgn3Event

SequenceID

Part-key identifying the associated capture event.

 

INTEGER

 

Foreign key: Wgn3Event

EventIndex

Part-key identifying the associated capture event.

 

INTEGER

 

Foreign key: Wgn3Event

StatisticID

The statistic to which the value belongs.

Yes

INTEGER

4

Foreign key: WgnStatDefinition

OwnerType

The type of statistic owner.

Yes

INTEGER

4

Follow the hyperlink for details.

OwnerIDM

Part-key identifying the statistic owner.

Yes

INTEGER

4

 

OwnerID

Part-key identifying the statistic owner.

Yes

INTEGER

4

 

PhysicalTimePeriodIndex

The physical slot index that the value is occupying.

Yes

INTEGER

4

 

VirtualTimePeriodIndex

The virtual slot index that the value is occupying.

 

INTEGER

4

 

NumericValue

The statistic value.

 

DECIMAL

13