Expand All Collapse All
Individual Attribute

IndivAttribute Table

Individual Attribute

This table stores the details of Tracker attributes assigned to individuals (contacts). Attributes can be assigned to an individual (contact) when created in Interaction Desktop. Their values can be managed from the Tracker Contact Prioperties Dialog 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
IndivID char (22) False Yes

The Globally Unique Identifier(GUID) of the individual (contact) that this attribute is assigned to. Refer to the IndivID column of the Individual table.

 4.0.106.453 4.0 Release
AttrTypeID int False No

This field stores the attribute type identifier for an individual attribute. Refer to the AttributeType table for more information about attribute types configured in your system.

 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 individual. For example, if you specify something such as "New Customer" for the predefined Tracker attribute "Remarks" for an individual (contact), the text "New Customer" will be stored in this field.

 4.0.106.453 4.0 Release
Version int False No

Stores the version of an individual attribute. Every time an individual attribute is edited, the version field will be incremented.

 4.0.106.453 4.0 Release

SQL Constraints

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

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IndivAttribute_IndivID IndivID Individual IndivID Yes
FK_IndivAttribute_AttrTypeID AttrTypeID AttributeType AttrTypeID Yes