Technical References

Table 122: Indexes for Master_Script Table
index_keysindex_descriptionindex_name
CustomerIdShadow, EntityID,
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Master_Script
MasterScriptIDclustered, unique, primary key
located on PRIMARY
XPKMaster_Script
Fields in Master_Script Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULLDBINT
Specifies the version of the script that is currently available for
use.
CurrentVersion
FK NULLDBINT
Identifies the customer definition associated with the script.
CustomerDefinitionID
AK-1 NOT NULLDBINT
A “shadow” CustomerDefinitionID that allows multiple scripts
with the same EnterpriseName and different customer numbers.
CustomerIdShadow
NULLDESCRIPTION
Additional information about the script.
Description
AK-1 NOT NULLvarchar(64)
An enterprise name for the master script. The name must be
unique among all master scripts within the business entity.
EnterpriseName
AK-1, FK NOT NULLDBINT
If partitioning is enabled, indicates the business entity to which
the master script belongs.
EntityID
PK NOT NULLDBINT
Unique identifier for this master script.
MasterScriptID
NOT NULLDBINT
The next version number available for the script.
NextAvailableVersion
NOT NULLDBSMALLINT
Indicates whether the script is a routing script or an
administrative script.
ScriptType
Media_Class Table
This table is part of the Media Routing category (page 446). For database rules, click here. (page
507)
Information in this table defines a type of media class. This table is populated initially with
default media classes as listed in the MediaClassID field, below.
Related Table
Media Routing Domain (page 234) table via the MediaClassID field.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
233
Chapter 2: All Tables
Media_Class Table