Cisco Cisco IP Contact Center Release 4.6.1 Technical References

2-29

Cisco ICM Software Database Schema Handbook

78-11677-04

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-16 Application_Event Table

Field Name

Description

Data Type

Keys and Null
Option

CentralControllerVirtualTime

Virtual Time event was processed at the Central
Controller.

int

NOT NULL

CentralControllerFileTime

File Time event was processed at the Central
Controller.

datetime

IE1, NOT
NULL

CentralControllerTimZone

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

int

NOT NULL

VersionNum

EMS version number.

smallint

NOT NULL

SystemType

The type of system that generated the event:

0 = Unknown
1 = CallRouter
2 = Peripheral Gateway
3 = Network Interface Controller
4 = Admin Workstation
5 = Logger
6 = Listener
7 = CTI Gateway

smallint

NOT NULL

SystemId

DMP system ID of the event originator. For a
CallRouter or Logger, this value is always 0.

smallint

NOT NULL

StatusCodeType

Classification of the value in StatusCode field.

smallint

NOT NULL

StatusCode

Status code value.

int

NOT NULL

StatusCodeString

String associated with the status code.

varchar(255)

NULL

ProcName

Name of the process that originated the event.

varchar(32)

NOT NULL

SourceSystemName

Name of the node that generated the event.

varchar(32)

NULL

SourceVirtualTime

Virtual time event was generated (originator’s time). int

NOT NULL

SourceFileTime

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

datetime

NOT NULL

MessageId

Message ID from message compiler.

int

NOT NULL

Severity

The level of the message.

varchar(16)

NULL