Technical References

Fields in Announcement Table :
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
An integer value indicating the type of the announcement.
AnnouncementType
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the announcement.
Description
AK-1 NOT NULLVNAME32
An enterprise name for this announcement. This name must be
unique among all announcements in the enterprise.
EnterpriseName
PK, FK NOT NULLDBINT
Foreign key from the Network Target table.
NetworkTargetID
Application_Event Table
This table is in the System category (page 460). To see database rules for these tables, click here
(page 511).
Central database only.
Contains information about events in the ICM application. This is a subset of the events reported
in the Event table.
Table 35: Indexes for Application_Event Table
index_keysindex_descriptionindex_name
CentralControllerFileTimenonclustered located on PRIMARYXIE1Application_Event
MessageIdnonclustered located on PRIMARYXIE2Application_Event
RecoveryKeyclustered, unique, primary key
located on PRIMARY
XPKApplication_Event
Fields in Application_Event Table :
Keys and Null Option:Data Type:Description:Field Name:
NULLimage
Optional event binary data.
BinData
NULLVNAME32
The type of message.
Category
NOT NULLDBDATETIME
File Time event was processed at the Central Controller.
CentralControllerFileTime
NOT NULLDBINT
Time zone at the Central Controller. The value is the offset
in minutes from UTC (formerly called GMT).
CentralControllerTimeZone
NOT NULLDBINT
Virtual Time event was processed at the Central Controller.
CentralControllerVirtualTime
NOT NULLDBINT
The customer ID.
CustomerId
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
58
Chapter 2: All Tables
Application_Event Table