/mcpKeys and NULL Option Data Type Description Name FK NOT NULL DBSMALLINT Foreign key from the Routing Client table. This is a unique identifier for this routing client. The routing client ID is generated automatically when the routing client is configured in the Routing Client Configuration window of Unified ICM Configuration Manager. RoutingClientID FK NULL DBINT Foreign key from Script table. Indicates the script used to route the call. This unique identifier is generated automatically by the system software. ScriptID NULL VNAME32 The label associated with the ultimate target at the switch. For a translation routed call, this is the label of the final destination, not of the translation route itself. If the label for the call is configured, this will be the same as the Label field of the label specified by TargetLabelID. If the label for the call is not configured, this is the final label for the call and TargetLabelID will be NULL. TargetLabel NULL DBINT The label associated with the ultimate target at the switch. For a translation routed call, this is the label of the final destination, not of the translation route itself. TargetLabelID NULL DBINT A numeric value representing the result of the routing script. To see the list of values, see Route Call Detail Fields, on page 664. TargetType 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 CHAR(4) This field is reserved. Unused NULL VARCHAR(131) ISDN private network User to User information. For tasks related to the Webex Connect integration with CCE, this field displays the client task ID. UserToUser NULL VARCHAR(40) User-defined call variable. Variable1 NULL VARCHAR(40) User-defined call variable. Variable2 NULL VARCHAR(40) User-defined call variable. Variable3 NULL VARCHAR(40) User-defined call variable. Variable4 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 390 All Tables Route_Call_Detail