Cisco Cisco IPCC Web Option Technical References
2-157
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Route Table
Route Table
Each row represents a possible destination for a call.
Use Configuration Manager to add, update, and delete Route records.
Related tables:
Peripheral Default Route (via RouteID)
Peripheral Target (via RouteID)
Route Call Detail (via RouteID)
Route Five Minute (via RouteID)
Route Half Hour (via RouteID)
Route Real Time (via RouteID)
Service (ServiceSkillTargetID maps to Service.SkillTargetID)
Skill Target (via SkillTargetID)
Termination Call Detail (via RouteID)
Table 2-138 Route Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RouteID
Unique identifier for the route.
int
PK, NOT NULL
EnterpriseName
An enterprise name for the route. This must be unique
among all routes in the enterprise.
among all routes in the enterprise.
varchar(32)
AK1, NOT
NULL
NULL
ServiceSkillTargetID
Associated Service.SkillTargetID. Every route that
terminates at a peripheral should have a service.
terminates at a peripheral should have a service.
int
FK, NULL
SkillTargetID
Foreign key from the Skill Target table that represents the
destination of the route. The destination is a Service, Skill
Group, Agent, or Translation Route.
destination of the route. The destination is a Service, Skill
Group, Agent, or Translation Route.
int
FK, NULL
Description
Additional information about the route.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL