Cisco Cisco IP Contact Center Release 4.6.2 Technical References

2-190

Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)

Chapter 2 Table Details

Import_Rule Table

Contains a list of all the import rules and their associated import lists.

Use the Outbound OptionConfiguration option within ICM Configuration Manager to modify
Import_Rule records.

Table 2-191 Import_Rule Table Constraints

Constraint

Field Name(s)

ImportRuleID

AK-1

ImportRuleName

Table 2-192 Import_Rule Table

Field Name

Description

Data Type

Keys and
Null Option

ChangeStamp

Incremented when the record is changed in the
central database.

CHANGESTAMP

NOT NULL

ContactTableName

The name of the contact table into which this file
is to be imported.

varchar(64)

NOT NULL

DayOfMonth

The day of the month to run this import. Only used
when MonthlyEnabled is set to Y.

DBINT

NULL

Deleted

Deleted Flag. Stored as a character:

Y = Yes
N = No

DBCHAR

NOT NULL

Enabled

A flag that indicates whether this import should be
run at the scheduled time:

Y = Run at scheduled time.
N = Do not run at scheduled time.

DBCHAR

NOT NULL

FilePath

The directory where the file to be imported is
stored. UNC naming convention.

varchar(255)

NULL

FilePollingEnabled

Valid options include:

Y = Import files are imported as soon as they are
created. After the import is complete, the import
file is renamed or deleted.
N = Import files are not imported as soon as they
are created.

DBCHAR

NOT NULL

FixedFormatEnabled

Indicates whether file is fixed format:

Y = Yes, fixed format
N = Not fixed format (comma-delimited).

DBCHAR

NOT NULL

FridayEnabled

Flag that indicates if this import should be
performed every Friday:

Y = Perform import every Friday.
N = Do not perform import every Friday.

DBCHAR

NOT NULL