Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Foreign key from the Network Target table.
NetworkTargetID
PK, FK NOT NULL
DBINT
The type of network VRU. Valid options are: 2, 3, 5, 6, 7, and 8.
(Types and are not implemented.)
Type
To see more on these values, click 
.
Network_Vru_Bank Table
This table is in the 
This table is mainly used for load-balancing calls across multiple IVRs. The trunk group capacity
will be the key to the selection of an IVR for queuing.
Related tables
 (via CustomerDefinitionID)
 (via NetworkTargetID)
Table 131: Indexes for Network_Vru_Bank Table
index_keys
index_description
index_name
TrunkGroupID
nonclustered, unique, unique key
located on PRIMARY
XAK1Network_Vru_Bank
NetworkTargetID
clustered, unique, primary key
located on PRIMARY
XPKNetwork_Vru_Bank
Fields in Network_Vru_Bank Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
ChangeStamp
PK, NOT NULL
DBINT
Unique identifier for the Network VRU member.
NetworkTargetID
FK, NOT NULL
DBINT
Foreign key from the Network Target table. This is
pointing at the type-9 Network VRU.
NetworkVruNetworkTargetID
NULL
DBINT
Foreign key from Translation Route.
TranslationRouteSkillTargetID
FK, NOT NULL
DBINT
Foreign key from the Trunk Group table. Indicates the
Trunk Group associated with this Network VRU member.
TrunkGroupID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
245
Chapter 2:  All Tables
Network_Vru_Bank Table