Expand All Collapse All
Interaction Participants

Intx_Participant Table

Interaction Participants

This table stores participant information for the participants involved in a segment for an interaction. For a simple two party interaction segment, there will be two records in this table.

  • Table Type - Historical
  • Last Changed Version - 15.3.0.384
  • Last Changed Reason - Updated column WrapUpSegmentID data type to allow values greater than 255.

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
IntxID char (22) False No

A Globally Unique Identifier(GUID) to uniquely identify an interaction segment. Refer to the IntxId column of the IntxSegment table. An interaction will have multiple segments.

 4.0.106.453 4.0 Release
Intx_Part_ID char (22) False No

A Globally Unique Identifier(GUID) to uniquely identify a participant in a segment for an interaction.

 4.0.106.453 4.0 Release
IndivID char (22) False Yes

The individual ID of an individual (contact) that is a participant on an interaction. Refer to the IndivID column of the Individual table. If there is no record in the Individual table for a participant, the Unknown Individual identifier

 4.0.106.453 4.0 Release
Role tinyint False No

This column represents the role of the participant in an interaction scenario. The role can be one of the following types { Unknown - 0, Initiator - 1, Respondent - 2, Participant(for Conferences) - 3.}

4.0.106.453 4.0 Release
HowEnded tinyint True No

This column stores a value indicating how an interaction segment for a participant ended. A segment for a participant can end with the following How Ended codes:

  • eSegHowEndedType_Unknown = -1, Used for (some) initializations, or when a conversion is invalid, etc.
  • eSegHowEndedType_NotEnded = 0, The segment is still active.
  • eSegHowEndedType_Disconnect = 1, The interaction was disconnected.
  • eSegHowEndedType_LocalDisconnect = 2, The interaction was disconnected by the local party.
  • eSegHowEndedType_RemoteDisconnect = 3, The interaction was disconnected by the remote party.
  • eSegHowEndedType_Transfer = 4, The interaction had a party transferred.
  • eSegHowEndedType_LocalTransfer = 5, The interaction had a party transferred locally.
  • eSegHowEndedType_RemoteTransfer = 6, The interaction had a party transferred remotely.
  • eSegHowEndedType_Conference = 7, The interaction had a conference created on it.
  • eSegHowEndedType_System = 8, The interaction went into non-IVR system processing.
  • eSegHowEndedType_Interact = 9, The interaction went to an interact/connect segment.
  • eSegHowEndedType_Messaging = 10, The interaction went into voicemail or other messaging.
  • eSegHowEndedType_Alert = 11, The interaction went to alerting.
  • eSegHowEndedType_Hold = 12, The interaction went on hold of the controlling party.
  • eSegHowEndedType_Retrieve = 13, The interaction had a retrieve action.
  • eSegHowEndedType_Park = 14, The interaction went to park.
  • eSegHowEndedType_ConsultTransfer = 15, The interaction had a party consult transferred.
  • eSegHowEndedType_Grabbed = 16, The interaction was grabbed.
  • eSegHowEndedType_WorkgroupChanged = 17, The servicing workgroup changed (maybe to none)
  • eSegHowEndedType_IVR = 18, The interaction went into IVR.
  • eSegHowEndedType_Suspend = 19, The interaction was suspended
  • eSegHowEndedType_Delay = 20, The interaction went into a wait (usually in a workgroup queue)
  • eSegHowEndedType_Survey = 21, The interaction went into survey/feedback
  • eSegHowEndedType_Snoozed = 22, The interaction went into snooze.
 4.0.106.453 4.0 Release
WrapUpCode nvarchar (50) True Depends on customer usage

This column represents the wrap up code entered by a participant for an interaction segment.

 4.0.106.453 4.0 Release
CallIDKey char (18) False No

This column represents the InteractionId key or CallId ey set on a participant for an interaction segment. Participants belonging to the same interaction segment will have the same value for this column.

 4.0.106.453 4.0 Release
Recorded tinyint False No

Stores a value indicating whether or not a segment was recorded for a participant. This column is 1 if the participant leg of the interaction was recorded.

 4.0.106.453 4.0 Release
ConnValue nvarchar (255) True Yes

This column stores the connection value for a participant in an interaction segment. This value comes from the IndivConnection table for the matching participant IndivID.

 4.0.106.453 4.0 Release
DisplayName nvarchar (128) True Yes

This column stores the display name of a participant. This value comes from the Reverse White Pages lookup.

 4.0.106.453 4.0 Release
StationName nvarchar (50) True Depends on customer usage

This column stores the station name of a participant in an interaction segment. This value comes from Reverse White Pages lookup.

 4.0.106.453 4.0 Release
Version int False No

Stores the version of a segment participant record. The version field is used to track changes to the record. This is typically used for migration purposes.

 4.0.106.453 4.0 Release
StartDateTime datetime2 False No

This column stores the start date time-stamp of the segment participant record.

 4.0.106.453 4.0 Release
Duration int True No

This column stores a value (in seconds) that indicates how long this participant was a participant in an interaction segment. Each participant in a segment can have different durations. For example, in a conference segment, the participants can enter and leave the conference at different times. Therefore, the participant records for the conference segment will have different durations.

 4.0.106.453 4.0 Release
IntxPartDateOffset int True No

This column stores the IC Server date offset from GMT in seconds for Intx_Participant table records.

 4.0.106.453 4.0 Release
RecordingStartOffset int True No

This is not used.

 4.0.106.453 4.0 Release
RecordingStopOffset int True No

This is not used.

 4.0.106.453 4.0 Release
SecLevelRequested tinyint True No

This column stores the requested security level for a segment. This is a specialized feature in Interaction Center.

 4.0.106.453 4.0 Release
SecLevelViolationError nvarchar (128) True No

This column stores any security level violation error for an interaction segment.

 4.0.106.453 4.0 Release
WrapupSegmentID smallint True No

This column stores the wrapup segment identifier for an interaction segment.

 15.3.0.384 Updated data type to allow values greater than 255.
EnumUpdateFlag tinyint False No

This column stores a value indicating whether or not the HowEnded column value was updated due to enumerated value changes. The enumerated values for the HowEnded column were not consistent between 3.0 and 4.0 versions. To correct the enumerated values in 4.0, any data records inserted prior to and including 3.0 SU3 need to have the value for HowEnded modified. To accomplish this, a database script was run. The impacted records will have this column value set to 1.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_Intx_Participant Non-clustered Intx_Part_ID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_Intx_Participant_IntxID IntxID IntxSegment IntxID Yes
FK_Intx_Participant_IndivID IndivID Individual IndivID Yes

Index Name Type Column Name (sort order)
IX_Intx_Participant_CallIDKey Non-clustered CallIDKey (Ascending)
IX_Intx_Participant_ConnValue Non-clustered ConnValue (Ascending)
IX_Intx_Participant_INCL Non-clustered Role (Ascending)
IntxID (Ascending)
Intx_Part_ID (Ascending)
IndivID (Ascending)
IX_Intx_Participant_InDivID_2 Unique non-clustered IndivID (Ascending)
StartDateTime (Ascending)
Intx_Part_ID (Ascending)
IntxID (Ascending)
IX_Intx_Participant_IntxID_2 Unique non-clustered IntxID (Ascending)
StartDateTime (Ascending)
Intx_Part_ID (Ascending)
IndivID (Ascending)
IX_StartDT Clustered StartDateTime (Ascending)