Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
2-160
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Galaxy_Gate Table
Galaxy_Gate Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a gate
configured on a Galaxy ACD.
configured on a Galaxy ACD.
Table 2-159 Galaxy_Gate Table Constraints
Constraint
Field Name(s)
PK
DateTime
GateID
PeripheralID
TimeZone
GateID
PeripheralID
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
SkillTargetID
SkillTargetID
Table 2-160 Galaxy_Gate Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
CallsAbandoned
Number of external, internal gate transfer, and
internal gate calls for the gate that were lost before
being connected to an agent position.
internal gate calls for the gate that were lost before
being connected to an agent position.
DBSMALLINT
NOT NULL
CallsHeld
Number of external, internal gate transfer, internal
gate, and overflow/diversion-in calls that were
either abandoned or held beyond a specific system
threshold.
gate, and overflow/diversion-in calls that were
either abandoned or held beyond a specific system
threshold.
DBSMALLINT
NOT NULL
CallsTransferredIn
Number of calls directly transferred to primary
agents for this gate.
agents for this gate.
DBINT
NOT NULL
CallsTransferredOut
Number of external, internal gate transfer, internal
gate, or overflow/diversion-in calls that were
handed by the gate and then transferred.
gate, or overflow/diversion-in calls that were
handed by the gate and then transferred.
DBSMALLINT
NOT NULL
DateTime
The Central Controller date and time at the
beginning of the reporting interval.
beginning of the reporting interval.
DBDATETIME
PK
NOT NULL
DelayTimeToAbandoned
Total time, in seconds, that external, internal gate,
internal gate transfer, and overflow/diversion-in
calls waited before being lost.
internal gate transfer, and overflow/diversion-in
calls waited before being lost.
DBINT
NOT NULL
DelayTimeToHandle
Total time, in seconds, that external, internal gate,
internal gate transfer, and overflow/diversion-in
calls waited before being answered by an agent.
internal gate transfer, and overflow/diversion-in
calls waited before being answered by an agent.
DBINT
NOT NULL
GateID
The Galaxy identifier for the gate.
DBSMALLINT
PK
NOT NULL
LoadTransferOutCalls
This field applies to Galaxy-8 ACDs only.
DBSMALLINT
NOT NULL