Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-194
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Script_Cross_Reference Table
Script_Cross_Reference Table
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.
is used to determine whether a script version becomes invalid when configuration information changes.
The ICM software automatically maintains the Script_Cross_Reference table.
Table 2-156 Script_Cross_Reference Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ScriptID
Foreign key from Script table.
int
PK, FK, NOT
NULL
NULL
LocalID
Local ID in script that cross references a foreign key field in
one of the other configuration tables.
one of the other configuration tables.
int
PK, NOT NULL
TargetType
Type of table to which the ForeignKey applies.
0
=
Unknown
1
=
Service
2
=
Skill Group
3
=
Agent
4
=
Translation Route
5
=
Agent Administration Group
6
=
Announcement
7
=
Call Type
8
=
Enterprise Service
9
=
Enterprise Skill Group
10
=
Region
11
=
Dialed Number
12
=
Logical Interface Controller
13
=
Physical Interface Controller
14
=
Peripheral
15
=
Routing Client
16
=
Trunk Group
17
=
Route
18
=
Peripheral Target
19
=
Label
20
=
Master Script
21
=
Script Table
22
=
Script Table Column
23
=
Script
24 = Schedule
25 = ICR View
26 = View Column
27 = Network Trunk Group
28 = Service Array
29 = Application Gateway
30 = Device Target
31 = User Variable
32 = User Formula
25 = ICR View
26 = View Column
27 = Network Trunk Group
28 = Service Array
29 = Application Gateway
30 = Device Target
31 = User Variable
32 = User Formula
smallint
NOT NULL