McDewey

Multi-vendor documentation library · semantic search · MCP endpoint at /mcp

Page 596

↗ View in doc context
page
596
source
ucce/v15.0.1/db-schema-handbook/db-schema-handbook.md
chunk_id
ucce::v15.0.1::db-schema-handbook::db-schema-handbook::582

Keys and NULL Option Data Type Description Name FK NULL DBINT The identifier of the peripheral target to which the call was delivered. NetworkTargetID NULL DBINT 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 NULL DBINT Represents the time that the call is queued for the skill group identified by the RoutedSkillGroupSkillTargetID field in the network VRU. It is the time when the call is queued to the specific skill group until the call is routed by the router. The router resets the time when the call is requeried. NetworkSkillGroupQTime NULL DBCHAR 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 NULL char(1) Indicates which Unified CCE component initiates the call. 'D' - originated from Dialer. Originated NULL DBINT An identifier assigned to the call by the peripheral (ACD, IVR). The range and type of value used in this field vary depending on the type of peripheral. For example: • ACD 1 views an original call, a transfer, and a consultative call as three separate calls (Call IDs 1001, 1002, 1003 respectively) • ACD 2 views all three calls as a continuation of the same call (Call IDs 1001, 1001, 1001 respectively). • ACD 3 views the original and transfer as the same call, but the consultative call as a second call (Call IDs 1001,1002, 1001 respectively). • ACD 4 views the original call as one call and the original and transfer as another call (Call IDs 1001, 1002, 1002 respectively). In addition, the identifier used may not be unique depending on the peripheral's implementation. PeripheralCallKey Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 578 All Tables Termination_Call_Detail