Technical References

Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
Number of calls that rang at this termination but were intercepted
by another phone.
PickedUpCalls
PK NOT NULLDBSMALLINT
Galaxy identifier for the phone’s port.
PortID
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NOT NULLDBINT
Total number of seconds that second calls were on the phone.
SecondCallDuration
NOT NULLDBSMALLINT
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 NULLDBSMALLINT
In a multiple subscriber system, indicates which subscriber has
control of the termination.
SubscriberNumber
NOT NULLDBSMALLINT
42 = Tone PBX
TerminationType
PK NOT NULLDBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
NOT NULLDBSMALLINT
Number of toll calls placed from the extension.
TollCalls
Galaxy_Single_Trunk Table
This table is in the Galaxy category (page 445). For database rules, click here (page 506).
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
Peripheral (page 250) (via PeripheralID)
Trunk (page 419) (via TrunkID)
Table 101: Indexes for Galaxy_Single_Trunk Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_Single_Trunk
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
202
Chapter 2: All Tables
Galaxy_Single_Trunk Table