Expand All Collapse All
Interaction Recorder Data

Interaction Recorder Data

New schema dbo have been created for Interaction Recorder related tables, sprocs, views and triggers.


ININSearch Table

Recording search information like search title, search target can be stored in ININSearch table.

ININSearch Column Definitions

ININSearch Constraints



ININSearchDefn Table

Sequence number of the question within the survey and the name of the attribute that was changed in IA can be found in ININSearchDefn table.

ININSearchDefn Column Definitions

ININSearchDefn Constraints



ININSearchResultSet Table

Result key of search with respective ININSearch id is stored in ININSearchResultSet table.

ININSearchResultSet Column Definitions

ININSearchResultSet Constraints



IR_AccessControl Table

IR_AccessControl table conatins the infromation of the recording ID and the security policy ID.

IR_AccessControl Column Definitions

IR_AccessControl Constraints



IR_ArchiveContent Table

ID of the archive volume and date of recording is stored in IR_ArchiveContent table.

IR_ArchiveContent Column Definitions

IR_ArchiveContent Constraints



IR_ArchiveVolumeDescriptor Table

IR_ArchiveVolumeDescriptor table is used to store media URI and volume name.

IR_ArchiveVolumeDescriptor 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
ArchiveId uniqueidentifier False No

4.0.106.453 4.0 Release
VolumeName nvarchar (128) False Depends on customer usage

4.0.106.453 4.0 Release
VolumeDT datetime2 False No

4.0.106.453 4.0 Release
VolumeDTOffset int False No

4.0.106.453 4.0 Release
ArchiveStartDT datetime2 True No

4.0.106.453 4.0 Release
ArchiveEndDT datetime2 True No

4.0.106.453 4.0 Release
MediaURI nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release

IR_ArchiveVolumeDescriptor Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_ArchiveVolumeDescriptor Clustered ArchiveId (Ascending)


IR_Audit Table

IR_Audit table used to store audit operation and audit date.

IR_Audit 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
AuditId uniqueidentifier False No

4.0.106.453 4.0 Release
Id uniqueidentifier False No

4.0.106.453 4.0 Release
AuditDate datetime False No

4.0.106.453 4.0 Release
AuditDateOffset int False No

4.0.106.453 4.0 Release
AuditOperation smallint False No

4.0.106.453 4.0 Release
IndivId char (22) True Yes

4.0.106.453 4.0 Release
ICUID nvarchar (255) True Yes

4.0.106.453 4.0 Release
AuditedName nvarchar (255) True Yes

4.0.106.453 4.0 Release
Comments nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

IR_Audit Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_Audit Clustered AuditId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_Audit_IndivId IndivId Individual IndivID Yes

Index Name Type Column Name (sort order)
IX_IR_Audit_AuditOperation Non-clustered AuditOperation (Ascending)
IX_IR_Audit_Id Non-clustered Id (Ascending)
IX_IR_Audit_IndivId Non-clustered IndivId (Ascending)

IR_CustomAttribute Table

IR_CustomAttribute table is used to store Custom attribute name.

IR_CustomAttribute Column Definitions

IR_CustomAttribute Constraints



IR_CustomAttributeName Table

The name of an address type is stored in IR_CustomAttributeName table. This name will be shown wherever address types are displayed. The address types are configured in Interaction Administrator under the Interaction Tracker node.

IR_CustomAttributeName 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
CustomAttributeNameId int False No

4.0.106.453 4.0 Release
Name nvarchar (255) False Depends on customer usage

4.0.106.453 4.0 Release

IR_CustomAttributeName Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_CustomAttributeName Clustered CustomAttributeNameId (Ascending)


Index Name Type Column Name (sort order)
IX_IR_CustomAttributeName_Name Non-clustered Name (Ascending)

IR_Event Table

Interaction participant information of recording such as connection value for a participant in an interaction segment, the display name of a participant etc is stored in IR_Event tablex.

IR_Event 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
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

IR_Event Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_Event Clustered 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

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)

IR_EventKeywordInfo Table

IR_EventKeywordInfo table used to store the IR_Event id and keyword set id.

IR_EventKeywordInfo 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
EventId int False No

4.0.106.453 4.0 Release
KeywordSetId int False No

4.0.106.453 4.0 Release

IR_EventKeywordInfo Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_EventKeywordInfo Clustered EventId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_EventKeywordInfo_EventId EventId IR_Event EventId Yes
FK_IR_EventKeywordInfo_KwsId KeywordSetId IR_KeywordSet KeywordSetId Yes

Index Name Type Column Name (sort order)
IX_IR_EventKeywordInfo_KwsId Non-clustered KeywordSetId (Ascending)

IR_Keyword Table

IR_Keyword table stores the recording keywords.

IR_Keyword 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
KeywordId int False No

4.0.106.453 4.0 Release
KeywordName nvarchar (128) False Depends on customer usage

4.0.106.453 4.0 Release

IR_Keyword Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_Keyword Clustered KeywordId (Ascending)


IR_KeywordSet Table

Keyword name of AnalyzerKeywordHit_viw view can be searched in IR_KeywordSet table which has reference to the keyword id of IR_Event table.

IR_KeywordSet 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
KeywordSetId int False No

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.
DisplayName nvarchar (128) False Depends on customer usage

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.
Category nvarchar (128) True Depends on customer usage

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.

IR_KeywordSet Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_KeywordSet Clustered KeywordSetId (Ascending)


Index Name Type Column Name (sort order)
IX_IR_KeywordSet_Category Non-clustered Category (Ascending)
IX_IR_KeywordSet_DisplayName Non-clustered DisplayName (Ascending)

IR_QAnswer Table

Answers related information like Actual score received, raw text input of the answer etc is stored in IR_QAnswer table.

IR_QAnswer Column Definitions

IR_QAnswer Constraints



IR_QDirectory Table

