Technical References

Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Foreign key from Script table.
ScriptID
Script_Five_Minute Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
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 (page 317) (via ScriptID)
Table 178: Indexes for Script_Five_Minute Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Script_Five_Minute
ScriptID, DateTime, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKScript_Five_Minute
Fields in Script_Five_Minute Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBINT
Number of calls that came into the script during the five-minute
interval.
CallsIncomingTo5
NOT NULLvarchar
An array indicating the number of calls that traversed each node of
the script during the five-minute interval. Each element in the array
CallsPerNode
is a short integer. An array for a script with 40 nodes is stored in
the database as a varbinary(80) array.
NOT NULLDBINT
Number of calls that came into the script during the five-minute
interval.
CallsRoutedTo5
PK NOT NULLDBSMALLDATE
Central Controller date and time at start of five-minute interval.
DateTime
NOT NULLDBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
PK, FK NOT NULLDBINT
Foreign key from the Script table.
ScriptID
PK NOT NULLDBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
320
Chapter 2: All Tables
Script_Five_Minute Table