Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-193
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Script Table
Script Table
Each row represents a version of a routing script or an administrative script. You can save multiple
versions of each script. The binary representation of the script version is stored in the Script_Data table.
General information that applies to all versions of a script is stored in the Master Script table.
versions of each script. The binary representation of the script version is stored in the Script_Data table.
General information that applies to all versions of a script is stored in the Master Script table.
Use the Script Editor to create and modify scripts.
Related tables:
Call Type Real Time (via ScriptID)
Master Script (via MasterScriptID)
Route Call Data (via ScriptID)
Script Cross Reference (via ScriptID)
Script Data (via ScriptID)
Script Print Control (via ScriptID)
Script Real Time (via ScriptID)
Script Five Minute (via ScriptID)
Table 2-155 Script Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ScriptID
Unique identifier for a specific version of a script.
int
PK, NOT NULL
MasterScriptID
Foreign key from the Master Script table.
int
AK1, FK, NOT
NULL
NULL
Version
The most recent version of the master script. ICM
software uses only the most recent version.
software uses only the most recent version.
int
AK1, NOT
NULL
NULL
Author
User name of person who last modified the script
version.
version.
varchar(32)
NULL
DateTime
The date and time when the script version was saved.
datetime
NOT NULL
Valid
Indicates whether the script was saved in an invalid
state.
state.
char(1)
NOT NULL
Description
Further information about the script.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NOT NULL
QuickEditBaseVersion
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.
field indicates the previous script version. The metering
information from the base version can be carried over to
the new version.
int
NULL
Length
Number of bytes of data in the binary representation of
the script.
the script.
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL