Technical References

Fields in Agent_Team Table:
Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLDBINT
A unique identifier for the agent team.
AgentTeamID
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central
database.
ChangeStamp
NULLDESCRIPTION
Additional information about the agent team.
Description
NULLDBINT
The dialed number identifier for the agent team.
DialedNumberID
AK-1 NOT NULLVNAME32
An enterprise name for the agent team that is unique among
all agent teams in the enterprise.
EnterpriseName
FK NOT NULLDBSMALLINT
Identifies the peripheral the team is associated with.
PeripheralID
NULLDBINT
The agent who is the primary supervisor for the team.
PriSupervisorSkillTargetID
Agent_Team_Member Table
This table is one of the Agent Detail tables in the Skill Target category (page 456). To see
database rules for these tables, click here (page 510).
Specifies the mapping of agents to agent teams.
Use ICM Configuration Manager to add or delete Agent_Team_Member records.
Table 30: Related tables for Agent_Team_Member
Agent Team (page 55) (via AgentTeamID)Agent (page 15) (via SkillTargetID)
Table 31: Indexes for Agent_Team_Member Table
index_keysindex_descriptionindex_name
SkillTargetIDnonclustered, unique, unique key
located on PRIMARY
XAK1Agent_Team_Member
AgentTeamIDnonclustered located on PRIMARYXIE1Agent_Team_Member
AgentTeamID, SkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKAgent_Team_Member
Fields in Agent_Team_Member Table :
Keys and Null Option:Data Type:Description:Field Name:
PK, FK, IE-1 NOT NULLDBINT
Identifies the agent team.
AgentTeamID
FK, AK-1 NOT NULLDBINT
Identifies the agent.
SkillTargetID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
56
Chapter 2: All Tables
Agent_Team_Member Table