/mcpKeys and NULL Option Data Type Description Name NULL VARCHAR(40) Data entered by the agent during call wrap- up. WorkTime is used to calculate Duration in the Termination_Call_Detail table and HandleTime in the Unified ICM Service, Route, and Call_Type tables. WrapupData NULL DBDATETIME (THIS FIELD IS NOT CURRENTLY BEING USED. IT IS RESERVED FOR FUTURE USE.) The UTC timestamp at which the agent cleared the call and moved to after call work. WrapUpStartDateTimeUTC Termination_Call_Variable This table is one of the tables in the Route category (see Route, on page 625). For more information about database rules of these tables, see Route Tables, on page 700. It gets populated on the central database. When Detailed Data Server (DDS) role is enabled on Administration and Data Server, this table gets populated on HDS database also. Each row in this table records the value of an expanded call variable for a call that is handled at a peripheral. If the expanded call variable is an array, one Termination_Call_Variable row is generated for each element of the array. Therefore, the system software generates a Termination_Call_Variable record for every expanded call variable of a call that is handled at a peripheral. Because this table grows larger in size, running custom reporting queries against it while it is on the HDS can degrade performance. To optimize performance, extract the data from the HDS into your own custom database. The custom database must be on a separate server and ensure that other Unified ICM or Unified CC Enterprise components do not use it. Use only DBDateTime (date and time of the record that was written to the HDS database) to perform the extraction. You can index the table on the custom database according to the custom reporting needs. Related Tables Expanded_Call_Variable, on page 259 (via ExpandedCallVariableID) Termination_Call_Detail, on page 566(TCDRecoveryKey maps to Termination_Call_Detail.RecoveryKey) Table 442: Indexes for Termination_Call_Variable Table index_keys index_description index_name TCDRecoveryKey, ExpandedCallVariableID, ArrayIndex Clustered, unique, unique key located on PRIMARY XAK1Termination_Call_Variable DateTime Nonclustered located on PRIMARY XIE1Termination_Call_Variable DbDateTime Nonclustered located on PRIMARY XIE2Termination_Call_Variable Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 585 All Tables Termination_Call_Variable