McDewey

Routing_Pattern This table helps Unified CVP to maintain the routing pattern and decide the destination of the calls This table is not applicable for Unified CCE. Note Related Tables • Machine Host (through MachineHostID) Table 346: Indexes for Routing_Pattern Table index_keys index_description index_name PatternID Primary key XPKRouting_Pattern Pattern Unique key XAK1Routing_Pattern Table 347: Fields in Routing_Pattern Table Keys and NULL Option Data Type Description Name PK NOT NULL DBINT A primary key that identifies the pattern. PatternID AK NOT NULL varchar(24) The pattern for routing the call. Pattern FK NULL DBINT The MachineHostID for the site name the pattern is associated to. In case of main site, the value is NULL. MachineHostID NULL DESCRIPTION The description of the pattern. Description NOT NULL DBINT The type of the pattern. Valid routing pattern types and their values are as follows: • VRU = 1 • Agent = 2 • External = 3 PatternType NOT NULL varchar(255) The destination where the pattern will route the call to. The destination is either SIP server group or Fully Qualified Domain Name (FQDN). Destination Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 427 All Tables Routing_Pattern