Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Route Table
This table is in the
Each row represents a possible destination for a call. Use Configuration Manager to add, update,
and delete Route records.
and delete Route records.
Related tables
RouteID)
(via
RouteID)
RouteID)
RouteID)
RouteID)
(via
RouteID)
RouteID
SkillTargetID)
(ServiceSkillTargetID
maps to Service.SkillTargetID)
Table 157: Indexes for Route Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Route
SkillTargetID, ServiceSkillTargetID
nonclustered located on PRIMARY
X1E1Route
RouteID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKRoute
Fields in Route Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NOT NULL
DBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULL
DESCRIPTION
Additional information about the route.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for the route. This must be
unique among all routes in the enterprise.
unique among all routes in the enterprise.
EnterpriseName
PK NOT NULL
DBINT
Unique identifier for the route.
RouteID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
235
Chapter 2: All Tables
Route Table