/mcpRouting_Client, on page 416 (via RoutingClientID) Translation_Route, on page 587 (via TranslationRouteSkillTargetID) Table 448: Indexes for Translation_Route_Half_Hour Table index_keys index_description index_name RecoveryKey nonclustered, unique, unique key located on PRIMARY XAK1Translation_Route_Half_Hour DbDateTime nonclustered located on PRIMARY XIE1Translation_Route_Half_Hour DateTime, RoutingClientID, TranslationRouteSkillTargetID, TimeZone clustered, unique, primary key located on PRIMARY XPKTranslation_Route_Half_Hour Table 449: Fields in Translation_Route_Half_Hour Table Keys and NULL Option Data Type Description Name NULL DBINT Average number of routes in use in the last half hour. AvgRoutesInUseToHalf NULL DBINT Average time (in seconds) to successfully complete a translation route for a routing client. AvgRouteTimeToHalf NULL DBINT The number of times the router finds configuration error during a translation route for a routing client. ConfigErrorsToHalf PK NOT NULL DBSMALLDATE The central controller date and time at the start of the interval. DateTime IE1-Indexed NULL DBDATETIME The current date and time stamp when the records are written to the database. DbDateTime NULL DBINT Maximum number of routes used in a translation routing for a routing client in the half hour interval. MaxRoutesInUseToHalf NULL DBINT Maximum time (in seconds) to successfully complete a translation route for a routing client. MaxRouteTimeToHalf NULL DBINT The number of times PG times out the translation route for a routing client. Not applicable for translation route to VRU. PGTimeOutsToHalf AK1 NOT NULL DBFLT8 Unique record identifier. RecoveryKey NULL DBINT The number of times translation route is completed successfully. RoutedToHalf NULL DBINT The number of times router times out the translation route for a routing client. RouterTimeOutToHalf Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 589 All Tables Translation_Route_Half_Hour