/mcpKeys and NULL Option Data Type Description Name NULL DBINT The identifier for the agent that initiated the call. This value is set only if the agent associated with SourceAgentPeripheralNumber is configured in the system software. SourceAgentSkillTargetID NULL DBDATETIME The date/time in UTC that the call was first seen at the Peripheral Gateway (PG), e.g. ingress call arrival, agent initiated call, new call resulting from a call transfer. StartDateTimeUTC NULL DBINT The cumulative time, in seconds, that the call was in a talking state on the destination device. TalkTime is a completed call time, not an agent state time. TalkTime is used in the calculation of Duration in the Termination_Call_Detail record. It is also used to calculate TalkTime in the Services and Route tables. Note In the Termination_Call_Detail, Skill_Group, and Agent_Skill_Group tables, TalkTime does not include HoldTime; however, in the Services and Route tables, TalkTime does include HoldTime. TalkTime NULL DBINT The elapsed time in seconds before the call was abandoned. This can include DelayTime, LocalQTime, and RingTime, depending on when the call was abandoned. This value is set only when the call is not answered by an agent or trunk resource. TimeToAband NULL DBINT The Central Controller’s time zone for the date and time. The value is the offset in minutes from UTC (formerly GMT).The value is negative for time zones to the east of UTC and positive for time zones to the west of UTC. TimeZone NULL DBDATETIME The UTC timestamp at which the agent completes the transfer. TransferredDateTimeUTC NULL DBINT The number (as known to the peripheral) of the trunk on which the call arrived. Trunk FK NULL DBINT The identifier of the trunk group on which the call arrived at the peripheral. TrunkGroupID Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 583 All Tables Termination_Call_Detail