Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBDATETIME
Central Controller date and time that this data was last
updated.
updated.
DateTime
NOT NULL
DBINT
Elapsed time spent processing the script.
ElapsedTime
PK, FK NOT NULL
DBINT
Foreign key from the Script Table.
ScriptID
NULL
image
Internal real time data for the script.
ScriptMeters
Script_Table Table
This table is part of the
Each row describes a table from an external database that can be queried from within routing
scripts or administrative scripts using the optional Gateway SQL feature.
scripts or administrative scripts using the optional Gateway SQL feature.
Use ICM Configuration Manager to add, update, and delete Script_Table records.
Related tables
(via ScriptTableID)
Table 181: Indexes for Script_Table Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Script_Table
ScriptTableID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKScript_Table
Fields in Script_Table Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
Indicates how to query data from the table. Currently
only SQL (1) is supported.
only SQL (1) is supported.
AccessType
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central
database.
database.
ChangeStamp
NULL
DESCRIPTION
Further information about the external table.
Description
AK-1 NOT NULL
VNAME32
A name that is unique among all script tables defined
in the ICM database.
in the ICM database.
EnterpriseName
PK NOT NULL
DBINT
A unique identifier for the external table.
ScriptTableID
NULL
DESCRIPTION
The path of the database table as reached by Side A
of the ICM Central Controller.
of the ICM Central Controller.
SideA
NULL
DESCRIPTION
The path of the database table as reached by Side B
of the ICM Central Controller.
of the ICM Central Controller.
SideB
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
277
Chapter 2: All Tables
Script_Table Table