Expand All Collapse All
Organization Types

OrgType Table

Organization Types

This table stores the details of the organization types that are configured in the system. Organization types can be configured in the Interaction Administrator under the Interaction Tracker node. Some examples of organization types are Parter, Vender, Customer and External.

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

This column stores the identifier for an organization type.

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

This column stores the name of an organization type.

 4.0.106.453 4.0 Release
Admin_Editable int False No

This column stores a value indicating whether or not an organization type can be edited by an Interaction Center Administrator.

 4.0.106.453 4.0 Release
Version int False No

Stores the version of an organization type. The version field is used to track changes to organization types.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_OrgType Clustered OrgTypeID (Ascending)


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