Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Administrative Workstation
  5. Technical References

Cisco Cisco Administrative Workstation Technical References

Download
Page of 404
 
2-27
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Agent_Team_Member Table
Related tables:
Agent (via PriSupervisorSkillTargetID and SecSupervisorSkillTargetID)
Agent Team Member (via AgentTeamID)
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:
Agent (via SkillTargetID)
Agent Team (via AgentTeamID)
PeripheralID
Identifies the peripheral the team is associated with. smallint
FK, NOT NULL
Description
Additional information about the agent team.
varchar(255)
NULL
DialedNumberID
The dialed number identifier for the agent team.
int
NULL
PriSupervisorSkillTargetID
The agent who is the primary supervisor for the 
team.
int
FK, IE1, NULL
ChangeStamp
Incremented when the record is changed in the 
central database.
int
NOT NULL
Table 2-12 Agent_Team Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-13 Agent_Team_Member Table
Field Name
Description
Data Type
Keys and Null 
Option
AgentTeamID
Identifies the agent team.
int
PK, FK, IE1, 
NOT NULL
SkillTargetID
Identifies the agent.
int
PK, FK, AK1, 
NOT NULL