Expand All Collapse All
Organization Attributes.

OrgAttribute Table

Organization Attributes.

This table stores the details of Tracker attributes assigned to organizations. Tracker attributes can be assigned to an organization when created in Interaction Desktop. Their values can be managed from the Tracker Organization 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
OrgID char (22) False No

The Globally Unique Identifier(GUID) of the organization that an attribute is assigned to. Refer to the OrgID column of the Organization table.

 4.0.106.453 4.0 Release
AttrTypeID int False No

This column stores the identifier of the Tracker Attribute type being assigned to an organization. Refer to the AttrTypeID column of the AttributeType table.

 4.0.106.453 4.0 Release
FldVal nvarchar (2000) True No

This column stores the actual value for an organization attribute.

 4.0.106.453 4.0 Release
Version int False No

Stores the version of an organization attribute. Every time an organization 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_OrgAttribute Clustered OrgID (Ascending)
AttrTypeID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_OrgAttribute_OrgID OrgID Organization OrgID Yes
FK_OrgAttribute_AttrTypeID AttrTypeID AttributeType AttrTypeID Yes