Cisco Cisco IPCC Web Option Technical References

PK, FK NOT NULL

DBINT

Foreign key from Script table.

ScriptID

Script_Five_Minute Table

This table is part of the 

. For database rules, click 

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.

RecoveryKey

nonclustered, unique, unique key
located on PRIMARY

XAK1Script_Five_Minute

ScriptID, DateTime, TimeZone

clustered, unique, primary key
located on PRIMARY

XPKScript_Five_Minute

NOT NULL

DBINT

Number of calls that came into the script during the five-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 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 NULL

DBINT

Number of calls that came into the script during the five-minute
interval.

CallsRoutedTo5

PK NOT NULL

DBSMALLDATE

Central Controller date and time at start of five-minute interval.

DateTime

NOT NULL

DBINT

Currently not used, set to zero (0).

RecoveryDay

AK-1 NOT NULL

DBFLT8

A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.

RecoveryKey

PK, FK NOT NULL

DBINT

Foreign key from the Script table.

ScriptID

PK NOT NULL

DBINT

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)