/mcpKeys and NULL Option Data Type Description Name NULL VARCHAR(32) The Trunk Group ID on which the call arrived on the IOS Gateway. PstnTrunkGroupID NULL DBINT The Trunk Group Channel Number on which the call arrived on the IOS Gateway. PstnTrunkGroupChannelNumber NOT NULL DBINT Currently not used, set to zero (0). RecoveryDay AK-1 NOT NULL DBFLT8 A unique ID assigned to each record and used internally by the Unified CCE software to track the record. Note Unlike the default, this primary key is nonclustered. RecoveryKey NULL DBINT The number of seconds that the call spent ringing at the agent's teleset before it was answered. Ring time occurs after any DelayTime and LocalQTime. For diverted calls (that is, calls that rang at an agent's teleset before being redirected on failure to answer), RingTime is the sum of the time that the call spent ringing at each teleset. RingTime is added to Skill Group Half Hour and Agent Skill Group half-hour tables when the call completes. RingTime is also used to compute the following Route and Service half-hour values: • DelayQAbandTimeToHalf • LongestCallDelayQTimeToHalf • LongestCallAbandTimeToHalf RingTime FK NULL DBINT Identifies the route where the call was sent. The value (for example, 6), is unique among all routes in the enterprise. It is taken from the Route table in the Unified ICM central database. Route IDs are generated automatically when a route is configured in the Route Configuration window of Unified ICM Configuration Manager. RouteID Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 580 All Tables Termination_Call_Detail