Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 557
 (via EntityID)
Table 121: Indexes for Master_Script Table
index_keys
index_description
index_name
CustomerIdShadow, EntityID,
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Master_Script
MasterScriptID
clustered, unique, primary key
located on PRIMARY
XPKMaster_Script
Fields in Master_Script Table:
Keys and Null
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
ChangeStamp
NOT NULL
DBINT
Specifies the version of the script that is currently
available for use.
CurrentVersion
FK NULL
DBINT
Identifies the customer definition associated with
the script.
CustomerDefinitionID
AK-1 NOT NULL
DBINT
A “shadow” CustomerDefinitionID that allows
multiple scripts with the same EnterpriseName
and different customer numbers.
CustomerIdShadow
NULL
DESCRIPTION
Additional information about the script.
Description
AK-1 NOT NULL
varchar(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 NULL
DBINT
If partitioning is enabled, indicates the business
entity to which the master script belongs.
EntityID
PK NOT NULL
DBINT
Unique identifier for this master script.
MasterScriptID
NOT NULL
DBINT
The next version number available for the script.
NextAvailableVersion
NOT NULL
DBSMALLINT
Indicates whether the script is a routing script or
an administrative script.
ScriptType
Media_Class Table
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.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
193
Chapter 2:  All Tables
Media_Class Table