Expand All Collapse All
Titles

Title Table

Titles

This table stores the details of Titles. Titles can be created and edited in Interaction Administrator under the Interaction Tracker node.

  • 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
TitleID int False No

Stores the identifier for a title.

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

This column stores the textual value of a title. E.g. Mr., Mrs., Jr., Dr., etc.

 4.0.106.453 4.0 Release
Admin_Editable int False No

This column stores a value indicating whether or not a title is editable by the administrator.

 4.0.106.453 4.0 Release
Version int False No

Stores the version of a title. Every time a title 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_Title Clustered TitleID (Ascending)


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