Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
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).
CentralControllerTimeZone
NOT NULL
DBINT
Virtual Time event was processed at the
Central Controller.
CentralControllerVirtualTime
NOT NULL
DBINT
The customer ID.
CustomerId
NULL
DBINT
Optional event DWORD.
Dword1
NULL
DBINT
Optional event DWORD.
Dword2
NULL
DBINT
Optional event binary data.
Dword3
NULL
DBINT
Optional event binary data.
Dword4
NULL
DBINT
Optional event binary data.
Dword5
NOT NULL
DBINT
Message ID from message compiler.
MessageId
NULL
DESCRIPTION
Contents of message.
MessageString
NOT NULL
VNAME32
Name of the process that originated the event.
ProcName
NOT NULL
DBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise
software to track the record.
RecoveryKey
NULL
varchar(16)
The level of the message.
Severity
NOT NULL
DBCHAR
Side of event originator:
Side
A
 or B = paired processes
\0
 = a non-paired process
NOT NULL
DBDATETIME
File time event was generated (originator’s
time).
SourceFileTime
NULL
VNAME32
Name of the node that generated the event.
SourceSystemName
NOT NULL
DBINT
Virtual time event was generated (originator’s
time).
SourceVirtualTime
NOT NULL
DBINT
Status code value.
StatusCode
NULL
DESCRIPTION
String associated with the status code.
StatusCodeString
NOT NULL
DBSMALLINT
Classification of the value in StatusCode field.
StatusCodeType
NULL
varchar(240)
Optional event string.
String1
NULL
varchar(240)
Optional event string.
String2
NULL
varchar(240)
Optional event string.
String3
NULL
varchar(240)
Optional event string.
String4
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
59
Chapter 2:  All Tables
Application_Event Table