/mcpTable 446: Indexes for Translation_Route Table index_keys index_description index_name EnterpriseName nonclustered, unique, unique key located on PRIMARY XAK1Translation_Route LogicalControllerID nonclustered located on PRIMARY XIE1Translation_Route SkillTargetID clustered, unique, primary key located on PRIMARY XPKTranslation_Route Table 447: Fields in Translation_Route Table Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NULL DESCRIPTION Additional information about the translation route. Description AK-1 NOT NULL VNAME32 An enterprise name for the translation route. This name must be unique among all translation routes in the enterprise. EnterpriseName FK, IE-1 NOT NULL DBSMALLINT The Logical Interface Controller associated with the translation route. LogicalControllerID PK, FK NOT NULL DBINT An identifier that is unique among all skill targets in the enterprise. SkillTargetID NOT NULL DBINT The type of translation route: • 1 = DNIS • 2 = CDPD Type Translation_Route_Half_Hour This table is in the Skill Target category (see Skill Target, on page 635). To see database rules for these tables, see Skill Target Tables, on page 702. Provides statistics for each translation route. These statistics are updated every 30 minutes. Related Tables Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 588 All Tables Translation_Route_Half_Hour