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.
| 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 |
| 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 | nvarchar2 (50) | False | Depends on customer usage | Group identifier for the line group. |
4.0.106.453 | 4.0 Release | |||
| LineId | nvarchar2 (50) | False | Depends on customer usage | Line identifier for a line in the Line Group. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | date | 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 | number | 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 | number | 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 |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_LineGroupLines | Non-clustered | GroupId (Ascending) LineId (Ascending) SiteId (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_LineGroupLines | GroupId (Ascending) LineId (Ascending) SiteId (Ascending) |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| I3TimeStampGMT | Clustered | I3TimeStampGMT (Ascending) SiteId (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| i3timestampgmt_lg | I3TimeStampGMT (Ascending) SiteId (Ascending) |