Technical References

Query_Rule (page 266) (via ImportRuleID)
Import_Rule_Clause (page 221) (via ImportRuleID)
Import_Rule_History (page 223) (via ImportRuleID)
Import_Rule_Real_Time (page 224) (via ImportRuleID)
Table 112: Indexes for Import_Rule Table
index_keysindex_descriptionindex_name
ImportRuleNamenonclustered, unique, unique key
located on PRIMARY
XAK1Import_Rule
ImportRuleIDclustered, unique, primary key
located on PRIMARY
XPKImport_Rule
Fields in Import_Rule Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULLvarchar(64)
The name of the contact table into which this file is to be imported.
ContactTableName
NULLDBINT
The day of the month to run this import. Only used when
MonthlyEnabled is set to Y.
DayOfMonth
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NOT NULLDBCHAR
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.
NULLvarchar(255)
The directory where the file to be imported is stored. UNC naming
convention.
FilePath
NOT NULLDBCHAR
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)
218
Chapter 2: All Tables
Import_Rule Table