Technical References

Keys and Null Option:Data Type:Description:Field Name:
NULLimage
Internal real time data for the script.
ScriptMeters
Script_Table Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
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.
Use ICM Configuration Manager to add, update, and delete Script_Table records.
Related tables
Script Table Column (page 324) (via ScriptTableID)
Table 182: Indexes for Script_Table Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Script_Table
ScriptTableIDclustered, unique, primary key
located on PRIMARY
XPKScript_Table
Fields in Script_Table Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
Indicates how to query data from the table. Currently only SQL (1)
is supported.
AccessType
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Further information about the external table.
Description
AK-1 NOT NULLVNAME32
A name that is unique among all script tables defined in the ICM
database.
EnterpriseName
PK NOT NULLDBINT
A unique identifier for the external table.
ScriptTableID
NULLDESCRIPTION
The path of the database table as reached by Side A of the ICM
Central Controller.
SideA
NULLDESCRIPTION
The path of the database table as reached by Side B of the ICM
Central Controller.
SideB
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
323
Chapter 2: All Tables
Script_Table Table