Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
The time zone in which the ACD is located. The
value is the offset in minutes from UTC (formerly
called GMT).
PeripheralTimeZone
NOT NULL
DBSMALLINT
Number of calls that rang at this termination but
were intercepted by another phone.
PickedUpCalls
PK NOT NULL
DBSMALLINT
Galaxy identifier for the phone’s port.
PortID
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
RecoveryKey
NOT NULL
DBINT
Total number of seconds that second calls were on
the phone.
SecondCallDuration
NOT NULL
DBSMALLINT
Number of calls made while a previous call is on
hold. Dialing an expanded PBX option feature also
counts as a second call.
SecondCalls
NOT NULL
DBSMALLINT
In a multiple subscriber system, indicates which
subscriber has control of the termination.
SubscriberNumber
NOT NULL
DBSMALLINT
42 = Tone PBX
TerminationType
PK NOT NULL
DBINT
The time zone for the date and time. The value is
the offset in minutes from UTC (formerly called
GMT).
TimeZone
NOT NULL
DBSMALLINT
Number of toll calls placed from the extension.
TollCalls
Galaxy_Single_Trunk Table
. For database rules, click 
.
Central database only.
This table applies to Rockwell Galaxy ACDs only.
Each row provides information about a trunk configured on a Galaxy ACD.
Related table
 (via PeripheralID)
 (via TrunkID)
Table 100: Indexes for Galaxy_Single_Trunk Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_Single_Trunk
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
164
Chapter 2: -  All Tables
Galaxy_Single_Trunk Table