Technical References

Central database only. This table applies to Rockwell Galaxy ACDs only. Each row provides
information about a PBX termination configured on a Galaxy ACD.
Related table
Peripheral (page 250) (via PeripheralID)
Table 100: Indexes for Galaxy_PBX Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_PBX
DateTime, PeripheralID, PortID, TimeZonenonclustered, unique, primary key
located on PRIMARY
XPKGalaxy_PBX
Fields in Galaxy_PBX Table:
Keys and Null Option:Data Type:Description:Field Name:
NULLDBSMALLINT
Number of calls to the destination that were abandoned.
AbandonedNoAnswer
NOT NULLDBINT
Total number of seconds for all incoming calls (counted from time
of answer or end of dialing until disconnect.
CallDuration
PK NOT NULLDBDATETIME
The date and time at the end of the reporting DBINTerval.
DateTime
NOT NULLDBSMALLINT
Identifier for the customer-defined group of PBX extensions.
DepartmentNumber
NOT NULLDBSMALLINT
Termination phone number.
EntensionNumber
NOT NULLDBSMALLINT
Number of calls automatically forwarded from this destination
because the termination is busy and is in a hunt group, or because
ForwardedCalls
either the All Calls or No Answer options of Call Forwarding were
in use.
NOT NULLDBSMALLINT
For valid options, click here (page 475).
HuntGroupInformation
NOT NULLDBSMALLINT
Number of calls answered by this termination.
InCalls
NOT NULLDBSMALLINT
If in the termination is in a hunt group, the phone number of the
next extension in the group.
NextHuntGroupPhone
NOT NULLDBSMALLINT
Number of calls dialed from this termination.
OutCalls
PK, FK NOT NULLDBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULLDBINT
The time zone in which the ACD is located. The value is the offset
in minutes from UTC (formerly called GMT).
PeripheralTimeZone
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
201
Chapter 2: All Tables
Galaxy_PBX Table