Technical References

index_keysindex_descriptionindex_name
ScriptIDclustered, unique, primary key
located on PRIMARY
XPKScript
Fields in Script Table:
Keys and Null Option:Data Type:Description:Field Name:
NULLVNAME32
User name of person who last modified the script version.
Author
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULLDBDATETIME
The date and time when the script version was saved.
DateTime
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULLDESCRIPTION
Further information about the script.
Description
NOT NULLDBINT
Number of bytes of data in the binary representation of the script.
Length
AK-1, FK NOT NULLDBINT
Foreign key from the Master Script table.
MasterScriptID
NULLDBINT
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 NULLDBINT
Unique identifier for a specific version of a script.
ScriptID
NOT NULLDBCHAR
Indicates whether the script was saved in an invalid state.
Valid
AK-1 NOT NULLDBINT
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 Script category (page 451). For database rules, click here. (page 509)
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.
Related tables
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
318
Chapter 2: All Tables
Script_Cross_Reference Table