Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas

Página de 718
Keys and
NULL
Option
Data Type
Description
Name
AK-1 NOT
NULL
VNAME32
An enterprise name for the agent team that is unique
among all agent teams in the enterprise.
EnterpriseName
FK NOT
NULL
DBSMALLINT
Identifies the peripheral with which the team is
associated.
PeripheralID
NULL
DBINT
The agent who is the primary supervisor for the
team.
PriSupervisorSkillTargetID
Agent_Team_Member
This table is one of the Agent Detail tables in the
category. To see database rules for these tables,
see
This table specifies the mapping of agents to agent teams.
Use Unified ICM Configuration Manager to add or delete Agent_Team_Member records.
Related tables
(via SkillTargetID)
(via AgentTeamID)
Table 37: Indexes for Agent_Team_Member Table
index_keys
index_description
index_name
SkillTargetID
nonclustered, unique, unique key
located on PRIMARY
XAK1Agent_Team_Member
AgentTeamID
nonclustered located on PRIMARY
XIE1Agent_Team_Member
AgentTeamID, SkillTargetID
clustered, unique, primary key located
on PRIMARY
XPKAgent_Team_Member
Table 38: Fields in Agent_Team_Member Table
Keys and
NULL
Option
Data Type
Description
Name
PK, FK,
IE-1 NOT
NULL
DBINT
Identifies the agent team.
AgentTeamID
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0    
87
All tables
Agent_Team_Member