Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Related tables
Table 176: Indexes for Script_Data Table
index_keys
index_description
index_name
ScriptID, RowOrder
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKScript_Data
Fields in Script_Data Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
Ordinal number of the rows that apply to a specific script.
RowOrder
NULL
image
Internal script representation.
ScriptData
PK, FK NOT NULL
DBINT
Foreign key from Script table.
ScriptID
Script_Five_Minute Table
This table is part of the
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.
interval. The ICM software generates Script_Five_Minute records for each script.
Related tables
Table 177: Indexes for Script_Five_Minute Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Script_Five_Minute
ScriptID, DateTime, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKScript_Five_Minute
Fields in Script_Five_Minute Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
Number of calls that came into the script during the
fi
fi
ve-minute interval.
CallsIncomingTo5
NOT NULL
varchar
An array indicating the number of calls that traversed
each node of the script during the five-minute interval.
each node of the script during the five-minute interval.
CallsPerNode
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.
for a script with 40 nodes is stored in the database as
a varbinary(80) array.
NOT NULL
DBINT
Number of calls that came into the script during the
fi
fi
ve-minute interval.
CallsRoutedTo5
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
274
Chapter 2: - All Tables
Script_Five_Minute Table