/mcpKeys and NULL Option Data Type Description Fields NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y= Yes • N =No Deleted NULL DBINT Foreign key from Department. NULL for global department. DepartmentID NULL DESCRIPTION Additional information about the dialed number. Description PK NOT NULL DBINT A unique identifier for this dialed number. DialedNumberID AK-2 NOT NULL VNAME32 The string the routing client passes to the system software to represent this dialed number. DialedNumberString AK-1 NOT NULL VNAME32 An enterprise name for the number. This name must be unique among all dialed numbers in the database. EnterpriseName IE-1, FK NULL DBINT References the default label for this dialed number. LabelID FK NOT NULL DBINT The Media Routing Domain associated with this dialed number. MRDomainID Optional (NULL) varchar(512) The Dialed Number (DN) Pattern for routing type Post Call Survey (PCS) or Forking Dialed Number are stored with prefix PCS: and MGF: respectively. This field may contain wildcard characters such as (!), (*), (>), and single digit matches like periods (.) or X. Note This field is not applicable for Unified CCE. PCSPattern NOT NULL DBCHAR Used to indicate if remote routing by a CTI client (ACMI) is permitted on this dialed number. Default = 'N'. PermitApplicationRouting NOT NULL DBCHAR Used for queuing on the Simplified Unified CCE PG only. Stored as 'Y' or 'N'. Default = 'N'. ReservedByIVR Optional (NULL) varchar(256) The custom ringtone media file name. Note This field is not applicable for Unified CCE. RingtoneName Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 216 All Tables Dialed_Number