Cisco Cisco IPCC Web Option Technical References
2-125
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Master_Script Table
Related tables:
Network Trunk Group (via LogicalControllerID)
Peripheral (via LogicalControllerID)
Physical Interface Controller (via LogicalControllerID)
Routing Client (via LogicalControllerID)
Service Array (via LogicalControllerID)
Translation Route (via LogicalControllerID)
Master_Script Table
Each row identifies a routing script or an administrative script. Each master script might have several
versions. Information about each version is stored in the Script table.
versions. Information about each version is stored in the Script table.
A new Master_Script record is created whenever you save a script with a new name in the Script Editor.
SecondaryCtiAddress
The address for the backup CTI Server as IP:port (either
in dotted-numeric or name format).
in dotted-numeric or name format).
varchar(32)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-103 Logical_Interface_Controller Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-104 Master_Script Table
Field Name
Description
Data Type
Keys and Null
Option
Option
MasterScriptID
Unique identifier for this master script.
int
PK, NOT NULL
CustomerDefinitionID
Identifies the customer definition associated with the
script.
script.
int
FK, NULL
CustomerIDShadow
A “shadow” CustomerDefinitionID that allows multiple
scripts with the same EnterpriseName and different
customer numbers.
scripts with the same EnterpriseName and different
customer numbers.
int
AK, NULL
EntityID
If partitioning is enabled, indicates the business entity to
which the master script belongs.
which the master script belongs.
int
AK, FK, NOT
NULL
NULL
EnterpriseName
An enterprise name for the master script. The name must
be unique among all master scripts within the business
entity.
be unique among all master scripts within the business
entity.
varchar(32)
AK, NOT NULL
CurrentVersion
Specifies the version of the script that is currently
available for use.
available for use.
int
NOT NULL
NextAvailableVersion
The next version number available for the script.
int
NOT NULL
Description
Additional information about the script.
varchar(255)
NULL