Line Config
Content of this table is a mirror image of the lines as you have them 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 |
|---|---|---|---|---|---|---|---|---|---|
| LineId | nvarchar (50) | False | Depends on customer usage | Identifier for the line. |
4.0.106.453 | 4.0 Release | |||
| ActiveFlag | smallint | False | No | Flag indicating if the line configuration is an active or inactive configuration. Normally, inactive lines would be ignored by reports. 1 = Active, 0 = Inactive. |
4.0.106.453 | 4.0 Release | |||
| Direction | varchar (20) | False | No | Line direction. |
4.0.106.453 | 4.0 Release | |||
| LineType | varchar (50) | False | No | Line or board type of the line. Expected values would be Analog, T1, and E1. |
4.0.106.453 | 4.0 Release | |||
| PhoneNumber | varchar (20) | False | Depends on customer usage | Phone number of the line. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | datetime | False | No | System supplied date/time when this 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 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 |
| 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 |
|---|---|---|---|---|---|---|---|---|---|
| LineId | nvarchar2 (50) | False | Depends on customer usage | Identifier for the line. |
4.0.106.453 | 4.0 Release | |||
| ActiveFlag | number | False | No | Flag indicating if the line configuration is an active or inactive configuration. Normally, inactive lines would be ignored by reports. 1 = Active, 0 = Inactive. |
4.0.106.453 | 4.0 Release | |||
| Direction | varchar2 (20) | True | No | Line direction. |
4.0.106.453 | 4.0 Release | |||
| LineType | varchar2 (50) | True | No | Line or board type of the line. Expected values would be Analog, T1, and E1. |
4.0.106.453 | 4.0 Release | |||
| PhoneNumber | varchar2 (20) | True | Depends on customer usage | Phone number of the line. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | date | False | No | System supplied date/time when this 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 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 |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_LineConfig | Non-clustered | LineId (Ascending) SiteId (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_LineConfig | LineId (Ascending) SiteId (Ascending) |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| I3TimeStampGMT | Clustered | I3TimeStampGMT (Ascending) SiteId (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| i3timestampgmt_lc | I3TimeStampGMT (Ascending) SiteId (Ascending) |