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

Page of 404
 
2-134
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Network_Vru Table
Related tables:
Network Trunk Group (via NetworkTrunkGroupID)
Network_Vru Table
Contains one row for each network VRU. The ICM software can send a customer call to a network VRU. 
Use ICM Configuration Manager to create, modify, and delete Network VRU rows.
Related tables:
Customer Definition (via NetworkTargetID)
Network Target (via NetworkTargetID)
Network VRU Script (via NetworkTargetID)
InUseInboundTimeToday
Aggregate number of seconds that trunks in the network 
trunk group have been used for inbound calls since 
midnight.
int
NULL
InUseOutboundTimeHalf
Aggregate number of seconds that trunks in the network 
trunk group have been used for outbound calls during 
the current half-hour interval.
int
NULL
InUseOutboundTimeToday Aggregate number of seconds that trunks in the network 
trunk group have been used for outbound calls since 
midnight.
int
NULL
TrunksIdle
Number of trunks currently idle for the network trunk 
group.
int
NULL
TrunksInService
Number of trunks currently in service for the network 
trunk group.
int
NULL
Table 2-111 Network_Trunk_Group_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-112 Network_VRU Table
Field Name
Description
Data Type
Keys and Null 
Option
NetworkTargetID
Foreign key from the Network Target table.
int
PK, FK, NOT 
NULL
EnterpriseName
A name that is unique among all network VRUs in the 
enterprise.
varchar(32)
AK1, NOT 
NULL
Description
Additional information about the network VRU.
varchar(255)
NULL
Type
The type of network VRU. Valid options are: 2, 3, 5, 6, 7, 
and 8. (Types 1 and 4 are not implemented.)
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL