Expand All Collapse All
Line Config

LineConfig Table

Line Config

Content of this table is a mirror image of the lines 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
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

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_LineConfig Non-clustered LineId (Ascending)
SiteId (Ascending)


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