Previous Topic: Wgn3ReviewQueueNext Topic: TMP_Wgn3RLS

Database Schema and Views Reference Guide › Database Tables › Wgn3ReviewMetrics

Wgn3ReviewMetrics

This table contains the definition of Review Queue metrics, each row defines the metric for the specified group, the review queue process interprets the metric defined for a group as applying to all subgroups of that group, unless specifically overridden at a lower level in the hierarchy.

Column

Primary Key

Datatype

Length

Notes

Process

The Review Queue process that this metric is associated with.

 

INTEGER

4

 

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

 

Category

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

Yes

INTEGER

4

Possible values:

0 = Main selection

1 = Under subscription

2 = Not used

3 = Mandatory selection

Value

The value of the metric.

Yes

INTEGER

 

Interpreted using the Type column.

Type

Flag to determine if the Value column should be interpreted as a percentage or absolute value.

Yes

INTEGER

4

Possible values:

0 = Absolute

1 = Percentage

MTarget

Flag to indicate which data set is used to calculate the runtime metric value.

Yes

VARCHAR

 

Possible values:

A = All

P = Prime

DTarget

Flag to indicate which data set is used to calculate the runtime metric value.

Yes

VARCHAR

 

Possible values:

A = All

P = Prime