Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
FK NULLDBINT
The identifier of the peripheral target to which the call was delivered.
NetworkTargetID
NULLDBINT
The number of seconds between the PG receiving a “pre-call message
from the CallRouter for the task and an Offer Task (or Start Task, if an
Offer Task is not sent) message for the task.
NetworkTime
NULLDBCHAR
Call has been re-classified via transfer, overflow, or new transaction.
Indicates that there is at least one more row in Termination Call Detail
for this call.
NewTransaction
NULLDBINT
An identifier assigned to the call by the peripheral (ACD, IVR). The
range and type of value used in this field varies depending on the type
PeripheralCallKey
of peripheral. Some ACDs might view an original call, a transfer, and
a consultative call as three separate calls (e.g., Call IDs 1001, 1002,
1003); other ACDs might view all three calls as a continuation of the
same call (e.g., Call IDs 1001, 1001, 1001); others might view the
original and transfer as the same call, but the consultative call as a
second call (e.g., Call IDs 1001, 1002, 1001); and still other ACDs
might view the original call as one call and the original and transfer as
another call (e.g., Call IDs 1001, 1002, 1002).
In addition, the values used may not be unique, depending on the
peripheral’s implementation. For example, the Aspect CallCenter and
the DEFINITY ECS ACDs reuse identifiers in this field.
NULLDBSMALLINT
Type of call reported by the peripheral. To see valid settings for this
field, click here (page 499).
PeripheralCallType
FK, AK-2
NOT NULL
DBSMALLINT
Identifies which peripheral handled the call. This value (for example,
5002), is unique among all peripherals in the enterprise. It is taken from
PeripheralID
the Peripheral table in the ICM central database. Peripheral IDs are
generated automatically when a peripheral is configured in the Peripheral
Configuration window of ICM Configuration Manager.
NULLDBSMALLINT
Used by the DEFINITY ECS to indicate the priority of the call.
Priority
NOT NULLDBINT
Currently not used, set to zero (0).
RecoveryDay
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
NULLDBINT
The number of seconds that the call spent ringing at the agent’s teleset
before it was answered. Ring time occurs after any DelayTime and
RingTime
LocalQTime. For diverted calls (that is, calls that rang at an agent's
teleset before being redirected on failure to answer), RingTime is the
sum of the time that the call spent ringing at each teleset.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
413
Chapter 2: All Tables
Termination_Call_Detail Table