Technical References

Agent_Team_Supervisor Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
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_keysindex_descriptionindex_name
AgentTeamID, SupervisorSkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKAgent_Team_Supervisor
Fields in Agent_Team_Supervisor Table:
Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLDBINT
Identifies the agent team.
AgentTeamID
PK NOT NULLDBINT
Identifies the SkillTargetID of the supervisor.
SupervisorSkillTargetID
Announcement Table
This table is in the Route category (page 447). To see database rules for these tables, click here
(page 507).
Each row corresponds to a voice announcement. The ICM software can route a call to an
announcement.
Use Configuration Manager to add, update, and delete Announcement records.
Table 33: Related Table for Announcement
Network Target (page 238) (via NetworkTargetID)
Table 34: Indexes for Announcement Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Announcement
NetworkTargetIDclustered, unique, primary key
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