Cisco Cisco IP Contact Center Release 4.6.1 Technische Referenzen
2-191
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Import_Rule Table
ImportRuleID
A unique identifier for this import rule.
DBINT
PK
NOT NULL
ImportRuleName
The customer-entered name for this import rule.
VNAME32
AK-1
NOT NULL
ImportType
Indicates if this is a Contact Import or a
Do-Not-Call import:
Do-Not-Call import:
1 = The import type is Contact Import.
2 = The import type is Do-Not-Call.
2 = The import type is Do-Not-Call.
DBINT
NOT NULL
MondayEnabled
Flag that indicates if this import should be
performed every Monday:
performed every Monday:
Y = Perform import every Monday.
N = Do not perform import every Monday.
N = Do not perform import every Monday.
DBCHAR
NOT NULL
MonthlyEnabled
If enabled, this import schedule will run based on
the day of the month instead of the current week
day:
the day of the month instead of the current week
day:
Y = Import will occur one day per month.
N = Import will occur on a daily/weekly basis.
N = Import will occur on a daily/weekly basis.
DBCHAR
NOT NULL
OverwriteEnabled
Indicates whether a contact table that already
exists should be overwritten:
exists should be overwritten:
Y = Yes, overwrite
N = No, append to.
N = No, append to.
DBCHAR
NOT NULL
RenameEnabled
Valid options include:
Y = The import file must be renamed after it is
imported; otherwise, it will be deleted.
N = The import file need not be renamed.
imported; otherwise, it will be deleted.
N = The import file need not be renamed.
DBCHAR
NOT NULL
RenameMaxVersions
The number of import tile versions that are
maintained. After an import file is imported, its
name can be appended with a .001 through .nnn.
maintained. After an import file is imported, its
name can be appended with a .001 through .nnn.
DBSMALLINT
NOT NULL
SaturdayEnabled
Flag that indicates if this import should be
performed every Saturday:
performed every Saturday:
Y = Perform import every Saturday.
N = Do not perform import every Saturday.
N = Do not perform import every Saturday.
DBCHAR
NOT NULL
ScheduleStartHours
The hour at which the import should start. Hours
are in 24-hour format and are based on ICM
Central Controller time.
are in 24-hour format and are based on ICM
Central Controller time.
DBINT
NOT NULL
ScheduleStartMinutes
The minute at which the import should start, based
on ICM Central Controller time.
on ICM Central Controller time.
DBINT
NOT NULL
SPPostImportEnabled
Valid options include:
Y = A stored procedure is executed after the build
process has been completed.
N = A stored procedure is not executed.
process has been completed.
N = A stored procedure is not executed.
DBCHAR
NOT NULL
Table 2-192 Import_Rule Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option