Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 548
   
2-44
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Agent_Team_Member Table
Agent_Team_Member Table 
Specifies the mapping of agents to agent teams.
Use ICM Configuration Manager to add or delete Agent_Team_Member records.
Related tables:
 (via SkillTargetID)
 (via AgentTeamID)
Table 2-27 Agent_Team_Member Table Constraints
Constraint
Field Name(s)
PK
AgentTeamID
SkillTargetID
AK-1
SkillTargetID
FK
AgentTeamID
IE-1
AgentTeamID
Table 2-28 Agent_Team_Member Table
Field Name
Description
Data Type
Keys and 
Null Option
AgentTeamID
Identifies the agent team.
DBINT
PK, FK, 
IE-1
NOT NULL
SkillTargetID
Identifies the agent.
DBINT
FK, AK-1
NOT NULL