Cisco Cisco IP Contact Center Release 4.6.1 Referências técnicas

Página de 557
Import_Rule_Clause Table
This table is in the 
. To see database rules for these tables,
click 
Defines the portions of an import list to be imported by the Blended 
Agent Import Rule process.
Use the Blended Agent Configuration option within ICM Configuration Manager to modify
Import_Rule_Clause records.
Note: 
If Outbound Option was not selected during setup, this table will contain no data.
Related table
Table 112: Indexes for Import_Rule_Clause Table
index_keys
index_description
index_name
ImportRuleID, SequenceNumber
clustered, unique, primary key
located on PRIMARY
XPKImport_Rule_Clause
Fields in Import_Rule_Clause Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
Indicates how many positions after the decimal point.
DecimalPlaces
NOT NULL
varchar(64)
The name of the column within the contact table into
which the corresponding 
field within the import file
will be inserted.
FieldName
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
PK, FK NOT
NULLNULL
DBINT
The import rule to which this clause belongs.
ImportRuleID
NOT NULL
DBCHAR
Valid options include:
IndexColumnEnabled
• Y = Index will be created on this column.
• N = Index will not be created on this column.
NOT NULL
DBINT
The length of the column.
Length
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
183
Chapter 2:  All Tables
Import_Rule_Clause Table