Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-196
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Script_Five_Minute Table
Script_Five_Minute Table
Central database only.
Contains statistics about each script version for the most recent five-minute interval.
The ICM software generates Script_Five_Minute records for each script.
Related tables:
Script (via ScriptID)
Table 2-158 Script_Five_Minute Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ScriptID
Foreign key from the Script table.
int
PK, FK, NOT
NULL
NULL
DateTime
Central Controller date and time at start of five-minute
interval.
interval.
smalldatetime
PK, NOT NULL
TimeZone
The time zone for the date and time. The value is the offset
in minutes from GMT.
in minutes from GMT.
int
PK, NOT NULL
CallsIncomingTo5
Number of calls that came into the script during the
five-minute interval.
five-minute interval.
int
NOT NULL
CallsRoutedTo5
Number of calls routed by the script during the
five-minute interval.
five-minute interval.
int
NOT NULL
CallsPerNode
An array indicating the number of calls that traversed each
node of the script during the five-minute interval. Each
element in the array is a short integer. An array for a script
with 40 nodes is stored in the database as a varbinary(80)
array.
node of the script during the five-minute interval. Each
element in the array is a short integer. An array for a script
with 40 nodes is stored in the database as a varbinary(80)
array.
varbinary(255)
NOT NULL
RecoveryDay
A value used internally by the ICM software to track
virtual time.
virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL