Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

ScriptID

clustered, unique, primary key
located on PRIMARY

XPKScript

NULL

VNAME32

User name of person who last modified the script version.

Author

NOT NULL

CHANGESTAMP

Incremented when the record is changed in the central database.

ChangeStamp

NOT NULL

DBDATETIME

The date and time when the script version was saved.

DateTime

NOT NULL

DBCHAR

Deleted Flag. Stored as a character:

Deleted

• Y = Yes

• N = No

NULL

DESCRIPTION

Further information about the script.

Description

NOT NULL

DBINT

Number of bytes of data in the binary representation of the script.

Length

AK-1, FK NOT NULL

DBINT

Foreign key from the Master Script table.

MasterScriptID

NULL

DBINT

If this version was created by using Quick Edit, this field
indicates the previous script version. The metering information
from the base version can be carried over to the new version.

QuickEditBaseVersion

PK NOT NULL

DBINT

Unique identifier for a specific version of a script.

ScriptID

NOT NULL

DBCHAR

Indicates whether the script was saved in an invalid state.

Valid

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 

. For database rules, click 

It contains information about which configuration objects each script version references. This
information is used to determine whether a script version becomes invalid when configuration
information changes.

The ICM software automatically maintains the Script_Cross_Reference table.

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)