Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-193
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Import_Rule_Clause Table
Import_Rule_Clause Table
Defines the portions of an import list to be imported by the Outbound Option Import Rule process.
Use the Outbound Option Configuration option within ICM Configuration Manager to modify
Import_Rule_Clause records.
Import_Rule_Clause records.
Related tables:
(via ImportRuleID)
Table 2-193 Import_Rule_Clause Table Constraints
Constraint
Field Name(s)
PK
ImportRuleID
SequenceNumber
SequenceNumber
FK
ImportRuleID
Table 2-194 Import_Rule_Clause Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
DecimalPlaces
Indicates how many positions after the decimal
point.
point.
DBINT
NOT NULL
FieldName
The name of the column within the contact table
into which the corresponding field within the
import file will be inserted.
into which the corresponding field within the
import file will be inserted.
varchar(64)
NOT NULL
ImportRuleID
The import rule to which this clause belongs.
DBINT
PK, FK
NOT NULL
IndexColumnEnabled
Valid options include:
Y = Index will be created on this column.
N = Index will not be created on this column.
N = Index will not be created on this column.
DBCHAR
NOT NULL
Length
The length of the column.
DBINT
NOT NULL
NullEnabled
Valid options include:
Y = Column allows a NULL entry.
N = Column does not allow NULL values.
N = Column does not allow NULL values.
DBCHAR
NOT NULL
SequenceNumber
The index for clauses within a given import rule.
DBINT
PK
NOT NULL
StandardColumnType
The name of a Outbound Option standard column
to which this field will default.
to which this field will default.
DBINT
NULL
Type
The data type of the column.
DBINT
NOT NULL