Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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.
AnnouncementType
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the 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.
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
. To see database rules for these tables, click
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
Fields in Application_Event Table :
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
image
Optional event binary data.
BinData
NULL
VNAME32
The type of message.
Category
NOT NULL
DBDATETIME
File Time event was processed at the Central Controller.
CentralControllerFileTime
NOT NULL
DBINT
Time zone at the Central Controller. The value is the offset
in minutes from UTC (formerly called GMT).
in minutes from UTC (formerly called GMT).
CentralControllerTimeZone
NOT NULL
DBINT
Virtual Time event was processed at the Central Controller.
CentralControllerVirtualTime
NOT NULL
DBINT
The customer ID.
CustomerId
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
58
Chapter 2: All Tables
Application_Event Table