Cisco Cisco IPCC Web Option Technical References

Page of 548
   
2-49
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Application_Gateway Table
Application_Gateway Table 
Each row describes an external application (custom gateway) or another ICM platform that you can 
invoke from a routing script or administrative script.
Use ICM Configuration Manager to add, update, and delete Application_Gateway records.
Table 2-35 Application_Gateway Table Constraints
Constraint
Field Name(s)
PK
ApplicationGatewayID
AK-1
EnterpriseName
FK
ICRInstanceID
IE-1
ICRInstanceID
Table 2-36 Application_Gateway Table
Field Name
Description
Data Type
Keys and 
Null Option
ApplicationGatewayID
A unique identifier for the application gateway.
DBINT
PK
NOT NULL
ApplicationGatewayType
The type of gateway:
0 = custom gateway
1 = remote ICM
DBINT
NOT NULL
ChangeStamp
Incremented when the record is changed in the 
central database.
CHANGESTAMP
NOT NULL
Description
Additional information about the application 
gateway.
DESCRIPTION
NULL
Encryption
The encryption method used by the application 
gateway: 
0 = none
1 = private key
DBINT
NOT NULL
EnterpriseName
An enterprise name for the application gateway. 
This name must be unique among all application 
gateways in the enterprise.
VNAME32
AK-1
NOT NULL
FaultTolerance
The fault-tolerance strategy used by the 
application gateway. 
DBINT
NOT NULL
ICRInstanceID
Identifies the ICM instance associated with the 
application gateway.
DBINT
FK, IE-1
NULL
PreferredSide
Indicates which side of the Gateway the ICM 
software should use when both are available: A or 
B. This applies only when 
ApplicationGatewayType is 0 (custom gateway).
char(1)
NULL