Technical References

Fields in Import_Rule_Clause Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBINT
Indicates how many positions after the decimal point.
DecimalPlaces
NOT NULLvarchar(64)
The name of the column within the contact table into which the
corresponding field within the import file will be inserted.
FieldName
NULLDBINT
Reserved for future use
FutureUseInt1
NULLDBINT
Reserved for future use
FutureUseInt2
NULLDBINT
Reserved for future use
FutureUseInt3
NULLDBINT
Reserved for future use
FutureUseInt4
NULLDBINT
Reserved for future use
FutureUseInt5
NULLvarchar(64)
Reserved for future use
FutureUseVarchar1
NULLvarchar(64)
Reserved for future use
FutureUseVarchar2
NULLvarchar(64)
Reserved for future use
FutureUseVarchar3
PK, FK NOT NULLNULLDBINT
The import rule to which this clause belongs.
ImportRuleID
NOT NULLDBCHAR
Valid options include:
IndexColumnEnabled
• Y = Index will be created on this column.
• N = Index will not be created on this column.
NOT NULLDBINT
The length of the column.
Length
NOT NULLDBCHAR
Valid options include:
NullEnabled
• Y = Column allows a NULL entry.
• N = Column does not allow NULL values.
PK NOT NULLDBINT
The index for clauses within a given import rule.
SequenceNumber
NULLDBINT
The name of a Blended Agent standard column to which this field
will default.
StandardColumnType
NOT NULLDBINT
The data type of the column.
Type
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
222
Chapter 2: All Tables
Import_Rule_Clause Table