Cisco Cisco IPCC Web Option Technical References
1-15
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 1 Introduction
Major Tables
Route Data
shows the tables in this category.
Figure 1-11 Route Data
A route is a destination to which a call can be directed. Each route references a target at a peripheral:
that is, an agent, skill group, service, or a translation route. ICM software can also direct a call to an
announcement to be played to the caller or to a scheduled target.
that is, an agent, skill group, service, or a translation route. ICM software can also direct a call to an
announcement to be played to the caller or to a scheduled target.
Each route is represented by a row in the Route table. Each route has one or more associated Peripheral
Target rows. Each peripheral target row includes a DNIS (dialed number identification service) value and
a reference to a Trunk Group row.
Target rows. Each peripheral target row includes a DNIS (dialed number identification service) value and
a reference to a Trunk Group row.
Each Peripheral Target, Announcement, or Device Target, Network VRU, or Scheduled Target row is
associated with a Network Target row. Each Network Target is referenced by one or more Labels. Each
Label is valid for one or more Routing Clients. Optionally, the Dialed Number Label table indicates
which labels are valid for each dialed number. (For each routing client, you can indicate whether or not
to use the Dialed Number Label table.)
associated with a Network Target row. Each Network Target is referenced by one or more Labels. Each
Label is valid for one or more Routing Clients. Optionally, the Dialed Number Label table indicates
which labels are valid for each dialed number. (For each routing client, you can indicate whether or not
to use the Dialed Number Label table.)
If a route is associated with a peripheral target, then it is associated with a skill target. Each skill target
can be associated with zero, one, or more routes. (Regardless of the type of skill target associated with
a route, the route also has a separate association with a Service record. This indicates the type of service
to be provided to the caller.)
can be associated with zero, one, or more routes. (Regardless of the type of skill target associated with
a route, the route also has a separate association with a Service record. This indicates the type of service
to be provided to the caller.)