Technical References

Script_Table_Column Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
Each row describes a column in a table from an external database that can be queried from
within routing scripts or administrative scripts.
Use ICM Configuration Manager to add, update, and delete Script_Table_Column records.
Related tables
Script Table (page 323) (via ScriptTableID)
Table 183: Indexes for Script_Table_Column Table
index_keysindex_descriptionindex_name
ScriptTableID, ColumnNamenonclustered, unique, unique key
located on PRIMARY
XAK1Script_Table_Column
ScriptTableColumnIDclustered, unique, primary key
located on PRIMARY
XPKScript_Table_Column
Fields in Script_Table_Column Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
AK-1 NOT NULLVNAME32
The name of the column in the external database.
ColumnName
NULLDESCRIPTION
Additional information about the column.
Description
PK NOT NULLDBINT
A unique identifier for this script table column.
ScriptTableColumnID
AK-1, FK NOT NULLDBINT
Foreign key from the Script_Table table.
ScriptTableID
Sec_Group Table
This table is in the Security category (page 455). To see database rules for these tables, click
here (page 510).
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.
Related table
User Group (page 427) (via UserGroupID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
324
Chapter 2: All Tables
Script_Table_Column Table