Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-310
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Script_Table Table
Script_Table Table
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.
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 2-329 Script Table Table Constraints
Constraint
Field Name(s)
PK
ScriptTableID
AK-1
EnterpriseName
Table 2-330 Script Table Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AccessType
Indicates how to query data from the table.
Currently only SQL (1) is supported.
Currently only SQL (1) is supported.
DBSMALLINT
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Description
Further information about the external table.
DESCRIPTION
NULL
EnterpriseName
A name that is unique among all script tables
defined in the ICM database.
defined in the ICM database.
VNAME32
AK-1
NOT NULL
ScriptTableID
A unique identifier for the external table.
DBINT
PK
NOT NULL
SideA
The path of the database table as reached by Side
A of the ICM Central Controller.
A of the ICM Central Controller.
DESCRIPTION
NULL
SideB
The path of the database table as reached by Side
B of the ICM Central Controller.
B of the ICM Central Controller.
DESCRIPTION
NULL