Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Table 23: Indexes for Agent_Targeting_Rule Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Agent_Targeting_Rule
AgentTargetingRuleID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent_Targeting_Rule
Fields in Agent_Targeting_Rule Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, NOT NULL
DBINT
The ID for a specific Agent Targeting Rule.
AgentTargetingRuleID
NOT NULL
DBINT
The peripheral whose agents the Agent Targeting
Rule applies to.
Rule applies to.
PeripheralID
This is applicable only for an IPCC PG or a
Generic PG used as a Syetem IPCC PG or a
CallManager PG.
Generic PG used as a Syetem IPCC PG or a
CallManager PG.
NOT NULL
DBINT
Defines the Agent Targeting Rule type to be
used.
used.
RuleType
NULL for Agent
Targeting Rule types 1
Targeting Rule types 1
DBINT
The TranslationRouteID must reference a
Translation_Route entry where the
Translation_Route entry where the
TranslationRouteID
and 2. Required (NOT
LogicalInterfaceControllerID is the same as the
PeripheralID.
PeripheralID.
NULL) for Agent
Targeting Rule type 3.
NOT NULL
Targeting Rule type 3.
NOT NULL
VARCHAR
Expression string for use if needed by an Agent
Targeting Rule.
Targeting Rule.
Expression
Applicable for type 2 Agent Targeting Rules
only.
only.
NOT NULL
VNAME32
A logical name you enter to assist you in
identifying the Agent Targeting Rule.
identifying the Agent Targeting Rule.
EnterpriseName
NOT NULL
DESCRIPTION
Use to note information about the Agent
Targeting Rule.
Targeting Rule.
Description
Agent_Targeting_Rule_Member Table
This table is in the
category. To see database rules for these tables, click
The table decribes the routing clients to which an Agent_Targeting_Rule applies.
Table 24: Related tables for Agent_Targeting_Rule_Member
(RoutingClientID)
AgentTargetingRuleID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
54
Chapter 2: - All Tables
Agent_Targeting_Rule_Member Table