Cisco Cisco IPCC Web Option Technical References
Fields in Call_Type_Map Table :
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Foreign key from the Call Type table. CallTypeID and Item together
form a unique key.
form a unique key.
CallTypeID
NULL
DESCRIPTION
Additional information about the association of this script to this call
type.
type.
Description
PK NOT NULL
DBINT
The position of this schedule entry within the list of entries for this
call type.
call type.
Item
FK, IE-1 NOT NULL
DBINT
Foreign key from the Master Script table.
MasterScriptID
NOT NULL
varchar(64)
A script schedule entry in an internal format used by the Script Editor.
ScriptSchedule
Call_Type_Real_Time Table
This table is part of the
Local database only.
Provides real-time statistics for each call type defined in the software. The software generates
a Call_Type_Real_Time record for each call type.
a Call_Type_Real_Time record for each call type.
Related tables
(via CallTypeID)
(via MasterScriptID)
Table 50: Indexes for Call_Type_Real_Time Table
index_keys
index_description
index_name
CallTypeID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKCall_Type_Real_Time
Fields in Call_Type_Real_Time Table :
Keys
and
Null
Option:
and
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Within the current half-hour interval, the number of calls that encountered
an error when the call is at the agent desktop.
an error when the call is at the agent desktop.
AgentErrorCountHalf
NULL
DBINT
The number of calls that encounter an error when the call is at the agent
desktop since midnight.
desktop since midnight.
AgentErrorCountToday
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
101
Chapter 2: All Tables
Call_Type_Real_Time Table