Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Keys and Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Identifies the skill group the event is associated with.
SkillGroupSkillTargetID
PK, FK NOT NULL
DBINT
Identifies the agent.
SkillTargetID
PK NOT NULL
DBINT
The time zone for the date and time. The value is the offset in
minutes from GMT.
TimeZone
Agent_Targeting_Rule Table
This table is in the 
 category. To see database rules for these tables, click 
The table decribes the basic rules for routing calls to agents
Table 22: Related tables for Agent_Targeting_Rule
AgentTargetingRuleID)
 (via
AgentTargetingRuleID)
Table 23: Indexes for Agent_Targeting_Rule Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Agent_Targeting_Rule
AgentTargetingRuleID
clustered, unique, primary key
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.
PeripheralID
This is applicable only for an IPCC PG or a Generic PG used as a
Syetem IPCC PG or a CallManager PG.
NOT NULL
DBINT
Defines the Agent Targeting Rule type to be used.
RuleType
Agent Targeting Rule Types
• Type 1 - Agent ID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
52
Chapter 2:  All Tables
Agent_Targeting_Rule Table