Cisco Cisco Administrative Workstation Technical References

Page of 404
 
2-195
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Script_Data Table
Related tables:
Route Call Detail (via LocalID)
Script (via ScriptID)
Script_Data Table
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.
Related tables:
Script (via ScriptID)
TargetType
(continued)
33  =  Network VRU Script
34  =  Scheduled Target
35  =  Network VRU
36  =  Skill Group Member
37  =  Expanded Call Variable
38  =  Agent Team
39  =  Campaign
40  =  Dialer
41  =  Import Rule
42  =  Query Rule
43  =  Campaign Query Rule
44  =  Dialer Port Map
45  =  Message Category
46  =  Message Destination
47  =  Response Template
smallint
NOT NULL
ForeignKey
Foreign key from a configuration table. This is always an ID 
field.
int
IE1, NULL
Table 2-156 Script_Cross_Reference Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-157 Script_Data Table
Field Name
Description
Data Type
Keys and Null 
Option
ScriptID
Foreign key from Script table.
int
PK, FK, NOT 
NULL
RowOrder
Ordinal number of the rows that apply to a specific script.
int
PK, NOT NULL
ScriptData
Internal script representation.
image
NULL