Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Link to the ICRCallKey field of a parent call (used for transfers and
conference calls).
ICRCallKeyParent
NULLDBINT
Instrument number or extension number of the device that handled the
call at the peripheral.
InstrumentPortNumber
This field is also populated for outbound calls.
NULLDBINT
ICM 5.x: Measures the cumulative time, in seconds, that the call spent
queued at the local ACD and the time the call spent queued in the
network VRU.
LocalQTime
ICM 6.x and 7.x: Measures only the cumulative time, in seconds, that
the call spent queued at the local ACD. NetQTime (see below) measures
the time the call spends queued in the network VRU.
Both: During its duration, a call can be queued to multiple answering
resources (for example, a trunk, voice port, skill group, etc.).
LocalQTime includes time the call spent queued to any of these
resources.
LocalQTime does not include any DelayTime (before the call is queued),
or RingTime (after the call leaves the queue). LocalQTime is a
completed call time, not an agent state time.
LocalQTime is used in the calculation of Duration in
Termination_Call_Detail, and to calculate the following Service and
Route values:
• LongestCallDelayQTime
• LongestCallAbandTime
• DelayQAbandTime
• DelayQTime
• AnswerWaitTime
LocalQTime is also used to calculate the AnswerWaitTime in the Skill
Group and Agent Skill Group tables.
FK NULLDBINT
An identifier for the Media Routing Domain in the ICM system
configuration.
MRDomainID
NULLDBINT
Represents the time the call spent on Network Queue in the CallRouter.
The LocalQTime field is used for local ACD queuing.
NetQTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
412
Chapter 2: All Tables
Termination_Call_Detail Table