Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Unified Contact Center Enterprise 9.0(2)
  5. Technical References

Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Download
Page of 548
   
2-303
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
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.
The ICM software automatically maintains the Script_Cross_Reference table.
Table 2-317 Script_Cross_Reference Table Constraints
Constraint
Field Name(s)
PK
LocalID
ScriptID
FK
ScriptID
IE-1
ForeignKey
Table 2-318 Script_Cross_Reference Table
Field Name
Description
Data Type
Keys and 
Null Option
ForeignKey
Foreign key from a configuration table. This is 
always an ID field.
DBINT
IE-1
NOT NULL
LocalID
Local ID in script that cross references a foreign 
key field in one of the other configuration tables.
DBINT
PK
NOT NULL
ScriptID
Foreign key from Script table.
DBINT
PK, FK, 
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
DBSMALLINT
NOT NULL