Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-46
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Call_Type_Real_Time Table
Related tables:
Call Type (via CallTypeID)
Master Script (via MasterScriptID)
Call_Type_Real_Time Table  
Local database only.
Provides real-time statistics for each call type defined in the ICM software. The ICM software generates 
a Call_Type_Real_Time record for each call type.
ScriptSchedule
A script schedule entry in an internal format used by the Script 
Editor.
varchar(64)
NULL
Description
Additional information about the association of this script to 
this call type.
varchar(255)
NULL
Table 2-30 Call_Type_Map Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-31 Call_Type_Real_Time Table
Field Name
Description
Data Type
Keys and Null 
Option
CallTypeID
Identifies the call type.
int
PK, FK, NOT 
NULL
DateTime
The date and time when the row was generated.
Datetime
NOT NULL
AvgRouterDelayQHalf
Average number of seconds spent in the 
CallRouter queue for calls of this type that were 
removed from the queue during the current half- 
hour interval.
int
NULL
AvgRouterDelayQNow
Average number of seconds spent in the 
CallRouter queue for calls of this type that are 
currently in queue.
int
NULL
AvgRouterDelayQTo5
Average number of seconds spent in the 
CallRouter queue for calls of this type that were 
removed from the queue during the five- minute 
interval.
int
NULL
AvgRouterDelayQToday
Average number of seconds spent in the 
CallRouter queue for calls of this type that were 
removed from the queue since midnight.
int
NULL
CallsRoutedToday
Number of calls of this type that have been routed 
since midnight.
int
NULL
CallsRoutedToHalf
Number of calls of this type that have been routed 
during the current half-hour interval.
int
NULL