Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Use Configuration Manager to add, update, and delete Announcement records.
Table 33: Related Table for Announcement
(via NetworkTargetID)
Table 34: Indexes for Announcement Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Announcement
NetworkTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAnnouncement
Related Table
Fields in Announcement Table :
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
An integer value indicating the type of the
announcement.
announcement.
AnnouncementType
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the announcement.
Description
AK-1 NOT NULL
VNAME32
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.
EnterpriseName
PK, FK NOT NULL
DBINT
Foreign key from the Network Target table.
NetworkTargetID
Application_Event Table
This table is in the
Central database only.
Contains information about events in the ICM application. This is a subset of the events reported
in the Event table.
in the Event table.
Table 35: Indexes for Application_Event Table
index_keys
index_description
index_name
CentralControllerFileTime
nonclustered located on PRIMARY
XIE1Application_Event
MessageId
nonclustered located on PRIMARY
XIE2Application_Event
RecoveryKey
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKApplication_Event
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
58
Chapter 2: - All Tables
Application_Event Table