Previous Topic: Wgn3UserRoleNext Topic: Wgn3ReviewMetrics


Wgn3ReviewQueue

This table contains references to event participants that are populated by the review queue population process. This table is the queue of events queued by the review queue process that are required to be reviewed.

Column

Primary Key

Datatype

Length

Notes

GroupIDM

Part-key identifying the user's group associated with the review queue entry.

 

INTEGER

4

 

GroupID

Part-key identifying the user's group associated with the review queue entry.

 

INTEGER

4

 

EventUID

Part-key identifying the event participant for the review queue entry.

Yes

IDENTIFYREF

 

 

EventTimestamp

Part-key identifying the event participant for the review queue entry.

Yes

TIMESTAMP

 

 

ParticipantIndex

Part-key identifying the event participant for the review queue entry.

 

INTEGER

4

 

UserIDM

Part-key identifying the user associated with the review queue entry.

 

INTEGER

4

 

UserID

Part-key identifying the user associated with the review queue entry.

 

INTEGER

4

 

Category

The category of review queue metric associated with the review queue entry.

 

INTEGER

4

Possible values:

0 = Main selection

1 = Under subscription

2 = Not used

3 = Mandatory selection

Run

The run of the review queue process that created this review queue entry.

 

INTEGER

4

Used as a reference to Wgn3JobHistory table.

Precedence

 

INTEGER

4

Not used.