Cisco Cisco IPCC Web Option Références techniques
1-14
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 1 Introduction
Major Tables
Each dialed number recognized by the system is represented by a row in the Dialed Number table. Each
call type maps to zero, one, or more dialed numbers. Each dialed number maps to zero, one, or more call
types. The Dialed Number Map table is a cross-reference table between the Dialed Number and Call
Type tables.
call type maps to zero, one, or more dialed numbers. Each dialed number maps to zero, one, or more call
types. The Dialed Number Map table is a cross-reference table between the Dialed Number and Call
Type tables.
Each Dialed Number Map row also references caller-entered digits that are valid for the call type and the
calling line IDs that are valid for the call type. Each calling line ID might be a complete 10-digit phone
number, a prefix, or a region.
calling line IDs that are valid for the call type. Each calling line ID might be a complete 10-digit phone
number, a prefix, or a region.
Each region recognized by the system is represented by a row in the Region table. A region consists of
one or more prefixes. Any calling number with leading digits matching a prefix is considered part of the
region. You can combine regions to create aggregate regions.
one or more prefixes. Any calling number with leading digits matching a prefix is considered part of the
region. You can combine regions to create aggregate regions.
Script Detail
depicts the tables in this category.
Figure 1-10 Script Detail
The Script Cross Reference table keeps track of the configuration objects each script version references.
Certain entries in ICM software are updated continuously. The Script Five Minute table contains the
statistics for those entries accumulated during the last five minutes for each script.
statistics for those entries accumulated during the last five minutes for each script.
The Script Real Time table contains real-time information about each script. ICM software updates the
real-time data each time it executes a script. The Admin Workstation receives updated data every 15
seconds. The real-time data for current script versions is updated at midnight.
real-time data each time it executes a script. The Admin Workstation receives updated data every 15
seconds. The real-time data for current script versions is updated at midnight.
Each row in the Script Print Control table contains default print settings for a specific script version.
The Script Queue Real Time table maintains the queuing real-time statistics for each script. If a script
has a queue node, this table contains an entry for that script with queuing data such as TimeInQueue and
TasksQueued. This table also stores the time this data was accumulated.
has a queue node, this table contains an entry for that script with queuing data such as TimeInQueue and
TasksQueued. This table also stores the time this data was accumulated.
The Script Data table contains a binary version of a routing script or administrative script. The
information about the nodes and their properties are stored in this table for each script.
information about the nodes and their properties are stored in this table for each script.