Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 404
 
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.
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
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
Version
The most recent version of the master script. ICM 
software uses only the most recent version.
int
AK1, NOT 
NULL
Author
User name of person who last modified the script 
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.
char(1)
NOT NULL
Description
Further information about the script.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
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.
int
NULL
Length
Number of bytes of data in the binary representation of 
the script.
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL