Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Related tables
 (via CustomerDefinitionID)
 (via LabelID)
(via NetworkTargetID)
 (via LabelID)
 (via RoutingClientID)
Table 116: Indexes for Label Table
index_keys
index_description
index_name
RoutingClientID, Label
nonclustered, unique, unique key
located on PRIMARY
XAK1Label
CustomerDefinitionID
nonclustered located on PRIMARY
XIE1Label
LabelID
clustered, unique, primary key
located on PRIMARY
XPKLabel
Fields in Label Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
ChangeStamp
FK, IE-1 NULL
DBINT
Identifies the customer associated with the label.
CustomerDefinitionID
NULL
DESCRIPTION
Additional information about the label.
Description
FK NULL
DBINT
For network VRU labels with multiple NAMs,
this 
field contains a foreign key to identify the
ICRInstanceID
Network Applications Manager (NAM) instance
for which the label is valid.
AK-1 NOT NULL
VNAME32
The label to be returned to the routing client.
Label
PK NOT NULL
DBINT
Unique identifier for this label.
LabelID
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
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
187
Chapter 2:  All Tables
Logger_Admin Table