Technical References

Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
The type of the label. For the list of values, click here (page
478).
LabelType
FK NULLDBINT
Foreign key from the Network Target table. Each label maps
to one and only one network target.
NetworkTargetID
AK-1, FK NOT NULLDBSMALLINT
Identifies the routing client that can receive this label.
RoutingClientID
Logger_Admin Table
This table is in the System category (page 460). To see database rules for these tables, click here
(page 511).
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_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Logger_Admin
TableName, ScheduledAt, FunctionNamenonclustered located on PRIMARYXIE1Logger_Admin
DateTimenonclustered located on PRIMARYXIE2Logger_Admin
RecoveryKeyclustered, 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 NULLDBDATETIME
The date and time at which the scheduled job was submitted.
DateTime
NULLDBDATETIME
Time at which the operation completed.
EndTime
NULLDBFLT8
For a Purge operation, the recovery key of the earliest record purged.
FromRecoveryKey
IE-1 NOT NULLVNAME32
The operation performed; for example, Purge.
FunctionName
PK, AK-1 NOT NULLDBFLT8
A value used internally by the ICM software to track the time the
record is created.
RecoveryKey
NULLDBINT
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