Surevey directory name and notes about the survey or survey group are stored in IR_QDirectory table.

IR_QDirectory 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
QDirectoryId uniqueidentifier False No

4.0.106.453 4.0 Release
QDirectoryName nvarchar (255) True Depends on customer usage

4.0.106.453 4.0 Release
Note nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
IsTemplate tinyint False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

IR_QDirectory Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_QDirectory Clustered QDirectoryId (Ascending)


IR_QForm Table

Survey information like score received, number of critical questions answered, name of the rank given to this survey result, name of the Recorder Policy that caused the form to be assigned is stored in IR_QForm table.

IR_QForm Column Definitions

IR_QForm Constraints



IR_QGroup Table

Group name, notes about the survey or survey group is stotred in IR_QGroup table.

IR_QGroup 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
QGroupId uniqueidentifier False No

4.0.106.453 4.0 Release
QuestionnaireId uniqueidentifier True No

4.0.106.453 4.0 Release
GroupName nvarchar (255) False Depends on customer usage

4.0.106.453 4.0 Release
Sequence int False No

4.0.106.453 4.0 Release
Note nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
IsOptional tinyint False No

4.0.106.453 4.0 Release
IsTemplate tinyint False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

IR_QGroup Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_QGroup Clustered QGroupId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_QGroup_QuestionnaireId QuestionnaireId IR_Questionnaire QuestionnaireId Yes

Index Name Type Column Name (sort order)
IX_IR_QGroup_QuestionnaireId Non-clustered QuestionnaireId (Ascending)

IR_QQuestion Table

Information about questions like importance, help text, type of the question is stored in IR_QQuestion table. Also minimal/maximum acceptable score for the survey is stored in same table

IR_QQuestion 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
QQuestionId uniqueidentifier False No

4.0.106.453 4.0 Release
QGroupId uniqueidentifier False No

4.0.106.453 4.0 Release
QuestionText nvarchar (1024) False Depends on customer usage

4.0.106.453 4.0 Release
QuestionType smallint False No

4.0.106.453 4.0 Release
QuestionPromptType smallint False No

4.0.106.453 4.0 Release
HelpText nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
Weight numeric False No

4.0.106.453 4.0 Release
Sequence int False No

4.0.106.453 4.0 Release
MaxScore numeric False No

4.0.106.453 4.0 Release
MinScore numeric False No

4.0.106.453 4.0 Release
MinAcceptableScore numeric False No

4.0.106.453 4.0 Release
Note nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
IsTemplate tinyint False No

4.0.106.453 4.0 Release
HasCommentField tinyint False No

4.0.106.453 4.0 Release
CanMarkNA tinyint False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

IR_QQuestion Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_QQuestion Clustered QQuestionId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_QQuestion_QGroupId QGroupId IR_QGroup QGroupId Yes

Index Name Type Column Name (sort order)
IX_IR_QQuestion_QGroupId Non-clustered QGroupId (Ascending)

IR_QQuestionEnum Table

IR_QQuestionEnum table used to store the sequence number of the question within the survey.

IR_QQuestionEnum 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
QQuestionId uniqueidentifier False No

4.0.106.453 4.0 Release
Sequence int False No

4.0.106.453 4.0 Release
EnumText nvarchar (255) False Depends on customer usage

4.0.106.453 4.0 Release
HelpText nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
Score numeric False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

