Expand All Collapse All
Attribute Types

AttributeType Table

Attribute Types

Interaction Tracker attribute types can be used to customize data that Tracker associates with individuals, organizations, locations and interactions. They can be created and configured in Interaction Administrator. They can be assigned to individuals, organizations, locations and interactions in Interaction Desktop.

  • 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

A uniqueue numeric identifier for a Tracker attribute type.

 4.0.106.453 4.0 Release
Name nvarchar (50) False Depends on customer usage

The name of a Tracker attribute type. This will be shown wherever Tracker attribute types are displayed.

 4.0.106.453 4.0 Release
LegalValues nvarchar (2000) True No

This column holds the allowed values that can be configured for each Tracker attribute type. Legal values are not required for Tracker attribute types. If desired, they can be created and configured in Interaction Administrator. The legal values, if configured, will be displayed in a dropdown control in Interaction Desktop wherever Tracker attribute types are displayed.

 4.0.106.453 4.0 Release
ShowIfEmpty tinyint False No

This column indicates whether or not a Tracker attribute type should be displayed in Interaction Desktop if it has no value.

 4.0.106.453 4.0 Release
AppliesTo int False No

This column indicates which Tracker entities a Tracker attribute type applies to. A Tracker attribute type can be applied to individuals, organizations, locations and interactions. Tracker attribute types can be configured in Interaction Administrator.

 4.0.106.453 4.0 Release
Admin_Editable int False No

Stores a value indicating whether or not an address type can be edited by an Interaction Center Administrator.

 4.0.106.453 4.0 Release
Version int False No

The version for the Interaction Tracker attribute type. The version field is used to track changes to a Tracker attribute type.

 4.0.106.453 4.0 Release

SQL Constraints

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


Index Name Type Column Name (sort order)
IX_AttributeType_Name Unique non-clustered Name (Ascending)