McDewey

Related Tables Tables that hold Precision_Queue_Term data are listed below: • Attribute, on page 96 • Precision_Queue_Step, on page 359 Table 303: Fields in Precision_Queue_Term Keys and NULL Option Data Type Description Name PK, NOT NULL DBINT Integer that defines the unique row for a Precision Queue Term. It is the primary key. PrecisionQueueTermID FK, NOT NULL DBINT Foreign key to Precision_Queue table. PrecisionQueueID FK, NOT NULL DBINT Foreign key to Precision_Queue_Step table. PrecisionQueueStepID NOT NULL DBINT Integer that defines the order of rows for a Precision Queue Step. It is part of the primary key. TermOrder begins with 1. TermOrder FK, NOT NULL DBINT Foreign Key from Attribute_Set table. Controls which attribute set is tested. Null=Yes to allow for rules which do not test an Attribute Set. AttributeSetID FK, NOT NULL DBINT Foreign Key from Attribute table. Controls which attribute set is tested. Null=Yes to allow for rules which do not test an Attribute. AttributeID NOT NULL DBINT Number of parentheses around this term. A positive number indicates open parenthesis before the term; a negative number indicates closed parenthesis after the term. ParenCount NOT NULL DBINT Indicates the relationship of this term to the preceding term. Default is 0 for first item, 1 for others. Values are: • 0 = none (only legal on first item for queue, since there is no preceding term) • 1 = AND • 2 = OR • 3 = AND NOT • 4 = OR NOT TermRelation Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 361 All Tables Precision_Queue_Term