IR_QQuestionEnum Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_QQuestionEnum Clustered QQuestionId (Ascending)
Sequence (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_QQuestionEnu_QQuestionId QQuestionId IR_QQuestion QQuestionId Yes

IR_Questionnaire Table

Questionnaire name, pass/fail result, rank while scoring is shown using IR_Questionnaire table.

IR_Questionnaire 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
QuestionnaireId uniqueidentifier False No

4.0.106.453 4.0 Release
QDirectoryId uniqueidentifier False No

4.0.106.453 4.0 Release
QuestionnaireName nvarchar (255) False Depends on customer usage

4.0.106.453 4.0 Release
RankGroupId uniqueidentifier True No

4.0.106.453 4.0 Release
MaxScore numeric True No

4.0.106.453 4.0 Release
MinScore numeric True No

4.0.106.453 4.0 Release
MinAcceptableScore numeric True No

4.0.106.453 4.0 Release
Note nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
IsTemplate tinyint False No

4.0.106.453 4.0 Release
IsLocked tinyint False No

4.0.106.453 4.0 Release
ShowRankWhileScoring tinyint False No

4.0.106.453 4.0 Release
TotalNumCriticalQuestions int False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release
IsActive tinyint False No

4.0.106.453 4.0 Release
ShowPassFailWhileScoring tinyint False No

4.0.106.453 4.0 Release

IR_Questionnaire Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_Questionnaire Clustered QuestionnaireId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_Qnaire_QDirectoryId QDirectoryId IR_QDirectory QDirectoryId Yes
FK_IR_Questionnair_RankGroupId RankGroupId IR_RankGroup RankGroupId Yes

IR_RankDefn Table

IR_RankDefn table.

IR_RankDefn 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
RankId uniqueidentifier False No

4.0.106.453 4.0 Release
RankGroupId uniqueidentifier False No

4.0.106.453 4.0 Release
RankName nvarchar (40) False Depends on customer usage

4.0.106.453 4.0 Release
RankPct numeric False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

IR_RankDefn Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_RankDefn Clustered RankId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_RankDefn_RankGroupId RankGroupId IR_RankGroup RankGroupId Yes

IR_RankGroup Table

Name of the rank given to this survey result is shown using IR_RankGroup table.

IR_RankGroup 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
RankGroupId uniqueidentifier False No

4.0.106.453 4.0 Release
GroupName nvarchar (60) False Depends on customer usage

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

IR_RankGroup Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_RankGroup Clustered RankGroupId (Ascending)


IR_RecordingMedia Table

Information about recording like call type, direction (inbound/outbound), duration, file size, expiration date etc. is shown using IR_RecordingMedia table.

IR_RecordingMedia 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
RecordingId uniqueidentifier False No

4.0.106.453 4.0 Release
RelatedRecordingId uniqueidentifier True No

4.0.106.453 4.0 Release
MediaURI nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
MediaKey nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
MediaType smallint False No

4.0.106.453 4.0 Release
FileSize int True No

4.0.106.453 4.0 Release
RecordingDate datetime2 False No

4.0.106.453 4.0 Release
RecordingDateOffset int False No

4.0.106.453 4.0 Release
ExpirationDate datetime True No

4.0.106.453 4.0 Release
StartEventCode int False No

4.0.106.453 4.0 Release
Duration int True No

4.0.106.453 4.0 Release
FromConnValue nvarchar (255) True Yes

4.0.106.453 4.0 Release
ToConnValue nvarchar (255) True Yes

4.0.106.453 4.0 Release
MediaStatus nvarchar (56) True No

4.0.106.453 4.0 Release
Direction tinyint True No

4.0.106.453 4.0 Release
QueueObjectIdKey varchar (36) True No

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

4.0.106.453 4.0 Release
ScreenRecordedHostName nvarchar (255) True Depends on customer usage

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

4.0.106.453 4.0 Release
NumAttachments smallint True No

4.0.106.453 4.0 Release
CallType tinyint True No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release
KeywordCustomerScorePositive int True No

4.0.106.453 4.0 Release
KeywordCustomerScoreNegative int True No

4.0.106.453 4.0 Release
KeywordAgentScorePositive int True No

4.0.106.453 4.0 Release
KeywordAgentScoreNegative int True No

4.0.106.453 4.0 Release
IsArchived tinyint False No

4.0.106.453 4.0 Release
RecordingType smallint True No

16.3.0.354 Added for snippet recordings.

IR_RecordingMedia Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_RecordingMedia Clustered RecordingId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_RM_RelatedRecordingId RelatedRecordingId IR_RecordingMedia RecordingId Yes

Index Name Type Column Name (sort order)
IX_IR_RecMedia_ExpirationDate Non-clustered ExpirationDate (Ascending)
IX_IR_RecMedia_KwAgtScorNeg Non-clustered KeywordAgentScoreNegative (Ascending)
IX_IR_RecMedia_KwAgtScorPos Non-clustered KeywordAgentScorePositive (Ascending)
IX_IR_RecMedia_KwCustScorNeg Non-clustered KeywordCustomerScoreNegative (Ascending)
IX_IR_RecMedia_KwCustScorPos Non-clustered KeywordCustomerScorePositive (Ascending)
IX_IR_RecMedia_MediaStatusNull Non-clustered MediaStatus (Ascending)
IX_IR_RecMedia_QObjectIdKey Non-clustered QueueObjectIdKey (Ascending)
IX_IR_RecMedia_RecDate_RecId Non-clustered RecordingDate (Ascending)
RecordingId (Ascending)
IX_IR_RecMedia_RelRecId Non-clustered RelatedRecordingId (Ascending)

IR_RecordingMediaSnippets Table

ID of the policy-based recording and id of snippet recording is stored in IR_RecordingMediaSnippets table.

IR_RecordingMediaSnippets Column Definitions

IR_RecordingMediaSnippets Constraints



IR_RecordingWork Table

IR_RecordingWork table is used to store the session ID returned from previous call to search sproc.

IR_RecordingWork 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
SessionId uniqueidentifier False No

4.0.106.453 4.0 Release
RecordingId uniqueidentifier False No

4.0.106.453 4.0 Release
RecordingDate datetime2 False No

16.3.0.354 Changed data type to DATETIME2 for SQL Server and TIMESTAMP(3) for Oracle to match IR_RecordingMedia.RecordingDate.
FetchStatus tinyint False No

4.0.106.453 4.0 Release

IR_RecordingWork Constraints



Index Name Type Column Name (sort order)
IX_IR_RecWork_RecordingDate Non-clustered RecordingDate (Ascending)
IX_IR_RecWork_RecordingId Non-clustered RecordingId (Ascending)
IX_IR_RecWork_SessionId Non-clustered SessionId (Ascending)

IR_SecurityPolicy Table

IR_SecurityPolicy table.

IR_SecurityPolicy 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
SecurityPolicyId uniqueidentifier False No

16.1.0.378 Added to replace the older way security policies are applied.
ApplySql nvarchar (MAX) True Unknown

16.1.0.378 Added to replace the older way security policies are applied.

IR_SecurityPolicy Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_SecurityPolicy Clustered SecurityPolicyId (Ascending)


IR_Tag Table

Recording tags are stored in IR_Tag table.

IR_Tag 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
TagId int False No

4.0.106.453 4.0 Release
TagName nvarchar (128) False Depends on customer usage

15.4.0.418 Updated size from 80 to 128 to support keyword set name and category for each keyword spot.

IR_Tag Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_Tag Clustered TagId (Ascending)


Index Name Type Column Name (sort order)
IX_IR_Tag_TagName Non-clustered TagName (Ascending)

IR_TagMap Table

Keyword set name of tags are stored in IR_TagMap table.

IR_TagMap 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
RecordingId uniqueidentifier False No

4.0.106.453 4.0 Release
TagId int False No

4.0.106.453 4.0 Release
KeywordSetName nvarchar (128) True Depends on customer usage

4.0.106.453 4.0 Release

IR_TagMap Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_TagMap Clustered RecordingId (Ascending)
TagId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_TagMap_RecordingId RecordingId IR_RecordingMedia RecordingId Yes
FK_IR_TagMap_TagId TagId IR_Tag TagId Yes

Index Name Type Column Name (sort order)
IX_IR_TagMap_TagId Non-clustered TagId (Ascending)

IR_SocialMediaRecording Table

Channel name of the Social Media Recording can be found in IR_SocialMediaRecording table.

IR_SocialMediaRecordingColumn 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
RecordingId uniqueidentifier False No

Recording ID referencing IR_RecordingMedia

 18.4.0.0 Added for social media recordings.
Platform smallint False No

Enumeration of the social media platform

 18.4.0.0 Added for social media recordings
ChannelId nvarchar (128) False No

Channel ID of the Social Media Recording.

 18.4.0.0 Added for social media recordings
ChannelName nvarchar (1024) False No

Channel display name of the social media recording.

 18.4.0.0 Added for social media recordings
Page nvarchar (128) True No

Name of the social media page for this recording.

 18.4.0.0 Added for social media recordings

IR_SocialMediaRecording Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_SocialMediaRecording Clustered RecordingId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_SocialMediaRec_RecId RecordingId IR_RecordingMedia RecordingId Yes

Index Name Type Column Name (sort order)
IX_IR_SocialMediaRec_ChannelId Non-clustered ChannelId (Ascending)
IX_IR_SocialMediaRec_Channel Non-clustered ChannelName (Ascending)
IX_IR_SocialMediaRec_Page Non-clustered Page (Ascending)

GC_InteractionsLog Table

ConversationId is stored in GC_InteractionsLog table.

GC_InteractionsLog 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
InteractionUUID uniqueidentifier False No

Interaction ID.

20.4.0.0 Creation.
ConversationId uniqueidentifier True No

Conversation ID of the interaction.

20.4.0.0 Creation.
StartDatetime datetime False No

UTC start date time of the interaction.

20.4.0.0 Creation.
StartDatetimeOffset smallint False No

Start date time offset in minutes.

20.4.0.0 Creation.

GC_InteractionsLog Constraints

Primary Key Name Type Column Name (sort order)
PK_GC_InteractionsLog Clustered InteractionUUID (Ascending)


Index Name Type Column Name (sort order)
IX_GC_InteractionsLog_ConversationId Non-clustered ConversationId (Ascending)

scoringsummary_viw view

scoringsummary_viw view.

scoringsummary_viw Schema

AnalyzerKeywordHit_viw view

AnalyzerKeywordHit_viw view.

AnalyzerKeywordHit_viw Schema

DeletedRecordings_viw view

DeletedRecordings_viw view.

DeletedRecordings_viw Schema

QuestionnaireDetail_viw view

QuestionnaireDetail_viw view.

QuestionnaireDetail_viw Schema

RecordingDetail_viw view

Line name , media type like GENERIC, CALL, CHAT, EMAIL, FAX, SCREEN etc are shown using RecordingDetail_viw view.

RecordingDetail_viw Schema

RecordingSummary_viw view

Name of the initiation policy that initiated this recording and other recoridng summary information shown using RecordingSummary_viw view.

RecordingSummary_viw Schema

RecordingSummaryAttrs_viw view

RecordingSummaryAttrs_viw view.

RecordingSummaryAttrs_viw Schema

RecordingSummaryScoring_viw view

RecordingSummaryScoring_viw view.

RecordingSummaryScoring_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
RecordingId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
MediaType varchar (7) True Unknown

4.0.106.453 4.0 Release
RecordingDate datetime True Unknown

4.0.106.453 4.0 Release
ExpirationDateUTC datetime True Unknown

4.0.106.453 4.0 Release
StartEventCode int False Unknown

4.0.106.453 4.0 Release
RecordingLength int True Unknown

4.0.106.453 4.0 Release
FromConnValue nvarchar (255) True Unknown

4.0.106.453 4.0 Release
ToConnValue nvarchar (255) True Unknown

4.0.106.453 4.0 Release
Direction tinyint True Unknown

4.0.106.453 4.0 Release
InteractionId varchar (36) True Unknown

4.0.106.453 4.0 Release
InitiationPolicyName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
LineName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ANI nvarchar (255) True Unknown

4.0.106.453 4.0 Release
CallType tinyint True Unknown

4.0.106.453 4.0 Release
NumAttachments smallint True Unknown

4.0.106.453 4.0 Release
RecordedUserIndivId char (22) True Unknown

4.0.106.453 4.0 Release
RecordedUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserDisplayName nvarchar (255) True Unknown

4.0.106.453 4.0 Release
RecordedUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
InitiatedWorkgroup nvarchar (255) True Unknown

4.0.106.453 4.0 Release
HasScreenRecording int False Unknown

4.0.106.453 4.0 Release
NumAssignedQnaires int True Unknown

4.0.106.453 4.0 Release
NumIncompleteQnaires int True Unknown

4.0.106.453 4.0 Release
NumCompleteQnaires int True Unknown

4.0.106.453 4.0 Release
QuestionnaireId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
QuestionnaireName nvarchar (255) False Unknown

4.0.106.453 4.0 Release
QuestionnaireNote nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
QDirectoryName nvarchar (255) True Unknown

4.0.106.453 4.0 Release
ScoredUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserIndivID char (22) True Unknown

4.0.106.453 4.0 Release
ScoringUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserIndivID char (22) True Unknown

4.0.106.453 4.0 Release
FormId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
CombinedMaxScore numeric True Unknown

4.0.106.453 4.0 Release
CombinedMinScore numeric True Unknown

4.0.106.453 4.0 Release
CombinedScore numeric False Unknown

4.0.106.453 4.0 Release
CombinedPercentileScore numeric True Unknown

4.0.106.453 4.0 Release
RankName nvarchar (40) True Unknown

4.0.106.453 4.0 Release
NonCriticalMaxScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalMinScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalPercentileScore numeric True Unknown

4.0.106.453 4.0 Release
TotalNumCriticalQuestions int False Unknown

4.0.106.453 4.0 Release
NumAnsweredCriticalQstns int True Unknown

4.0.106.453 4.0 Release
NumPosAnsweredCriticalQstns int True Unknown

4.0.106.453 4.0 Release
CriticalScore numeric True Unknown

4.0.106.453 4.0 Release
IsFailed tinyint True Unknown

4.0.106.453 4.0 Release
UsingForCalibration tinyint False Unknown

4.0.106.453 4.0 Release

RecordingSummaryTags_viw view

RecordingSummaryTags_viw view.

RecordingSummaryTags_viw Schema

RecordingSummaryTagsAttrs_viw view

RecordingSummaryTagsAttrs_viw view.

RecordingSummaryTagsAttrs_viw Schema

ScoringDetail_viw view

ScoringDetail_viw view.

ScoringDetail_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
RecordingId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
RecordingDate datetime True Unknown

4.0.106.453 4.0 Release
MediaType varchar (7) True Unknown

4.0.106.453 4.0 Release
InteractionIdKey varchar (36) True Unknown

4.0.106.453 4.0 Release
RecordingLength int True Unknown

4.0.106.453 4.0 Release
InitiationPolicyName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
Direction tinyint True Unknown

4.0.106.453 4.0 Release
RecordedUserIndivId char (22) True Unknown

4.0.106.453 4.0 Release
RecordedUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserDisplayName nvarchar (255) True Unknown

4.0.106.453 4.0 Release
RecordedUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
WorkgroupQueue nvarchar (255) True Unknown

4.0.106.453 4.0 Release
QuestionnaireId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
QuestionnaireName nvarchar (255) False Unknown

4.0.106.453 4.0 Release
QuestionnaireNote nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
QuestionnaireMinScore numeric True Unknown

4.0.106.453 4.0 Release
QuestionnaireMaxScore numeric True Unknown

4.0.106.453 4.0 Release
QDirectoryName nvarchar (255) True Unknown

4.0.106.453 4.0 Release
QGroupId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
QGroupSequence int False Unknown

4.0.106.453 4.0 Release
QGroupName nvarchar (255) False Unknown

4.0.106.453 4.0 Release
QGroupNote nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
IsOptional tinyint False Unknown

4.0.106.453 4.0 Release
QuestionId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
QuestionSequence int False Unknown

4.0.106.453 4.0 Release
QuestionText nvarchar (1024) False Unknown

4.0.106.453 4.0 Release
QuestionType smallint False Unknown

4.0.106.453 4.0 Release
QuestionPromptType smallint False Unknown

4.0.106.453 4.0 Release
QuestionWeight numeric False Unknown

4.0.106.453 4.0 Release
QuestionMin numeric False Unknown

4.0.106.453 4.0 Release
QuestionMax numeric False Unknown

4.0.106.453 4.0 Release
QuestionMinAcceptableScore numeric False Unknown

4.0.106.453 4.0 Release
QuestionCanMarkNA tinyint False Unknown

4.0.106.453 4.0 Release
FormId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
ScoredUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserIndivID char (22) True Unknown

4.0.106.453 4.0 Release
ScoringUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserIndivId char (22) True Unknown

4.0.106.453 4.0 Release
CombinedMaxScore numeric True Unknown

4.0.106.453 4.0 Release
CombinedMinScore numeric True Unknown

4.0.106.453 4.0 Release
CombinedScore numeric False Unknown

4.0.106.453 4.0 Release
CombinedPercentileScore numeric True Unknown

4.0.106.453 4.0 Release
RankName nvarchar (40) True Unknown

4.0.106.453 4.0 Release
NonCriticalMaxScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalMinScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalPercentileScore numeric True Unknown

4.0.106.453 4.0 Release
TotalNumCriticalQuestions int False Unknown

4.0.106.453 4.0 Release
NumAnsweredCriticalQstns int True Unknown

4.0.106.453 4.0 Release
NumPosAnsweredCriticalQstns int True Unknown

4.0.106.453 4.0 Release
CriticalScore numeric True Unknown

4.0.106.453 4.0 Release
IsFailed tinyint True Unknown

4.0.106.453 4.0 Release
UsingForCalibration tinyint False Unknown

4.0.106.453 4.0 Release
AnswerScore numeric True Unknown

4.0.106.453 4.0 Release
RawAnswer nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
DisplayAnswer nvarchar (255) True Unknown

4.0.106.453 4.0 Release
UserComments nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
IsMarkedNA tinyint False Unknown

4.0.106.453 4.0 Release

scoringsummary_calltime_viw view

scoringsummary_calltime_viw view.

scoringsummary_calltime_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
RecordingId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
RecordingDate datetime True Unknown

4.0.106.453 4.0 Release
MediaType varchar (7) True Unknown

4.0.106.453 4.0 Release
InteractionIdKey varchar (36) True Unknown

4.0.106.453 4.0 Release
RecordingLength int True Unknown

4.0.106.453 4.0 Release
InitiationPolicyName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
Direction tinyint True Unknown

4.0.106.453 4.0 Release
RecordedUserIndivId char (22) True Unknown

4.0.106.453 4.0 Release
RecordedUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserDisplayName nvarchar (255) True Unknown

4.0.106.453 4.0 Release
RecordedUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
WorkgroupQueue nvarchar (255) True Unknown

4.0.106.453 4.0 Release
QuestionnaireId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
QuestionnaireName nvarchar (255) False Unknown

4.0.106.453 4.0 Release
QuestionnaireNote nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
QDirectoryName nvarchar (255) True Unknown

4.0.106.453 4.0 Release
ScoredUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserIndivID char (22) True Unknown

4.0.106.453 4.0 Release
ScoringUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserIndivId char (22) True Unknown

4.0.106.453 4.0 Release
FormId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
CombinedMaxScore numeric True Unknown

4.0.106.453 4.0 Release
CombinedMinScore numeric True Unknown

4.0.106.453 4.0 Release
CombinedScore numeric False Unknown

4.0.106.453 4.0 Release
CombinedPercentileScore numeric True Unknown

4.0.106.453 4.0 Release
RankName nvarchar (40) True Unknown

4.0.106.453 4.0 Release
NonCriticalMaxScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalMinScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalPercentileScore numeric True Unknown

4.0.106.453 4.0 Release
TotalNumCriticalQuestions int False Unknown

4.0.106.453 4.0 Release
NumAnsweredCriticalQstns int True Unknown

4.0.106.453 4.0 Release
NumPosAnsweredCriticalQstns int True Unknown

4.0.106.453 4.0 Release
CriticalScore numeric True Unknown

4.0.106.453 4.0 Release
IsFailed tinyint True Unknown

4.0.106.453 4.0 Release
UsingForCalibration tinyint False Unknown

4.0.106.453 4.0 Release
SiteId int True Unknown

4.0.106.453 4.0 Release
ConnectedTime numeric True Unknown

4.0.106.453 4.0 Release
HoldTime numeric True Unknown

4.0.106.453 4.0 Release
TalkTime numeric True Unknown

4.0.106.453 4.0 Release

IR_AccessControl_viw view

IR_AccessControl_viw view.

IR_AccessControl_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
RecordingId uniqueidentifier (16) False No

ID of the recording.

 17.4.0.0 Added for data extraction from IR_AccessControl table.
SecurityPolicyId uniqueidentifier (16) False No

ID of the security policy.

 17.4.0.0 Added for data extraction from IR_AccessControl table.
RecordingDate datetime2 (8) False No

Time the recording was made.

 17.4.0.0 Added for data extraction from IR_AccessControl table.

IR_ArchiveContent_viw view

IR_ArchiveContent_viw view.

IR_ArchiveContent_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
RecordingId uniqueidentifier (16) False No

ID of the recording.

 17.4.0.0 Added for data extraction from IR_ArchiveContent table.
ArchiveId uniqueidentifier (16) False No

ID of the archive volume.

 17.4.0.0 Added for data extraction from IR_ArchiveContent table.
ArchivedDate datetime (8) False No

Date that the recording was archived.

 17.4.0.0 Added for data extraction from IR_ArchiveContent table.
ArchivedDateOffset int (4) False No

UTC offset of the archive date.

 17.4.0.0 Added for data extraction from IR_ArchiveContent table.
RecordingDate datetime2 (8) False No

Time the recording was made.

 17.4.0.0 Added for data extraction from IR_ArchiveContent table.

IR_CustomAttribute_viw view

IR_CustomAttribute_viw view.

IR_CustomAttribute_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
RecordingId uniqueidentifier (16) False No

ID of the recording who's interaction had the value.

 17.4.0.0 Added for data extraction from IR_CustomAttribute table.
CustomAttributeNameId int (4) False No

ID of the name of the custom attribute. Each name is stored uniquely in the IR_CustomAttributeName table.

 17.4.0.0 Added for data extraction from IR_CustomAttribute table.
Value nvarchar (255) False Depends on customer usage

Value of the attribute.

 17.4.0.0 Added for data extraction from IR_CustomAttribute table.
Version int (4) False No

Version of the database row.

 17.4.0.0 Added for data extraction from IR_CustomAttribute table.
RecordingDate datetime2 (8) False No

Time the recording was made.

 17.4.0.0 Added for data extraction from IR_CustomAttribute table.

IR_QAnswer_viw view

IR_QAnswer_viw view.

IR_QAnswer_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
QAnswerId uniqueidentifier (16) False No

ID of the answer.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
QFormId uniqueidentifier (16) False No

ID of the form that contains this answer.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
QQuestionId uniqueidentifier (16) False No

ID of the question that was answered.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
Sequence int (4) False No

Sequence number of the answer within the form.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
Score numeric (9) True No

Score given to the answer.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
RawAnswer nvarchar (1024) True Depends on customer usage

Raw text input of the answer.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
UserComments nvarchar (1024) True Depends on customer usage

Comments provided with the answer.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
IsMarkedNA tinyint (1) False No

Was the answer marked N/A? One if true else zero.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
Version int (4) False No

Version of the database row.

 17.4.0.0 Added for data extraction from IR_QAnswer table.
RecordingDate datetime2 (8) False No

Time the recording was made.

 17.4.0.0 Added for data extraction from IR_QAnswer table.

IR_QForm_viw view

IR_QForm_viw view.

IR_QForm_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
QFormId uniqueidentifier (16) False No

ID of the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
QuestionnaireId uniqueidentifier (16) False No

ID of the questionnaire this form provides answers to.

 17.4.0.0 Added for data extraction from IR_QForm table.
RecordingId uniqueidentifier (16) True No

ID of the recording that this form refers to.

 17.4.0.0 Added for data extraction from IR_QForm table.
ScoringIndivId char (22) True Yes

Individual ID of the user who is scoring the recording.

 17.4.0.0 Added for data extraction from IR_QForm table.
TargetIndivId char (22) True Yes

Individual ID of the user being scored.

 17.4.0.0 Added for data extraction from IR_QForm table.
TargetIntx_Part_Id char (22) True Yes

Participant ID on the interaction of the user being scored.

 17.4.0.0 Added for data extraction from IR_QForm table.
ScoringState int (4) False No

Scoring state of the form.

  • 0 - None. Scoring has not yet started.
  • 1 - Assigned. Questionnaire Scorecard has been assigned but not started.
  • 2 - Incomplete. Questionnaire Scorecard has been saved but not finished.
  • 3 - Finished.
 17.4.0.0 Added for data extraction from IR_QForm table.
Score numeric (9) False No

Total score of the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
RankName nvarchar (40) True Depends on customer usage

Name of the rank given to the form based on it's score.

 17.4.0.0 Added for data extraction from IR_QForm table.
MaxScore numeric (9) True No

Maximum score of all answers scored for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
MinScore numeric (9) True No

Minimum score of all answers scored for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
ScoringDate datetime (8) True No

Time the form was last scored and saved.

 17.4.0.0 Added for data extraction from IR_QForm table.
ScoringDateOffset int (4) True No

UTC offset of the scoring date.

 17.4.0.0 Added for data extraction from IR_QForm table.
AssignedDesc nvarchar (1024) True Depends on customer usage

Name of the Recorder Policy that caused the form to be assigned.

 17.4.0.0 Added for data extraction from IR_QForm table.
NonCriticalMaxScore numeric (9) True No

Total maximum score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
NonCriticalMinScore numeric (9) True No

Total minimum score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
NonCriticalScore numeric (9) True No

Total score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
CriticalAccuracyScore numeric (9) True No

Stores the critical accuracy percentage (0.00 to 100.00) of positively answered critical questions divided by the total number of critical questions answered within a scorecard.

 17.4.0.0 Added for data extraction from IR_QForm table.
NumAnsweredCriticalQstns int (4) True No

Number of critical questions answered.

 17.4.0.0 Added for data extraction from IR_QForm table.
NumPosAnsweredCriticalQstns int (4) True No

Number of positively answered critical questions.

 17.4.0.0 Added for data extraction from IR_QForm table.
IsFailed tinyint (1) True No

Indicates whether the scorecard has been marked Pass or Fail. NULL for non-pass/fail questionnaires.

  • NULL - Not marked passed or failed. Either the questionnaire is not pass/fail or the scorecard has not been finished.
  • 0 - Scorecard passed.
  • 1 - Scorecard failed.
 17.4.0.0 Added for data extraction from IR_QForm table.
UsingForCalibration tinyint (1) False No

Was this form used for calibration.

 17.4.0.0 Added for data extraction from IR_QForm table.
SignoffState tinyint (1) True No

State of the sign-off process.

  • NULL - Sign-off process has not yet started.
  • 0 - Sign-off process is in progress.
  • 1 - Sign-off process has completed.
 17.4.0.0 Added for data extraction from IR_QForm table.
SignoffComments nvarchar (2000) True Depends on customer usage

Comments about the sign-off.

 17.4.0.0 Added for data extraction from IR_QForm table.
Version int (4) False No

Version of the database row.

 17.4.0.0 Added for data extraction from IR_QForm table.
RecordingDate datetime2 (8) False No

Time the recording was made.

 17.4.0.0 Added for data extraction from IR_QForm table.

IR_RecordingMediaSnippets_viw view

IR_RecordingMediaSnippets_viw view.

IR_RecordingMediaSnippets_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
SnippetRecordingId uniqueidentifier (16) False No

ID of the snippet recording.

 17.4.0.0 Added for data extraction from IR_RecordingMediaSnippets table.
PolicyRecordingId uniqueidentifier (16) False No

ID of the policy-based recording.

 17.4.0.0 Added for data extraction from IR_RecordingMediaSnippets table.
RecordingDate datetime2 (8) False No

Time the recording was made.

 17.4.0.0 Added for data extraction from IR_RecordingMediaSnippets table.

CRScoringDetail_viw view

CRScoringDetail_viw view.

CRScoringDetail_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
RecordingId uniqueidentifier False Unknown

ID of the recording that this form refers to

 17.4.0.0 New View for crystal report
RecordingDate datetime True Unknown

Time the recording was made

 17.4.0.0 New View for crystal report
MediaType varchar (7) True Unknown

Media type of recording:

  • 0 - GENERIC
  • 1 - CALL
  • 2 - CHAT
  • 3 - EMAIL
  • 4 - FAX
  • 5 - SCREEN
  • 6 - CHAT TRANSCRIPT
17.4.0.0 New View for crystal report
InteractionIdKey varchar (36) True Unknown

ID of the interaction of this recording

 17.4.0.0 New View for crystal report
RecordingLength int True Unknown

Duration of the recording in milliseconds

 17.4.0.0 New View for crystal report
InitiationPolicyName nvarchar (50) True Unknown

Name of the initiation policy that initiated this recording

 17.4.0.0 New View for crystal report
Direction tinyint True Unknown

Direction of the interaction.

  • 0 - Invalid
  • 1 - Inbound
  • 2 - Outbound
  • 3 - Intercom
  • 4 - Unknown
17.4.0.0 New View for crystal report
RecordedUserIndivId char (22) True Unknown

Recorded User Individual ID

 17.4.0.0 New View for crystal report
RecordedUserLastName nvarchar (50) True Unknown

Recorded User Last Name

 17.4.0.0 New View for crystal report
RecordedUserFirstName nvarchar (50) True Unknown

Recorded User First Name

 17.4.0.0 New View for crystal report
RecordedUserMiddleName nvarchar (50) True Unknown

Recorded User Middle Name

 17.4.0.0 New View for crystal report
RecordedUserDisplayName nvarchar (255) True Unknown

Recorded User Display Name

 17.4.0.0 New View for crystal report
RecordedUserICUserId nvarchar (50) True Unknown

Recorded User ID

 17.4.0.0 New View for crystal report
WorkgroupQueue nvarchar (255) True Unknown

Work Group Queue

 17.4.0.0 New View for crystal report
QuestionnaireId uniqueidentifier False Unknown

Questionnaire ID

 17.4.0.0 New View for crystal report
QuestionnaireName nvarchar (255) False Unknown

Questionnaire Name

 17.4.0.0 New View for crystal report
QuestionnaireNote nvarchar (1024) True Unknown

Questionnaire Note

 17.4.0.0 New View for crystal report
QuestionnaireMinScore numeric True Unknown

Minimum score of Questionnaire

 17.4.0.0 New View for crystal report
QuestionnaireMaxScore numeric True Unknown

Maximum score of Questionnaire

 17.4.0.0 New View for crystal report
QDirectoryName nvarchar (255) True Unknown

Directory Name

 17.4.0.0 New View for crystal report
QGroupId uniqueidentifier False Unknown

Group ID

 17.4.0.0 New View for crystal report
QGroupSequence int False Unknown

Group Sequence

 17.4.0.0 New View for crystal report
QGroupName nvarchar (255) False Unknown

Question Group Name

 17.4.0.0 New View for crystal report
QGroupNote nvarchar (1024) True Unknown

Question Group Note

 17.4.0.0 New View for crystal report
IsOptional tinyint False Unknown

Is Optional

 17.4.0.0 New View for crystal report
QuestionId uniqueidentifier False Unknown

Question ID

 17.4.0.0 New View for crystal report
QuestionSequence int False Unknown

Question Sequence

 17.4.0.0 New View for crystal report
QuestionText nvarchar (1024) False Unknown

Question Text

 17.4.0.0 New View for crystal report
QuestionType smallint False Unknown

Question Type

 17.4.0.0 New View for crystal report
QuestionPromptType smallint False Unknown

Importance of the question

 17.4.0.0 New View for crystal report
QuestionWeight numeric False Unknown

Weight of Question

 17.4.0.0 New View for crystal report
QuestionMin numeric False Unknown

Minimum Score given to a question

 17.4.0.0 New View for crystal report
QuestionMax numeric False Unknown

Maximum Score given to a question

 17.4.0.0 New View for crystal report
QuestionMinAcceptableScore numeric False Unknown

Minimum Acceptable score of a question

 17.4.0.0 New View for crystal report
QuestionCanMarkNA tinyint False Unknown

Flag to specify whether the question can be marked as N/A

 17.4.0.0 New View for crystal report
FormId uniqueidentifier False Unknown

Form ID

 17.4.0.0 New View for crystal report
ScoredUserLastName nvarchar (50) True Unknown

Scored User Last Name

 17.4.0.0 New View for crystal report
ScoredUserFirstName nvarchar (50) True Unknown

Scored User First Name

 17.4.0.0 New View for crystal report
ScoredUserMiddleName nvarchar (50) True Unknown

Scored User Middle Name

 17.4.0.0 New View for crystal report
ScoredUserICUserId nvarchar (50) True Unknown

Scored UserID

 17.4.0.0 New View for crystal report
ScoredUserIndivID char (22) True Unknown

Scored User IndividualID

 17.4.0.0 New View for crystal report
ScoringUserLastName nvarchar (50) True Unknown

Scoring User Last Name

 17.4.0.0 New View for crystal report
ScoringUserFirstName nvarchar (50) True Unknown

Scoring User First Name

 17.4.0.0 New View for crystal report
ScoringUserMiddleName nvarchar (50) True Unknown

Scoring User Middle Name

 17.4.0.0 New View for crystal report
ScoringUserICUserId nvarchar (50) True Unknown

Scoring UserID

 17.4.0.0 New View for crystal report
ScoringUserIndivId char (22) True Unknown

Scoring User IndividualID

 17.4.0.0 New View for crystal report
CombinedMaxScore numeric True Unknown

Combined Maximum Score

 17.4.0.0 New View for crystal report
CombinedMinScore numeric True Unknown

Combined Minimum Score

 17.4.0.0 New View for crystal report
CombinedScore numeric False Unknown

Combined Score

 17.4.0.0 New View for crystal report
CombinedPercentileScore numeric True Unknown

Combined Percentile Score of User

 17.4.0.0 New View for crystal report
RankName nvarchar (40) True Unknown

Rank Name of User

 17.4.0.0 New View for crystal report
NonCriticalMaxScore numeric True Unknown

Noncritical Maximum Score of the User

 17.4.0.0 New View for crystal report
NonCriticalMinScore numeric True Unknown

Noncritical minimum Score of the User

 17.4.0.0 New View for crystal report
NonCriticalScore numeric True Unknown

Noncritical Score of the User

 17.4.0.0 New View for crystal report
NonCriticalPercentileScore numeric True Unknown

Noncritical Percentile Score

 17.4.0.0 New View for crystal report
TotalNumCriticalQuestions int False Unknown

Total number of Critical Questions

 17.4.0.0 New View for crystal report
NumAnsweredCriticalQstns int True Unknown

Number of Answered Critical Questions

 17.4.0.0 New View for crystal report
NumPosAnsweredCriticalQstns int True Unknown

Number of positively answered critical questions

 17.4.0.0 New View for crystal report
CriticalScore numeric True Unknown

Critical Score of the User

 17.4.0.0 New View for crystal report
IsFailed tinyint True Unknown

Flag to display whether the user is passed or failed

 17.4.0.0 New View for crystal report
UsingForCalibration tinyint False Unknown

Flag to display whether the scorecard is marked for Calibration or not

 17.4.0.0 New View for crystal report
AnswerScore numeric True Unknown

Score of the given answer

 17.4.0.0 New View for crystal report
RawAnswer nvarchar (1024) True Unknown

Raw Answer of question

 17.4.0.0 New View for crystal report
DisplayAnswer nvarchar (255) True Unknown

Display answer for the question

 17.4.0.0 New View for crystal report
UserComments nvarchar (1024) True Unknown

User Comments

 17.4.0.0 New View for crystal report
IsMarkedNA tinyint False Unknown

Flag to determine whether Question is marked as N/A or not

 17.4.0.0 New View for crystal report
QDirectoryId uniqueidentifier False No

Directory ID

 17.4.0.0 New View for crystal report