Cisco Cisco IP Contact Center Release 4.6.2 Technical References
Fields in Agent_Team Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
A unique identifier for the agent team.
AgentTeamID
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central
database.
database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the agent team.
Description
NULL
DBINT
The dialed number identifier for the agent team.
DialedNumberID
AK-1 NOT NULL
VNAME32
An enterprise name for the agent team that is unique among
all agent teams in the enterprise.
all agent teams in the enterprise.
EnterpriseName
FK NOT NULL
DBSMALLINT
Identifies the peripheral the team is associated with.
PeripheralID
NULL
DBINT
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
. To see
database rules for these tables, click
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
(via AgentTeamID)
(via SkillTargetID)
Table 31: Indexes for Agent_Team_Member Table
index_keys
index_description
index_name
SkillTargetID
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Agent_Team_Member
AgentTeamID
nonclustered located on PRIMARY
XIE1Agent_Team_Member
AgentTeamID, SkillTargetID
clustered, unique, primary key
located on PRIMARY
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 NULL
DBINT
Identifies the agent team.
AgentTeamID
FK, AK-1 NOT NULL
DBINT
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