Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Script_Table_Column Table
This table is part of the
Each row describes a column in a table from an external database that can be queried from
within routing scripts or administrative scripts.
within routing scripts or administrative scripts.
Use ICM Configuration Manager to add, update, and delete Script_Table_Column records.
Related tables
(via ScriptTableID)
Table 183: Indexes for Script_Table_Column Table
index_keys
index_description
index_name
ScriptTableID, ColumnName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Script_Table_Column
ScriptTableColumnID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKScript_Table_Column
Fields in Script_Table_Column Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
AK-1 NOT NULL
VNAME32
The name of the column in the external database.
ColumnName
NULL
DESCRIPTION
Additional information about the column.
Description
PK NOT NULL
DBINT
A unique identifier for this script table column.
ScriptTableColumnID
AK-1, FK NOT NULL
DBINT
Foreign key from the Script_Table table.
ScriptTableID
Sec_Group Table
. To see database rules for these tables, click
Used internally to track the state of records in the User_Group table. The Sec_Group table
contains one row for each User_Group row.
contains one row for each User_Group row.
Related table
(via UserGroupID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
324
Chapter 2: All Tables
Script_Table_Column Table