Cisco Cisco IPCC Web Option Technical References
Agent_Team_Supervisor Table
. To see database rules for these tables, click
This table specifies the mapping of supervisors and agent teams.
Use ICM Configuration Manager to add or delete Agent_Team_Supervisor records.
Table 32: Indexes for Agent_Team_Supervisor Table
index_keys
index_description
index_name
AgentTeamID, SupervisorSkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent_Team_Supervisor
Fields in Agent_Team_Supervisor Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
Identifies the agent team.
AgentTeamID
PK NOT NULL
DBINT
Identifies the SkillTargetID of the supervisor.
SupervisorSkillTargetID
Announcement Table
This table is in the
Each row corresponds to a voice announcement. The ICM software can route a call to an
announcement.
announcement.
Use Configuration Manager to add, update, and delete Announcement records.
Table 33: Related Table for Announcement
(via NetworkTargetID)
Table 34: Indexes for Announcement Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Announcement
NetworkTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAnnouncement
Related Table
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
57
Chapter 2: All Tables
Agent_Team_Supervisor Table