Cisco Cisco IP Contact Center Release 4.6.1 技术参考
2-102
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Galaxy_PBX Table
Galaxy_PBX Table
Central database only.
This table applies to Rockwell Galaxy ACDs only.
Each row provides information about a PBX termination configured on a Galaxy ACD.
Table 2-82 Galaxy_PBX Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The date and time at the end of the reporting interval.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT
NULL
NULL
PortID
Galaxy identifier for the phone’s port.
smallint
PK, NOT NULL
TimeZone
The time zone for the date and time. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
PK, NOT NULL
PeripheralTimeZone
The time zone in which the ACD is located. The value
is the offset in minutes from GMT.
is the offset in minutes from GMT.
int
NOT NULL
TerminationType
42 = Tone PBX
smallint
NOT NULL
SubscriberNumber
In a multiple subscriber system, indicates which
subscriber has control of the termination.
subscriber has control of the termination.
smallint
NOT NULL
DepartmentNumber
Identifier for the customer-defined group of PBX
extensions.
extensions.
smallint
NOT NULL
HuntGroupInformation
Valid options include:
0 = Phone not in hunt group
1 = First phone in hunt group
2 = Intermediate phone in hunt group
4 = Last phone in hunt group
8 = Common last phone in hunt group
128 = Phone’s position in hunt group has
changed.
1 = First phone in hunt group
2 = Intermediate phone in hunt group
4 = Last phone in hunt group
8 = Common last phone in hunt group
128 = Phone’s position in hunt group has
changed.
smallint
NOT NULL
ExtensionNumber
Termination phone number.
smallint
NOT NULL
NextHuntGroupPhone
If in the termination is in a hunt group, the phone
number of the next extension in the group.
number of the next extension in the group.
smallint
NOT NULL
InCalls
Number of calls answered by this termination.
smallint
NOT NULL
OutCalls
Number of calls dialed from this termination.
smallint
NOT NULL
SecondCalls
Number of calls made while a previous call is on hold.
Dialing an expanded PBX option feature also counts as
a second call.
Dialing an expanded PBX option feature also counts as
a second call.
smallint
NOT NULL
ForwardedCalls
Number of calls automatically forwarded from this
destination because the termination is busy and is in a
hunt group, or because either the All Calls or No
Answer options of Call Forwarding were in use.
destination because the termination is busy and is in a
hunt group, or because either the All Calls or No
Answer options of Call Forwarding were in use.
smallint
NOT NULL
PickedUpCalls
Number of calls that rang at this termination but were
intercepted by another phone.
intercepted by another phone.
smallint
NOT NULL