Cisco Cisco IP Contact Center Release 4.6.1 Technical References

2-199

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

Chapter 2 Table Details

Logger_Admin Table

Central database only.

Contains one record of information for each administrative task the ICM software applies to the central
database. Specifically, this table tracks Purges. These operations are run automatically as scheduled
jobs.

Table 2-203 Logger_Admin Table Constraints

Constraint

Field Name(s)

RecoveryKey

AK-1

RecoveryKey

IE-1

FunctionName
ScheduledAt
TableName

IE-2

DateTime

Table 2-204 Logger_Admin Table

Field Name

Description

Data Type

Keys and
Null Option

DateTime

The date and time at which the scheduled job was
submitted.

DBDATETIME

IE-2

NOT NULL

EndTime

Time at which the operation completed.

DBDATETIME

NULL

FromRecoveryKey

For a Purge operation, the recovery key of the
earliest record purged.

DBFLT8

NULL

FunctionName

The operation performed; for example, Purge or
Update Statistics.

VNAME32

IE-1

NOT NULL

RecoveryKey

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

DBFLT8

PK, AK-1

NOT NULL

Retain

For a Purge operation, the number of days records
are retained. Records older than this are deleted in
the Purge.

DBINT

NULL

RowsPurged

For a purge operation, the number of rows purged. DBINT

NULL

ScheduledAt

Date and time the scheduled job executed.

DBDATETIME

IE-1

NOT NULL

StartTime

Time at which the operation started.

DBDATETIME

NULL

TableName

The name of the database table on which the
operation was performed.

VNAME32

IE-1

NOT NULL

ToRecoveryKey

For a Purge operation, the recovery key of the
most recent record purged.

DBFLT8

NULL