Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-28
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent_Team_Supervisor Table
Agent_Team_Supervisor Table
Specifies the mapping of supervisors and agent teams.
Use ICM Configuration Manager to add or delete Agent_Team_Supervisor records.
Announcement Table
Each row corresponds to a voice announcement. The ICM software can route a call to an announcement.
Use ICM Configuration Manager to add, update, and delete Announcement records.
Related tables:
Network Target (via NetworkTargetID)
Table 2-14 Agent_Team_Supervisor
Field Name
Description
Data Type
Keys and Null
Option
Option
AgentTeamID
Identifies the agent team.
int
PK, NOT NULL
SupervisorSkillTargetID
Identifies the SkillTargetID of the supervisor.
int
PK, NOT NULL
Table 2-15 Announcement Table
Field Name
Description
Data Type
Keysand Null
Option
Option
NetworkTargetID
Foreign key from the Network Target table.
int
PK, FK, NOT
NULL
NULL
AnnouncementType
An integer value indicating the type of the
announcement.
announcement.
smallint
NOT NULL
EnterpriseName
An enterprise name for this announcement. This
name must be unique among all announcements in
the enterprise.
name must be unique among all announcements in
the enterprise.
varchar(32)
AK1, NOT
NULL
NULL
Description
Additional information about the announcement.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
int
NOT NULL