Expand All Collapse All
Interaction Attributes

InteractionAttribute Table

Interaction Attributes

This table stores details about Tracker attributes that are assigned to interactions. Multiple Tracker attributes can be assigned to an interaction using Interaction Desktop. Tracker attribute types can be managed using Interaction Administrator.

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
AttrTypeID int False No

This column stores the Tracker attribute type identifier for the Tracker attribute type that is associated an interaction. Refer to the AttrTypeID column of the AttributeType table.

 4.0.106.453 4.0 Release
IntxID char (22) False No

A Globally Unique Identifier(GUID) to uniquely identify an interaction. Refer to the IntxId column of the IntxSegment table.

 4.0.106.453 4.0 Release
FldVal nvarchar (2000) True No

This field stores the actual value of a Tracker attribute assigned to an interaction. For example, if there is a Tracker attribute type called "Reason for Call" defined in Interaction Administrator, you can specify something such as "Product Inquiry" for this Tracker attribute type using Interacion Desktop. Then, the text "Product Inquiry" will be stored in this field.

 4.0.106.453 4.0 Release
Version int False No

Stores the version for the Tracker interaction attribute record. The version field is used to track changes to Tracker interaction attribute records. Every time an attribute value is modified, the version field will be increment.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_InteractionAttribute Clustered AttrTypeID (Ascending)
IntxID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IntxAttr_AttrTypeID AttrTypeID AttributeType AttrTypeID Yes
FK_IntxAttr_IntxID IntxID IntxSegment IntxID Yes