Cisco Cisco IP Contact Center Release 4.6.1 Technical References

2-47

Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)

Chapter 2 Table Details

Application_Event Table

Central database only.

Contains information about events in the ICM application. This is a subset of the events reported in the
Event table.

Table 2-33 Application_Event Table Constraints

Constraint

Field Name(s)

AK-1

RecoveryKey

IE-1

CentralControllerFileTime

Table 2-34 Application_Event Table

Field Name

Description

Data Type

Keys and
Null Option

BinData

Optional event binary data.

image

NULL

Category

The type of message.

VNAME32

NULL

CentralControllerFileTime

File Time event was processed at the Central
Controller.

DBDATETIME

IE-1

NOT NULL

CentralControllerTimeZone

Time zone at the Central Controller. The value is
the offset in minutes from GMT.

DBINT

NOT NULL

CentralControllerVirtualTime

Virtual Time event was processed at the Central
Controller.

DBINT

NOT NULL

CustomerId

The customer ID.

DBINT

NOT NULL

Dword1

Optional event DWORD.

DBINT

NULL

Dword2

Optional event DWORD.

DBINT

NULL

Dword3

Optional event DWORD.

DBINT

NULL

Dword4

Optional event DWORD.

DBINT

NULL

Dword5

Optional event DWORD.

DBINT

NULL

MessageId

Message ID from message compiler.

DBINT

NOT NULL

MessageString

Contents of message.

DESCRIPTION

NULL

ProcName

Name of the process that originated the event.

VNAME32

NOT NULL

RecoveryDay

Currently not used, set to zero (0).

DBINT

NOT NULL

RecoveryKey

A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.

DBFLT8

AK-1

NOT NULL

Severity

The level of the message.

varchar(16)

NULL

Side

Side of event originator:

A or B = paired processes
\0 = a non-paired process

DBCHAR

NOT NULL

SourceFileTime

File time event was generated (originator’s time).

DBDATETIME

NOT NULL