| 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 |
|---|---|---|---|---|---|---|---|---|---|
| EventId | int | False | No | 4.0.106.453 | 4.0 Release | ||||
| RecordingId | uniqueidentifier | False | No | 4.0.106.453 | 4.0 Release | ||||
| EventType | smallint | False | No | 4.0.106.453 | 4.0 Release | ||||
| EventDate | datetime2 | False | No | 4.0.106.453 | 4.0 Release | ||||
| EventDateOffset | int | False | No | 4.0.106.453 | 4.0 Release | ||||
| Duration | int | True | No | 4.0.106.453 | 4.0 Release | ||||
| IndivId | char (22) | True | Yes | 4.0.106.453 | 4.0 Release | ||||
| IntxId | char (22) | True | No | 4.0.106.453 | 4.0 Release | ||||
| Intx_Part_Id | char (22) | True | Yes | 4.0.106.453 | 4.0 Release | ||||
| DisplayName | nvarchar (255) | True | Yes | 4.0.106.453 | 4.0 Release | ||||
| IsInternalParticipant | tinyint | False | No | 4.0.106.453 | 4.0 Release | ||||
| ConnValue | nvarchar (255) | True | Yes | 4.0.106.453 | 4.0 Release | ||||
| Workgroup | nvarchar (255) | True | Depends on customer usage | 4.0.106.453 | 4.0 Release | ||||
| InitiatedFor | tinyint | False | No | 4.0.106.453 | 4.0 Release | ||||
| Version | int | False | No | 4.0.106.453 | 4.0 Release | ||||
| Notes | nvarchar (1024) | True | Depends on customer usage | 4.0.106.453 | 4.0 Release | ||||
| KeywordId | int | True | No | 4.0.106.453 | 4.0 Release | ||||
| KeywordChannel | tinyint | True | No | 4.0.106.453 | 4.0 Release | ||||
| KeywordScore | smallint | True | No | 4.0.106.453 | 4.0 Release | ||||
| KeywordUtterance | varchar (1024) | True | Depends on customer usage | 4.0.106.453 | 4.0 Release | ||||
| KeywordConfidence | numeric | True | No | 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 |
|---|---|---|---|---|---|---|---|---|---|
| EventId | integer | False | No | 4.0.106.453 | 4.0 Release | ||||
| RecordingId | raw (16) | False | No | 4.0.106.453 | 4.0 Release | ||||
| EventType | smallint | False | No | 4.0.106.453 | 4.0 Release | ||||
| EventDate | timestamp | False | No | 4.0.106.453 | 4.0 Release | ||||
| EventDateOffset | integer | False | No | 4.0.106.453 | 4.0 Release | ||||
| Duration | integer | True | No | 4.0.106.453 | 4.0 Release | ||||
| IndivId | char (22) | True | Yes | 4.0.106.453 | 4.0 Release | ||||
| IntxId | char (22) | True | No | 4.0.106.453 | 4.0 Release | ||||
| Intx_Part_Id | char (22) | True | Yes | 4.0.106.453 | 4.0 Release | ||||
| DisplayName | nvarchar2 (255) | True | Yes | 4.0.106.453 | 4.0 Release | ||||
| IsInternalParticipant | smallint | False | No | 4.0.106.453 | 4.0 Release | ||||
| ConnValue | nvarchar2 (255) | True | Yes | 4.0.106.453 | 4.0 Release | ||||
| Workgroup | nvarchar2 (255) | True | Depends on customer usage | 4.0.106.453 | 4.0 Release | ||||
| InitiatedFor | smallint | False | No | 4.0.106.453 | 4.0 Release | ||||
| Version | integer | False | No | 4.0.106.453 | 4.0 Release | ||||
| Notes | nvarchar2 (1024) | True | Depends on customer usage | 4.0.106.453 | 4.0 Release | ||||
| KeywordId | integer | True | No | 4.0.106.453 | 4.0 Release | ||||
| KeywordChannel | smallint | True | No | 4.0.106.453 | 4.0 Release | ||||
| KeywordScore | smallint | True | No | 4.0.106.453 | 4.0 Release | ||||
| KeywordUtterance | varchar2 (1024) | True | Depends on customer usage | 4.0.106.453 | 4.0 Release | ||||
| KeywordConfidence | numeric | True | No | 4.0.106.453 | 4.0 Release |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_IR_Event | Clustered | EventId (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_IR_Event | EventId (Ascending) |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IR_Event_RecordingId | RecordingId | IR_RecordingMedia | RecordingId | Yes |
| FK_IR_Event_IndivId | IndivId | Individual | IndivID | Yes |
| FK_IR_Event_IntxId | IntxId | IntxSegment | IntxID | Yes |
| FK_IR_Event_Intx_Part_Id | Intx_Part_Id | Intx_Participant | Intx_Part_ID | Yes |
| FK_IR_Event_KeywordId | KeywordId | IR_Keyword | KeywordId | Yes |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IR_Event_RecordingId | RecordingId | IR_RecordingMedia | RecordingId | Yes |
| FK_IR_Event_IndivId | IndivId | Individual | IndivID | Yes |
| FK_IR_Event_IntxId | IntxId | IntxSegment | IntxID | Yes |
| FK_IR_Event_Intx_Part_Id | Intx_Part_Id | Intx_Participant | Intx_Part_ID | Yes |
| FK_IR_Event_KeywordId | KeywordId | IR_Keyword | KeywordId | Yes |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| IX_IR_Event_EventDate | Non-clustered | EventDate (Ascending) |
| IX_IR_Event_EvType_KWC_RecId | Non-clustered | EventType (Ascending) KeywordConfidence (Ascending) RecordingId (Ascending) |
| IX_IR_Event_EvType_RecId_EvId | Non-clustered | EventType (Ascending) RecordingId (Ascending) EventId (Ascending) |
| IX_IR_Event_IndivId | Non-clustered | IndivId (Ascending) |
| IX_IR_Event_Intx_Part_Id | Non-clustered | Intx_Part_Id (Ascending) |
| IX_IR_Event_IntxId | Non-clustered | IntxId (Ascending) |
| IX_IR_Event_KeywordId | Non-clustered | KeywordId (Ascending) |
| IX_IR_Event_RecId_Type_Dura | Non-clustered | RecordingId (Ascending) EventType (Ascending) Duration (Ascending) |
| IX_IR_Event_Workgroup | Non-clustered | Workgroup (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| IX_IR_Event_EventDate | EventDate (Ascending) |
| IX_IR_Event_EvType_KWC_RecId | EventType (Ascending) KeywordConfidence (Ascending) RecordingId (Ascending) |
| IX_IR_Event_EvType_RecId_EvId | EventType (Ascending) RecordingId (Ascending) EventId (Ascending) |
| IX_IR_Event_IndivId | IndivId (Ascending) |
| IX_IR_Event_Intx_Part_Id | Intx_Part_Id (Ascending) |
| IX_IR_Event_IntxId | IntxId (Ascending) |
| IX_IR_Event_KeywordId | KeywordId (Ascending) |
| IX_IR_Event_RecId_Type_Dura | RecordingId (Ascending) EventType (Ascending) Duration (Ascending) |
| IX_IR_Event_Workgroup | Workgroup (Ascending) RecordingId (Ascending) |