Cisco Cisco IP Contact Center Release 4.6.2 Technical References

ImportRuleName

nonclustered, unique, unique key
located on PRIMARY

XAK1Import_Rule

ImportRuleID

clustered, unique, primary key
located on PRIMARY

XPKImport_Rule

NOT NULL

CHANGESTAMP

Incremented when the record is changed in the central database.

ChangeStamp

NOT NULL

varchar(64)

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

ContactTableName

NULL

DBINT

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

DayOfMonth

NOT NULL

DBCHAR

Deleted Flag. Stored as a character:

Deleted

• Y = Yes

• N = No

NOT NULL

DBCHAR

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

Enabled

• Y = Run at scheduled time.

• N = Do not run at scheduled time.

NULL

varchar(255)

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

FilePath

NOT NULL

DBCHAR

Valid options include:

FilePollingEnabled

• 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.

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)