/mcpTable 381: Fields in Script_Table Table Keys and NULL Option Data Type Description Name NOT NULL DBSMALLINT Indicates how to query data from the table. Currently only SQL (1) is supported. AccessType NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp 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 system 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 Central Controller. SideA NULL DESCRIPTION The path of the database table as reached by Side B of the Central Controller. SideB NOT NULL DBINT Indicates the connection mode type to the external database. 0 - Non-Secured Mode 1 - Secured mode Note The default values is 0. SecuredMode NULL DBINT Future use FutureUseInt1 NULL DBINT Future use FutureUseInt2 NULL VARCHAR(64) Future Use FutureUseVarChar1 NULL VARCHAR(64) Future Use FutureUseVarChar2 Script_Table_Column This table is part of the Script category (see Script, on page 629). For database rules, see Script Tables, on page 701. Each row describes a column in a table from an external database that can be queried from within routing scripts or administrative scripts. Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 449 All Tables Script_Table_Column