Expand All Collapse All
Locations

Location Table

Locations

This table stores the details of locations in the Interaction Center system. Each location can be assigned to only one organization. Organizations can have multiple locations.

  • 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
LocID char (22) False No

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

 4.0.106.453 4.0 Release
OrgID char (22) True No

This column stores the GUID (Globally Unique Identifier) of the organization that this location is assigned to. Refer to the OrgId column in the Organization table.

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

This column stores the name of the location.

 4.0.106.453 4.0 Release
Active tinyint False No

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

 4.0.106.453 4.0 Release
IsPrivate tinyint False No

This column stores a value indicating whether or not the location is a private location. Private locations can only be accessed by the IC User that created them and by Interaction Center Administrators.

 4.0.106.453 4.0 Release
Version int False No

Stores the version for the location record. Every time a location is edited, the version will be incremented.

 4.0.106.453 4.0 Release
AppLocID 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 location.

 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 a location 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 a location 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 location.

 4.0.106.453 4.0 Release
SiteID smallint True No

The column stores the site identifier for a location record.

 4.0.106.453 4.0 Release
ModifyDateTime datetime2 True No

This column stores the date time-stamp when this location was last modified.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_Location Clustered LocID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_Location_OrgID OrgID Organization OrgID Yes

Index Name Type Column Name (sort order)
IX_Loc_AppLocID_ExtSource Non-clustered AppLocID (Ascending)
ExtSource (Ascending)
IX_Loc_ExtID_ExtSource Non-clustered ExtID (Ascending)
ExtSource (Ascending)
IX_Location_Name_Active Non-clustered Name (Ascending)
Active (Descending)
IX_Location_OrgID_Active_Name Unique non-clustered OrgID (Ascending)
Active (Descending)
Name (Ascending)