Technical References

Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Foreign key from the Network Target table.
NetworkTargetID
PK, FK NOT NULLDBINT
The type of network VRU. Valid options are: 2, 3, 5, 6, 7, and 8.
(Types 1 and 4 are not implemented.)
Type
To see more on these values, click here (page 480).
Network_Vru_Bank Table
This table is in the Route category (page 447). To see database rules for these tables, click here
(page 507).
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
Customer Definition (page 153) (via CustomerDefinitionID)
Network Vru (page 244) (via NetworkTargetID)
Table 131: Indexes for Network_Vru_Bank Table
index_keysindex_descriptionindex_name
TrunkGroupIDnonclustered, unique, unique key
located on PRIMARY
XAK1Network_Vru_Bank
NetworkTargetIDclustered, 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 NULLCHANGESTAMPChangeStamp
PK, NOT NULLDBINT
Unique identifier for the Network VRU member.
NetworkTargetID
FK, NOT NULLDBINT
Foreign key from the Network Target table. This is
pointing at the type-9 Network VRU.
NetworkVruNetworkTargetID
NULLDBINT
Foreign key from Translation Route.
TranslationRouteSkillTargetID
FK, NOT NULLDBINT
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