Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 548
   
2-176
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Galaxy_Trunk_Call_Count Table
Galaxy_Trunk_Call_Count Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides call counts for a trunk configured 
on a Galaxy ACD.
Table 2-171 Galaxy_Trunk_Call_Count Table Constraints
Constraint
Field Name(s)
PK
DateTime
PeripheralID
PortID
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
Table 2-172 Galaxy_Trunk_Call_Count Table
Field Name
Description
Data Type
Keys and 
Null Option
CallCount
Number of calls counted on the trunk.
DBSMALLINT
NOT NULL
DateTime
The Central Controller date and time at the 
beginning of the reporting interval.
DBDATETIME
PK
NOT NULL
PeripheralID
The ICM software identifier for the ACD.
DBSMALLINT
PK, FK
NOT NULL
PeripheralTimeZone
The time zone in which the ACD is located. The 
value is the offset in minutes from GMT.
DBINT
NOT NULL
PortID
Galaxy port assignment for the trunk.
DBSMALLINT
PK
NOT NULL
RecoveryKey
A unique ID assigned to each record and used 
internally by the ICM/IPCC Enterprise software to 
track the record.
DBFLT8
AK-1
NOT NULL
TerminationType
Valid options include:
8 = Direct Inward Dial (DID)
14 = Inter-tandem
26 = Off-Network Access Line
41 = Tie Line
47 = Operator Service
50 = Operator Service Feature Group D
51 = Australian Off-Network Access Line
52 = Australian Tie Line
53 = Australian Direct Gate Dial
54 = DNIS
64 = Directory Assistance Intercept
65 = ISDN
DBSMALLINT
NOT NULL