Technical References

Fields in Agent_Targeting_Rule_Range Table:
Keys and Null
Option:
Data Type:Description:Field Name:
PK, NOT NULLDBINT
The ID for an extension range associated with a specific Agent
Targeting Rule.
AgentTargetingRuleRangeID
NOT NULLDBINT
The ID for a specific Agent Targeting Rule.
AgentTargetingRuleID
NULLVARCHAR
Defines the low extension the Agent Targeting Rule applies to.
LowExtension
Note: While the Low and the High Extensions must be the same
length, not all extensions ranges for an Agent Targeting Rule need
to be the same length.
NULLVARCHAR
Defines the high extension the Agent Targeting Rule applies to.
HighExtension
Note: While the Low and the High Extensions must be the same
length, not all extensions ranges for an Agent Targeting Rule need
to be the same length.
Agent_Team Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
An agent team is a group of agents who report to the same supervisor(s) and are associated with
a single peripheral. The software does not route to agent teams and agents within a team do not
necessarily share the same skills. Agent teams are used for administrative and monitoring
purposes only.
Use ICM Configuration Manager to add, update, and delete Agent_Team records.
Table 28: Related tables for Agent_Team
Agent Team Member (page 56) (via AgentTeamID)Agent (page 15) (via PriSupervisorSkillTargetID and
SecSupervisorSkillTargetID)
Table 29: Indexes for Admin_Script_Schedule_Map Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Agent_Team
PriSupervisorSkillTargetIDnonclustered located on PRIMARYXIF112Agent_Team
AgentTeamIDclustered, unique, primary key
located on PRIMARY
XPKAgent_Team
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
55
Chapter 2: All Tables
Agent_Team Table