Cisco Cisco IPCC Web Option Technical References
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.
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
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
1 = remote ICM
DBINT
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Description
Additional information about the application
gateway.
gateway.
DESCRIPTION
NULL
Encryption
The encryption method used by the application
gateway:
gateway:
0 = none
1 = private key
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.
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.
application gateway.
DBINT
NOT NULL
ICRInstanceID
Identifies the ICM instance associated with the
application gateway.
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).
software should use when both are available: A or
B. This applies only when
ApplicationGatewayType is 0 (custom gateway).
char(1)
NULL