Cisco Cisco IPCC Web Option Riferimenti tecnici

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.

Import_Rule (via ImportRuleID)

Central database only.

Contains the history of every Blended Agent import and shows how many records succeeded and failed.

ImportRuleID

The import rule to which this clause belongs.

int

PK, FK, NOT 
NULL

SequenceNumber

The index for clauses within a given import rule.

int

PK, NOT NULL

FieldName

The name of the column within the contact table into 
which the corresponding field within the import file will 
be inserted.

varchar(64)

NOT NULL

Type

The data type of the column.

int

NOT NULL

Length

The length of the column.

int

NOT NULL

DecimalPlaces

Indicates how many positions after the decimal point.

int

NOT NULL

NullEnabled

Valid options include:

Y = Column allows a NULL entry.
N = Column does not allow NULL values.

char(1)

NOT NULL

IndexColumnEnabled

Valid options include:

Y = Index will be created on this column. 
N = Index will not be created on this column.

char(1)

NOT NULL

StandardColumnType

The name of a Blended Agent standard column to which 
this field will default.

varchar(64)

NULL

ImportRuleID

The current active import.

int

PK, NOT NULL

DateTimeStart

The date and time when the import was started.

datetime

PK, NOT NULL