Cisco Cisco Administrative Workstation Technical References

Page of 548
   
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.
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.)
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.
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.)
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 
 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).
DBINT
FK
NULL
Table 2-368 Termination_Call_Detail Table (continued)
Field Name
Description
Data Type
Keys and 
Null Option