Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Identifies the skill group the event is associated with.
SkillGroupSkillTargetID
PK, FK NOT NULLDBINT
Identifies the agent.
SkillTargetID
PK NOT NULLDBINT
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 Device (page 441) category. To see database rules for these tables, click here
(page 504).
The table decribes the basic rules for routing calls to agents
Table 22: Related tables for Agent_Targeting_Rule
Agent_Targeting Rule_Range (page 54)(via
AgentTargetingRuleID)
Agent_Targeting Rule_Member (page 54) (via
AgentTargetingRuleID)
Peripheral (page 250) (via EnterpriseName)
Table 23: Indexes for Agent_Targeting_Rule Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Agent_Targeting_Rule
AgentTargetingRuleIDclustered, 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 NULLDBINT
The ID for a specific Agent Targeting Rule.
AgentTargetingRuleID
NOT NULLDBINT
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 NULLDBINT
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