Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-295
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
VRU_Port_Map Table
VRU_Port_Map Table
In cases where ACD and VRU PIMs are controlled by the same PG, the VRU_Port_Map table is used to 
specify how VRU ports map to ACD ports or trunks.
Use the VRU Port Map and Bulk Insert tool to map VRU ports to ACD ports or trunks.
Related tables:
Trunk (via TrunkID)
Table 2-200 VRU_Port_Map Table
Field Name
Description
Data Type
Keys and Null 
Option
TrunkID
The ID of the VRU trunk to be mapped.
int
PK, NOT NULL
Type
The type of VRU-to-ACD mapping:
0 = A VRU trunk-to-ACD trunk mapping
1 = A VRU trunk-to-ACD port mapping.
int
NOT NULL
ACDPeripheralID
The ID of ACD peripheral if Type is 1.
smallint
NULL
ACDPort
The ACD port if Type is 1.
varchar(32)
NULL
ACDTrunkID
The ID of the ACD trunk if Type is 0.
smallint
NULL