/mcpKeys and NULL Option Data Type Description Name NULL VARCHAR(40) User-defined call variable. Variable5 NULL VARCHAR(40) User-defined call variable. Variable6 NULL VARCHAR(40) User-defined call variable. Variable7 NULL VARCHAR(40) User-defined call variable. Variable8 NULL VARCHAR(40) User-defined call variable. Variable9 NULL VARCHAR(40) User-defined call variable. Variable10 NULL DBINT The VRUProgress call variable value. VruProgress NULL DBINT Number of VRU Script nodes encountered by the call. VruScripts Route_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 records the value of an expanded call variable for a call routed by the system software. If the expanded call variable is an array, one Route_Call_Variable row is generated for each element of the array. Therefore, the system software generates a Route_Call_Variable record for each enabled persistent expanded call variable for every routing request it processes. 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 data from the HDS into your 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 when 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) Route_Call_Detail, on page 380 (RCDRecoveryKey maps to Route_Call_Detail.RecoveryKey) Table 332: Indexes for Route_Call_Variable Table index_keys index_description index_name RCDRecoveryKey, ExpandedCallVariableID, ArrayIndex Clustered, unique, unique key located on PRIMARY XAK1Route_Call_Variable Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 391 All Tables Route_Call_Variable