Expand All Collapse All
Interaction Participants View

IntxParticipant_viw View

Interaction Participants View

This view returns 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 view.

  • Last Changed Version - 17.4.0.0
  • Last Changed Reason - Added for data extraction from Intx_Participant table.

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
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.

 17.4.0.0 Added for data extraction from Intx_Participant table.
Intx_Part_ID char (22) False No

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
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 0000000000000000000002 will be stored here. The System Individual identifier is 0000000000000000000001

 17.4.0.0 Added for data extraction from Intx_Participant table.
Role tinyint (1) 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.}

17.4.0.0 Added for data extraction from Intx_Participant table.
HowEnded tinyint (1) 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.
 17.4.0.0 Added for data extraction from Intx_Participant table.
WrapUpCode nvarchar (50) True Depends on customer usage

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
CallIDKey char (18) False No

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
Recorded tinyint (1) 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.

 17.4.0.0 Added for data extraction from Intx_Participant table.
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.

 17.4.0.0 Added for data extraction from Intx_Participant table.
DisplayName nvarchar (128) True Yes

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
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.

 17.4.0.0 Added for data extraction from Intx_Participant table.
Version int (4) 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.

 17.4.0.0 Added for data extraction from Intx_Participant table.
StartDateTime datetime2 (7) False No

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
Duration int (4) 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.

 17.4.0.0 Added for data extraction from Intx_Participant table.
IntxPartDateOffset int (4) True No

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
RecordingStartOffset int (4) True No

This is not used.

 17.4.0.0 Added for data extraction from Intx_Participant table.
RecordingStopOffset int (4) True No

This is not used.

 17.4.0.0 Added for data extraction from Intx_Participant table.
SecLevelRequested tinyint (1) True No

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
SecLevelViolationError nvarchar (128) True No

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
WrapupSegmentID smallint (2) True No

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

 17.4.0.0 Added for data extraction from Intx_Participant table.
EnumUpdateFlag tinyint (1) 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.

 17.4.0.0 Added for data extraction from Intx_Participant table.
SiteId smallint (2) True No

This column stores the site identifier for an interaction segment. This is a way to differentiate between interaction segments that existed on different sites.

 17.4.0.0 Added for data extraction from Intx_Participant table.