Expand All Collapse All
Line Group Lines

LineGroupLines Table

Line Group Lines

Content of this table is a mirror image of the line group to lines relationship as they are 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
GroupId nvarchar (50) False Depends on customer usage

Group identifier for the line group.

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

Line identifier for a line in the Line Group.

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime False No

System supplied date/time when 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 this 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_LineGroupLines Non-clustered GroupId (Ascending)
LineId (Ascending)
SiteId (Ascending)


Index Name Type Column Name (sort order)
I3TimeStampGMT Clustered I3TimeStampGMT (Ascending)
SiteId (Ascending)