Expand All Collapse All
Organization

Organization Table

Organization

This table stores the details of organizations in the Interaction Center system. Each organization can have multiple locations and multile individuals (contacts).

  • 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

This column stores a Globally Unique Identifier(GUID) to uniquely identify an organization.

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

This column stores the name of an organization.

 4.0.106.453 4.0 Release
OrgTypeID int True No

This column stores the identifier for the organization type of an organization. Refer to the OrgTypeID column of the OrgType table for more information about organization types.

 4.0.106.453 4.0 Release
Active tinyint False No

This column stores a value indicating whether or not the organization is an active organization.

 4.0.106.453 4.0 Release
IsPrivate tinyint False No

This column stores a value indicating whether or not the organization is a private organization.

 4.0.106.453 4.0 Release
Version int False No

Stores the version for an organization record. Every time an organization is modified, the version field will be incremented.

 4.0.106.453 4.0 Release
AppOrgID nvarchar (255) True Depends on customer usage

This field can be used as a customization point. It can represent anything that meets the need of a business.

 4.0.106.453 4.0 Release
OwnerID nvarchar (50) True No

This column stores the IC User ID of the IC User that created this organization.

 4.0.106.453 4.0 Release
ExtID nvarchar (255) True Depends on customer usage

This column stores the external identifier in an external system for an organization that was imported from an external source. Currently, there is no Interaction Center process that populates this column.

 4.0.106.453 4.0 Release
ExtSource nvarchar (64) True Depends on customer usage

This column stores the name of the external source that an organization was imported from. Currently, there is no Interaction Center process that populates this column.

 4.0.106.453 4.0 Release
UnknownIndivID char (22) True Yes

This column stores the individual Identifier (IndivId) for an unknown individual who created this organization.

 4.0.106.453 4.0 Release
SiteID smallint True No

The column stores the site identifier for an organization.

 4.0.106.453 4.0 Release
ModifyDateTime datetime2 True No

This column stores the date time-stamp when an organization was last modified.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_Organization Clustered OrgID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_Organization_OrgTypeID OrgTypeID OrgType OrgTypeID Yes

Index Name Type Column Name (sort order)
IX_Org_AppOrgID_ExtSource Non-clustered AppOrgID (Ascending)
ExtSource (Ascending)
IX_Org_ExtID_ExtSource Non-clustered ExtID (Ascending)
ExtSource (Ascending)
IX_Org_Name_Active Unique non-clustered Name (Ascending)
Active (Descending)