McDewey

Keys and NULL Option Data Type Description Name NULL DESCRIPTION Description of what the query rule contains or how it is being used. Description NULL DBINT A unique identifier that identifies a department in CCDM/CCMP deployment. DepartmentID NOT NULL DBCHAR Setting of query rule within this campaign: • Y = The query rule is enabled. • N = the query rule is not enabled. Enabled NULL DBINT Reserved for future use FutureUseInt1 NULL DBINT Reserved for future use FutureUseInt2 NULL DBINT Reserved for future use FutureUseInt3 NULL DBINT Reserved for future use FutureUseInt4 NULL DBINT Reserved for future use FutureUseInt5 NULL varchar(64) Reserved for future use FutureUseVarchar1 NULL varchar(64) Reserved for future use FutureUseVarchar2 NULL varchar(64) Reserved for future use FutureUseVarchar3 FK NOT NULL DBINT Identifies (indirectly) the contact list to which this query rule refers. Foreign key from the Import Rule table. ImportRuleID PK NOT NULL DBINT A unique identifier for this Query rule. QueryRuleID AK-1 NOT NULL VNAME32 The customer-entered name for this query rule. QueryRuleName Query_Rule_Clause This table is in the Blended Agent category (see Blended Agent (Outbound Option), on page 616). To see database rules for these tables, see Blended Agent Tables (Outbound Option), on page 695. If Outbound Option was not selected during setup, this table will contain no data. Note Contains the SQL rules associated with each query rule. There is a single row for each configured query rule. Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 364 All Tables Query_Rule_Clause