Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-116
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Import_Rule Table
Related tables:
Schedule (via ScheduleID)
Import_Rule Table
Contains a list of all the import rules and their associated import lists.
Use the Blended Agent Configuration option within ICM Configuration Manager to modify Import_Rule
records.
records.
Message
Indicates ‘Success’ or describes an error.
varchar(255)
NOT NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL
Table 2-94 Import_Log Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-95 Import_Rule Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ImportRuleID
A unique identifier for this import rule.
int
PK, NOT NULL
ImportRuleName
The customer-entered name for this import rule.
varchar(32)
AK1, NOT
NULL
NULL
Enabled
A flag that indicates whether this import should be run at
the scheduled time:
the scheduled time:
Y = Run at scheduled time.
N = Do not run at scheduled time.
N = Do not run at scheduled time.
char(1)
NOT NULL
ImportType
Indicates if this is a Contact Import or a Do-Not-Call
import:
import:
1 = The import type is Contact Import.
2 = The import type is Do-Not-Call.
2 = The import type is Do-Not-Call.
int
NOT NULL
FilePath
The directory where the file to be imported is stored. UNC
naming convention.
naming convention.
varchar(255)
NULL
ContactTableName
The name of the contact table into which this file is to be
imported.
imported.
varchar(64)
NOT NULL
FixedFormatEnabled
Indicates whether file is fixed format:
Y = Yes, fixed format
N = Not fixed format (comma-delimited).
N = Not fixed format (comma-delimited).
char(1)
NOT NULL
OverwriteEnabled
Indicates whether a contact table that already exists
should be overwritten:
should be overwritten:
Y = Yes, overwrite
N = No, append to.
N = No, append to.
char(1)
NOT NULL