Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-93
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Galaxy_Gate Table
SkillTargetID
The ICM software identifier for the service.
int
FK, NULL
PeripheralTimeZone
The time zone for the ACD. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
NOT NULL
SecondsInPeriod
Number of seconds in the reporting period.
smallint
NOT NULL
PrimaryHandled
Number of external, internal gate transfer, and
internal gate calls connected to primary agents
for the gate during the interval.
internal gate calls connected to primary agents
for the gate during the interval.
smallint
NOT NULL
SecondaryHandled
Number of external, internal gate transfer, and
internal gate calls connected to secondary
agents for the gate during the interval.
internal gate calls connected to secondary
agents for the gate during the interval.
smallint
NOT NULL
OverflowHandled
Number of external, internal gate transfer, and
internal gate calls for other gates that were
handled by agents in this gate because of their
secondary assignments.
internal gate calls for other gates that were
handled by agents in this gate because of their
secondary assignments.
smallint
NOT NULL
PrimaryODHandled
Number of overflow/diversion in calls
connected to primary agents for this gate.
connected to primary agents for this gate.
smallint
NOT NULL
SecondaryODHandled
Number of overflow/diversion in calls for this
gate that were handed by agents in other gates
because of their secondary assignments.
gate that were handed by agents in other gates
because of their secondary assignments.
smallint
NOT NULL
OverflowODHandled
Number of overflow/diversion calls for other
gates that were handled by agents in this gate
because of their secondary assignments.
gates that were handled by agents in this gate
because of their secondary assignments.
smallint
NOT NULL
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.
smallint
NOT NULL
ODAbandoned
Number of overflow/diversion-in calls accepted
from another node, but lost before being
connected to an agent position.
from another node, but lost before being
connected to an agent position.
smallint
NOT NULL
ODInRejected
Number of overflow/diversion-in calls rejected
by this gate.
by this gate.
smallint
NOT NULL
LoadTransferOutCalls
This field applies to Galaxy-8 ACDs only.
smallint
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.
internal gate, and overflow/diversion-in calls
that were either abandoned or held beyond a
specific system threshold.
smallint
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.
internal gate, or overflow/diversion-in calls that
were handed by the gate and then transferred.
smallint
NOT NULL
OutCalls
Number of out calls made by primary agents for
this gate on outbound trunks or dial tandem
tie-lines.
this gate on outbound trunks or dial tandem
tie-lines.
smallint
NOT NULL
Table 2-79 Galaxy_Gate Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option