Expand All Collapse All
User Workgroups

UserWorkgroups Table

User Workgroups

The content of this table is a mirror image of users and their workgroup membership as you have them currently configured in CIC.

  • 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
UserId nvarchar (50) False Yes

User identifier for a user configured in CIC.

 4.0.106.453 4.0 Release
WorkGroup nvarchar (50) False Depends on customer usage

Workgroup for which the user is currently a member in CIC.

 4.0.106.453 4.0 Release
QueueFlag tinyint False No

Flag that indicates if the workgroup has a queue. Workgroups can be created without queues and are typically used for organization purposes at a site. This flag allows reports to use queue or non-queue workgroups, where appropriate, based on the type of report being executed. 'N' = No queue, 'Y' = Has Queue.

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime False No

System supplied date time when the row was sent to the IC Logging server for insertion into the table.

 4.0.106.453 4.0 Release
SiteId smallint False No

Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of data.

 4.0.106.453 4.0 Release
SubSiteId smallint False No

Not used in the current release. The purpose of this field is to divide use within a site, such as for multiple independent companies on one CIC system. Until CIC has such functionality, this field is zero and is reserved for future use

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_UserWorkgroups Clustered WorkGroup (Ascending)
UserId (Ascending)
SiteId (Ascending)


Index Name Type Column Name (sort order)
IEUserId Unique non-clustered UserId (Ascending)
WorkGroup (Ascending)
SiteId (Ascending)