Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
The type of the label. For the list of values, click 
.
LabelType
FK NULL
DBINT
Foreign key from the Network Target table. Each label maps
to one and only one network target.
NetworkTargetID
AK-1, FK NOT NULL
DBSMALLINT
Identifies the routing client that can receive this label.
RoutingClientID
Logger_Admin Table
This table is in the 
To see database rules for these tables, click 
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 and Update Statistics operations.
These operations are run automatically as scheduled jobs.
Table 118: Indexes for Logger_Admin Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Logger_Admin
TableName, ScheduledAt, FunctionName
nonclustered located on PRIMARY
XIE1Logger_Admin
DateTime
nonclustered located on PRIMARY
XIE2Logger_Admin
RecoveryKey
clustered, unique, primary key
located on PRIMARY
XPKLogger_Admin
Fields in Logger_Admin Table :
Keys and Null Option:
Data Type:
Description:
Field Name:
IE-2 NOT NULL
DBDATETIME
The date and time at which the scheduled job was submitted.
DateTime
NULL
DBDATETIME
Time at which the operation completed.
EndTime
NULL
DBFLT8
For a Purge operation, the recovery key of the earliest record purged.
FromRecoveryKey
IE-1 NOT NULL
VNAME32
The operation performed; for example, Purge.
FunctionName
PK, AK-1 NOT NULL
DBFLT8
A value used internally by the ICM software to track the time the
record is created.
RecoveryKey
NULL
DBINT
For a Purge operation, the number of days records are retained.
Records older than this are deleted in the Purge.
Retain
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
227
Chapter 2:  All Tables
Logger_Admin Table