Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
• Y = Import will occur one day per month.
• N = Import will occur on a daily/weekly basis.
NOT NULLDBCHAR
Indicates whether a contact table that already exists should be
overwritten:
OverwriteEnabled
• Y = Yes, overwrite
• N = = No, append to.
NOT NULLDBCHAR
Valid options include:
RenameEnabled
• Y = The import file must be renamed after it is imported; otherwise,
it will be deleted.
• N = The import file need not be renamed.
NOT NULLDBSMALLINT
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.
RenameMaxVersions
NOT NULLDBCHAR
Flag that indicates if this import should be performed every Saturday:
SaturdayEnabled
• Y = Perform import every Saturday.
• N = Do not perform import every Saturday.
NOT NULLDBINT
The hour at which the import should start. Hours are in 24-hour format
and are based on ICM Central Controller time.
ScheduleStartHours
NOT NULLDBINT
The minute at which the import should start, based on ICM Central
Controller time.
ScheduleStartMinutes
NOT NULLDBCHAR
Valid options include:
SPPostImportEnabled
• Y = A stored procedure is executed after the build process has been
completed.
• N = A stored procedure is not executed.
NOT NULLDBCHAR
Valid options include:
SPPreImportEnabled
• Y = A stored procedure is executed prior to reading the import file
but after the customer table has been created.
• N = A stored procedure is not executed.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
220
Chapter 2: All Tables
Import_Rule Table