Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null
Option:
Data Type:
Description:
Field Name:
AK-1 NOT NULL
DBINT
The active version of the master script. ICM
software uses only the active version.
Version
Script_Cross_Reference Table
This table is part of the 
It contains information about which configuration objects each script version references. This
information is used to determine whether a script version becomes invalid when con
figuration
information changes.
The ICM software automatically maintains the Script_Cross_Reference table.
Related tables
 (via LocalID)
Table 175: Indexes for Script_Cross_Reference Table
index_keys
index_description
index_name
ForeignKey
nonclustered located on PRIMARY
XIE1Script_Cross_Reference
ScriptID, LocalID
clustered, unique, primary key
located on PRIMARY
XPKScript_Cross_Reference
Fields in Script_Cross_Reference Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
IE-1 NOT NULL
DBINT
Foreign key from a configuration table. This is always an
ID 
field.
ForeignKey
PK NOT NULL
DBINT
Local ID in script that cross references a foreign key field
in one of the other con
figuration tables.
LocalID
PK, FK, NOT NULL
DBINT
Foreign key from Script table.
ScriptID
NOT NULL
DBSMALLINT
Type of table to which the ForeignKey applies. To see the
possible values, click 
.
TargetType
Script_Data Table
This table is part of the 
It contains a binary version of a routing script or administrative script. A long script may require
multiple Script_Data rows.
The Script Editor automatically maintains the Script_Data table.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
273
Chapter 2:  All Tables
Script_Cross_Reference Table