Cisco Cisco Administrative Workstation Technical References
2-411
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Termination_Call_Detail Table
RouterCallKeyDay
The day that the call was taken and the
Termination_Call_Detail record was created. This
field contains a value only for calls that were
translation-routed or post-routed to or from an
ACD.
Termination_Call_Detail record was created. This
field contains a value only for calls that were
translation-routed or post-routed to or from an
ACD.
Together with RouterCallKey, the Day value
forms a unique 64-bit key for the call. The PG
might not have this information for all calls, but if
it does, it allows you to track all states of a call
between the Route_Call_Detail and the
Termination_Call_Detail tables by using the
cradle-to-grave call tracking facility. (For calls
that span a day, the day may not correspond to the
day specified in the DateTime field.)
forms a unique 64-bit key for the call. The PG
might not have this information for all calls, but if
it does, it allows you to track all states of a call
between the Route_Call_Detail and the
Termination_Call_Detail tables by using the
cradle-to-grave call tracking facility. (For calls
that span a day, the day may not correspond to the
day specified in the DateTime field.)
Note
This field contains a value only if the call
was translation-routed, post-routed
to/from an ACD, or sent to an IPCC
Enterprise agent.
was translation-routed, post-routed
to/from an ACD, or sent to an IPCC
Enterprise agent.
DBINT
NULL
RouterCallKeySequenceNumber
A sequence number used for ordering rows for
cradle-to-grave call tracking. This number defines
the order in which the calls were created. This is
not the order in which the
Termination_Call_Detail records were created.
(This field also exists in the Route_Call_Detail
table, where it defines the order in which the route
requests were created.)
cradle-to-grave call tracking. This number defines
the order in which the calls were created. This is
not the order in which the
Termination_Call_Detail records were created.
(This field also exists in the Route_Call_Detail
table, where it defines the order in which the route
requests were created.)
DBINT
NULL
ServiceSkillTargetID
Identifies which service handled the call. This
value (for example, 5004) is unique among all
skill targets in the enterprise. It is taken from the
Service table in the ICM central database.
ServiceSkillTargetIDs are generated
automatically when a service is configured in the
Service Configuration window of ICM
Configuration Manager. If the call is
value (for example, 5004) is unique among all
skill targets in the enterprise. It is taken from the
Service table in the ICM central database.
ServiceSkillTargetIDs are generated
automatically when a service is configured in the
Service Configuration window of ICM
Configuration Manager. If the call is
by a
non-configured service, this field is set to null. In
addition, if the call is not associated with a service,
the field is set to null (for example, in the case of
non-ACD calls).
addition, if the call is not associated with a service,
the field is set to null (for example, in the case of
non-ACD calls).
DBINT
FK
NULL
Table 2-368 Termination_Call_Detail Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option