Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Unified Intelligent Contact Management Software
  5. Technical References

Cisco Cisco Unified Intelligent Contact Management Software Technical References

Download
Page of 404
 
2-280
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Trunk Table
Related tables:
Logical Interface Controller (via LogicalControllerID)
Skill Target (via SkillTargetID)
Trunk Table
Each row describes a trunk associated with a peripheral. Trunks are grouped by the Trunk Group table.
Use the Trunk bulk configuration tools to add, update, and delete Trunk records.
Description
Additional information about the translation route.
varchar(255)
NULL
LogicalControllerID
The Logical Interface Controller associated with the 
translation route.
int
FK, NULL
Type
The type of translation route: 
1 = DNIS
2 = CDPD
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-182 Translation_Route Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-183 Trunk Table
Field Name
Description
Data Type
Keys and Null 
Option
TrunkID
A unique identifier for the trunk.
int
PK, NOT NULL
TrunkGroupID
Foreign key from the Trunk Group table.
int
AK1, FK, NOT 
NULL
TrunkNumber
Trunk number as understood by the peripheral.
int
AK1, NOT 
NULL
TrunkType
Type of trunk: 
1 = Local C.O.
2 = Foreign Exchange
3 = WATS
4 = DID/DNIS
5 = PRI
6 = Tie Line
7 = Interflow
smallint
NOT NULL
CircuitProvider
The carrier that provides the circuit.
varchar(32)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL