Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBSMALLDATE
Central Controller date and time at start of five-minute
interval.
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.
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).
offset in minutes from UTC (formerly called GMT).
TimeZone
Script_Print_Control Table
This table is part of the
Each row contains default print settings for a specific script version. The Script Editor
automatically maintains the Script_Print_Control table.
automatically maintains the Script_Print_Control table.
Related tables
Table 178: Indexes for Script_Print_Control Table
index_keys
index_description
index_name
ScriptID
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Script_Print_Control
ScriptPrintControlID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKScript_Print_Control
Fields in Script_Print_Control Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
varchar(255)
A string specifying the print settings for the
script.
script.
PrintControlSettings
AK-1, FK NOT NULL
DBINT
Foreign key from Script table.
ScriptID
PK NOT NULL
DBINT
A unique identifier for the row.
ScriptPrintControlID
Script_Queue_Real_Time Table
This table is part of the
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
275
Chapter 2: All Tables
Script_Print_Control Table