PureConnect Reporting Data Dictionary

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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
ArchiveId	raw (16)	False	No	4.0.106.453	4.0 Release
VolumeName	nvarchar2 (128)	False	Depends on customer usage	4.0.106.453	4.0 Release
VolumeDT	timestamp	False	No	4.0.106.453	4.0 Release
VolumeDTOffset	integer	False	No	4.0.106.453	4.0 Release
ArchiveStartDT	timestamp	True	No	4.0.106.453	4.0 Release
ArchiveEndDT	timestamp	True	No	4.0.106.453	4.0 Release
MediaURI	nvarchar2 (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)

Primary Key Name	Column Name (sort order)
PK_IR_ArchiveVolumeDescriptor	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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
AuditId	raw (16)	False	No	4.0.106.453	4.0 Release
Id	raw (16)	False	No	4.0.106.453	4.0 Release
AuditDate	date	False	No	4.0.106.453	4.0 Release
AuditDateOffset	integer	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	nvarchar2 (255)	True	Yes	4.0.106.453	4.0 Release
AuditedName	nvarchar2 (255)	True	Yes	4.0.106.453	4.0 Release
Comments	nvarchar2 (1024)	True	Depends on customer usage	4.0.106.453	4.0 Release
Version	integer	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)

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

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

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)

Index Name	Column Name (sort order)
IX_IR_Audit_AuditOperation	AuditOperation (Ascending)
IX_IR_Audit_Id	Id (Ascending)
IX_IR_Audit_IndivId	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

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	integer	False	No		4.0.106.453	4.0 Release
Name	nvarchar2 (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)

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

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

Index Name	Column Name (sort order)
IX_IR_CustomAttributeName_Name	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	Last Change Version	Last Change Reason
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	Last Change Version	Last Change Reason
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

IR_Event Constraints

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)

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

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
KeywordSetId	integer	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)

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

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)

Index Name	Column Name (sort order)
IX_IR_EVTKEYWORDINFO_KWSID	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

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	integer	False	No		4.0.106.453	4.0 Release
KeywordName	nvarchar2 (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)

Primary Key Name	Column Name (sort order)
PK_IR_Keyword	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	Last Change Version	Last Change Reason
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.

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
KeywordSetId	integer	False	No	15.4.0.418	Added to store keyword set and category assiociated with each keyword spot.
DisplayName	nvarchar2 (128)	False	Depends on customer usage	15.4.0.418	Added to store keyword set and category assiociated with each keyword spot.
Category	nvarchar2 (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)

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

Index Name	Column Name (sort order)
IX_IR_KeywordSet_Category	Category (Ascending)
IX_IR_KeywordSet_DisplayName	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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
QDirectoryId	raw (16)	False	No	4.0.106.453	4.0 Release
QDirectoryName	nvarchar2 (255)	True	Depends on customer usage	4.0.106.453	4.0 Release
Note	nvarchar2 (1024)	True	Depends on customer usage	4.0.106.453	4.0 Release
IsTemplate	smallint	False	No	4.0.106.453	4.0 Release
Version	integer	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)

Primary Key Name	Column Name (sort order)
PK_IR_QDirectory	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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
QGroupId	raw (16)	False	No	4.0.106.453	4.0 Release
QuestionnaireId	raw (16)	True	No	4.0.106.453	4.0 Release
GroupName	nvarchar2 (255)	False	Depends on customer usage	4.0.106.453	4.0 Release
Sequence	integer	False	No	4.0.106.453	4.0 Release
Note	nvarchar2 (1024)	True	Depends on customer usage	4.0.106.453	4.0 Release
IsOptional	smallint	False	No	4.0.106.453	4.0 Release
IsTemplate	smallint	False	No	4.0.106.453	4.0 Release
Version	integer	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)

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

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

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)

Index Name	Column Name (sort order)
IX_IR_QGroup_QuestionnaireId	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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
QQuestionId	raw (16)	False	No	4.0.106.453	4.0 Release
QGroupId	raw (16)	True	No	4.0.106.453	4.0 Release
QuestionText	nvarchar2 (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	nvarchar2 (1024)	True	Depends on customer usage	4.0.106.453	4.0 Release
Weight	number	False	No	4.0.106.453	4.0 Release
Sequence	integer	False	No	4.0.106.453	4.0 Release
MaxScore	number	False	No	4.0.106.453	4.0 Release
MinScore	number	False	No	4.0.106.453	4.0 Release
MinAcceptableScore	number	False	No	4.0.106.453	4.0 Release
Note	nvarchar2 (1024)	True	Depends on customer usage	4.0.106.453	4.0 Release
IsTemplate	smallint	False	No	4.0.106.453	4.0 Release
HasCommentField	smallint	False	No	4.0.106.453	4.0 Release
CanMarkNA	smallint	False	No	4.0.106.453	4.0 Release
Version	integer	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)

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

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

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)

Index Name	Column Name (sort order)
IX_IR_QQuestion_QGroupId	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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
QQuestionId	raw (16)	False	No	4.0.106.453	4.0 Release
Sequence	integer	False	No	4.0.106.453	4.0 Release
EnumText	nvarchar2 (255)	False	Depends on customer usage	4.0.106.453	4.0 Release
HelpText	nvarchar2 (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	integer	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)

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

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

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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
QuestionnaireId	raw (16)	False	No	4.0.106.453	4.0 Release
QDirectoryId	raw (16)	True	No	4.0.106.453	4.0 Release
QuestionnaireName	nvarchar2 (255)	False	Depends on customer usage	4.0.106.453	4.0 Release
RankGroupId	raw (16)	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	nvarchar2 (1024)	True	Depends on customer usage	4.0.106.453	4.0 Release
IsTemplate	smallint	False	No	4.0.106.453	4.0 Release
IsLocked	smallint	False	No	4.0.106.453	4.0 Release
ShowRankWhileScoring	smallint	False	No	4.0.106.453	4.0 Release
TotalNumCriticalQuestions	integer	False	No	4.0.106.453	4.0 Release
Version	integer	False	No	4.0.106.453	4.0 Release
IsActive	smallint	False	No	4.0.106.453	4.0 Release
ShowPassFailWhileScoring	smallint	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)

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

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

IR_RankDefn Table

IR_RankDefn table.

IR_RankDefn Column Definitions

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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
RankId	raw (16)	False	No	4.0.106.453	4.0 Release
RankGroupId	raw (16)	False	No	4.0.106.453	4.0 Release
RankName	nvarchar2 (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	integer	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)

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

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

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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
RankGroupId	raw (16)	False	No	4.0.106.453	4.0 Release
GroupName	nvarchar2 (60)	False	Depends on customer usage	4.0.106.453	4.0 Release
Version	integer	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)

Primary Key Name	Column Name (sort order)
PK_IR_RankGroup	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	Last Change Version	Last Change Reason
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.

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
RecordingId	raw (16)	False	No	4.0.106.453	4.0 Release
RelatedRecordingId	raw (16)	True	No	4.0.106.453	4.0 Release
MediaURI	nvarchar2 (1024)	True	Depends on customer usage	4.0.106.453	4.0 Release
MediaKey	nvarchar2 (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	integer	True	No	4.0.106.453	4.0 Release
RecordingDate	timestamp	False	No	4.0.106.453	4.0 Release
RecordingDateOffset	integer	False	No	4.0.106.453	4.0 Release
ExpirationDate	date	True	No	4.0.106.453	4.0 Release
StartEventCode	integer	False	No	4.0.106.453	4.0 Release
Duration	integer	True	No	4.0.106.453	4.0 Release
FromConnValue	nvarchar2 (255)	True	Yes	4.0.106.453	4.0 Release
ToConnValue	nvarchar2 (255)	True	Yes	4.0.106.453	4.0 Release
MediaStatus	nvarchar2 (56)	True	No	4.0.106.453	4.0 Release
Direction	smallint	True	No	4.0.106.453	4.0 Release
QueueObjectIdKey	varchar2 (36)	True	No	4.0.106.453	4.0 Release
InitiationPolicyName	nvarchar2 (50)	True	Depends on customer usage	4.0.106.453	4.0 Release
ScreenRecordedHostName	nvarchar2 (255)	True	Depends on customer usage	4.0.106.453	4.0 Release
LineName	nvarchar2 (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	smallint	True	No	4.0.106.453	4.0 Release
Version	integer	False	No	4.0.106.453	4.0 Release
KeywordCustomerScorePositive	integer	True	No	4.0.106.453	4.0 Release
KeywordCustomerScoreNegative	integer	True	No	4.0.106.453	4.0 Release
KeywordAgentScorePositive	integer	True	No	4.0.106.453	4.0 Release
KeywordAgentScoreNegative	integer	True	No	4.0.106.453	4.0 Release
IsArchived	smallint	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)

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

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

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)

Index Name	Column Name (sort order)
IX_IR_RecMedia_ExpirationDate	ExpirationDate (Ascending)
IX_IR_RecMedia_KwAgtScorNeg	KeywordAgentScoreNegative (Ascending)
IX_IR_RecMedia_KwAgtScorPos	KeywordAgentScorePositive (Ascending)
IX_IR_RecMedia_KwCustScorNeg	KeywordCustomerScoreNegative (Ascending)
IX_IR_RecMedia_KwCustScorPos	KeywordCustomerScorePositive (Ascending)
IX_IR_RecMedia_MediaStatusNull	MediaStatus (Ascending)
IX_IR_RecMedia_QObjectIdKey	QueueObjectIdKey (Ascending)
IX_IR_RecMedia_RecDate_RecId	RecordingDate (Ascending) RecordingId (Ascending)
IX_IR_RecMedia_RelRecId	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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
SessionId	raw (16)	False	No	4.0.106.453	4.0 Release
RecordingId	raw (16)	False	No	4.0.106.453	4.0 Release
RecordingDate	timestamp	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	smallint	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)

Index Name	Column Name (sort order)
IX_IR_RecWork_RecordingDate	RecordingDate (Ascending)
IX_IR_RecWork_RecordingId	RecordingId (Ascending)
IX_IR_RecWork_SessionId	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.

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	raw (16)	False	No		16.1.0.378	Added to replace the older way security policies are applied.
ApplySql	nclob	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)

Primary Key Name	Column Name (sort order)
PK_IR_SecurityPolicy	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.

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	integer	False	No		4.0.106.453	4.0 Release
TagName	nvarchar2 (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)

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

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

Index Name	Column Name (sort order)
IX_IR_Tag_TagName	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	Last Change Version	Last Change Reason
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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
RecordingId	raw (16)	False	No	4.0.106.453	4.0 Release
TagId	integer	False	No	4.0.106.453	4.0 Release
KeywordSetName	nvarchar2 (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)

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

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)

Index Name	Column Name (sort order)
IX_IR_TagMap_TagId	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
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

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
RecordingId	raw (16)	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	nvarchar2 (128)	False	No	Channel ID of the Social Media Recording.	18.4.0.0	Added for social media recordings.
ChannelName	nvarchar2 (1024)	False	No	Channel display name of the social media recording.	18.4.0.0	Added for social media recordings.
Page	nvarchar2 (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)

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

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

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)

Index Name	Column Name (sort order)
IX_IR_SocialMediaRec_ChannelId	ChannelId (Ascending)
IX_IR_SocialMediaRec_Channel	ChannelName (Ascending)
IX_IR_SocialMediaRec_Page	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
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.

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
InteractionUUID	raw (16)	False	No	Interaction ID.	20.4.0.0	Creation.
ConversationId	raw (16)	True	No	IDS_GC_INTERACTIONS_LOG_INTERACTIONUUID_LD_RESID20867	20.4.0.0	Creation.
StartDatetime	timestamp	False	No	UTC start date time of the interaction.	20.4.0.0	Creation.
StartDatetimeOffset	integer	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)

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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
RecordingId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
MediaType	varchar2 (7)	True	Unknown	4.0.106.453	4.0 Release
RecordingDate	date	True	Unknown	4.0.106.453	4.0 Release
ExpirationDateUTC	date	True	Unknown	4.0.106.453	4.0 Release
StartEventCode	number	False	Unknown	4.0.106.453	4.0 Release
RecordingLength	number	True	Unknown	4.0.106.453	4.0 Release
FromConnValue	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
ToConnValue	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
Direction	number	True	Unknown	4.0.106.453	4.0 Release
InteractionId	varchar2 (36)	True	Unknown	4.0.106.453	4.0 Release
InitiationPolicyName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
LineName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ANI	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
CallType	number	True	Unknown	4.0.106.453	4.0 Release
NumAttachments	number	True	Unknown	4.0.106.453	4.0 Release
RecordedUserIndivId	char (22)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserDisplayName	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
InitiatedWorkgroup	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
HasScreenRecording	number	True	Unknown	4.0.106.453	4.0 Release
NumAssignedQnaires	number	True	Unknown	4.0.106.453	4.0 Release
NumIncompleteQnaires	number	True	Unknown	4.0.106.453	4.0 Release
NumCompleteQnaires	number	True	Unknown	4.0.106.453	4.0 Release
QuestionnaireId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
QuestionnaireName	nvarchar2 (255)	False	Unknown	4.0.106.453	4.0 Release
QuestionnaireNote	nvarchar2 (1024)	True	Unknown	4.0.106.453	4.0 Release
QDirectoryName	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserIndivID	char (22)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserIndivID	char (22)	True	Unknown	4.0.106.453	4.0 Release
FormId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
CombinedMaxScore	number	True	Unknown	4.0.106.453	4.0 Release
CombinedMinScore	number	True	Unknown	4.0.106.453	4.0 Release
CombinedScore	number	False	Unknown	4.0.106.453	4.0 Release
CombinedPercentileScore	number	True	Unknown	4.0.106.453	4.0 Release
RankName	nvarchar2 (40)	True	Unknown	4.0.106.453	4.0 Release
NonCriticalMaxScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalMinScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalPercentileScore	number	True	Unknown	4.0.106.453	4.0 Release
TotalNumCriticalQuestions	number	False	Unknown	4.0.106.453	4.0 Release
NumAnsweredCriticalQstns	number	True	Unknown	4.0.106.453	4.0 Release
NumPosAnsweredCriticalQstns	number	True	Unknown	4.0.106.453	4.0 Release
CriticalScore	number	True	Unknown	4.0.106.453	4.0 Release
IsFailed	number	True	Unknown	4.0.106.453	4.0 Release
UsingForCalibration	number	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	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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
RecordingId	raw (16)	True	Unknown	4.0.106.453	4.0 Release
RecordingDate	date	True	Unknown	4.0.106.453	4.0 Release
MediaType	varchar2 (7)	True	Unknown	4.0.106.453	4.0 Release
InteractionIdKey	varchar2 (36)	True	Unknown	4.0.106.453	4.0 Release
RecordingLength	number	True	Unknown	4.0.106.453	4.0 Release
InitiationPolicyName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
Direction	number	True	Unknown	4.0.106.453	4.0 Release
RecordedUserIndivId	char (22)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserDisplayName	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
WorkgroupQueue	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
QuestionnaireId	raw (16)	True	Unknown	4.0.106.453	4.0 Release
QuestionnaireName	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
QuestionnaireNote	nvarchar2 (1024)	True	Unknown	4.0.106.453	4.0 Release
QuestionnaireMinScore	number	True	Unknown	4.0.106.453	4.0 Release
QuestionnaireMaxScore	number	True	Unknown	4.0.106.453	4.0 Release
QDirectoryName	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
QGroupId	raw (16)	True	Unknown	4.0.106.453	4.0 Release
QGroupSequence	number	True	Unknown	4.0.106.453	4.0 Release
QGroupName	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
QGroupNote	nvarchar2 (1024)	True	Unknown	4.0.106.453	4.0 Release
IsOptional	number	True	Unknown	4.0.106.453	4.0 Release
QuestionId	raw (16)	True	Unknown	4.0.106.453	4.0 Release
QuestionSequence	number	True	Unknown	4.0.106.453	4.0 Release
QuestionText	nvarchar2 (1024)	True	Unknown	4.0.106.453	4.0 Release
QuestionType	number	True	Unknown	4.0.106.453	4.0 Release
QuestionPromptType	number	True	Unknown	4.0.106.453	4.0 Release
QuestionWeight	number	True	Unknown	4.0.106.453	4.0 Release
QuestionMin	number	True	Unknown	4.0.106.453	4.0 Release
QuestionMax	number	True	Unknown	4.0.106.453	4.0 Release
QuestionMinAcceptableScore	number	True	Unknown	4.0.106.453	4.0 Release
QuestionCanMarkNA	number	True	Unknown	4.0.106.453	4.0 Release
FormId	raw (16)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserIndivID	char (22)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserIndivId	char (22)	True	Unknown	4.0.106.453	4.0 Release
CombinedMaxScore	number	True	Unknown	4.0.106.453	4.0 Release
CombinedMinScore	number	True	Unknown	4.0.106.453	4.0 Release
CombinedScore	number	True	Unknown	4.0.106.453	4.0 Release
CombinedPercentileScore	number	True	Unknown	4.0.106.453	4.0 Release
RankName	nvarchar2 (40)	True	Unknown	4.0.106.453	4.0 Release
NonCriticalMaxScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalMinScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalPercentileScore	number	True	Unknown	4.0.106.453	4.0 Release
TotalNumCriticalQuestions	number	True	Unknown	4.0.106.453	4.0 Release
NumAnsweredCriticalQstns	number	True	Unknown	4.0.106.453	4.0 Release
NumPosAnsweredCriticalQstns	number	True	Unknown	4.0.106.453	4.0 Release
CriticalScore	number	True	Unknown	4.0.106.453	4.0 Release
IsFailed	number	True	Unknown	4.0.106.453	4.0 Release
UsingForCalibration	number	True	Unknown	4.0.106.453	4.0 Release
AnswerScore	number	True	Unknown	4.0.106.453	4.0 Release
RawAnswer	nvarchar2 (1024)	True	Unknown	4.0.106.453	4.0 Release
DisplayAnswer	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
UserComments	nvarchar2 (1024)	True	Unknown	4.0.106.453	4.0 Release
IsMarkedNA	number	True	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	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

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
RecordingId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
RecordingDate	date	True	Unknown	4.0.106.453	4.0 Release
MediaType	varchar2 (7)	True	Unknown	4.0.106.453	4.0 Release
InteractionIdKey	varchar2 (36)	True	Unknown	4.0.106.453	4.0 Release
RecordingLength	number	True	Unknown	4.0.106.453	4.0 Release
InitiationPolicyName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
Direction	number	True	Unknown	4.0.106.453	4.0 Release
RecordedUserIndivId	char (22)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserDisplayName	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
RecordedUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
WorkgroupQueue	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
QuestionnaireId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
QuestionnaireName	nvarchar2 (255)	False	Unknown	4.0.106.453	4.0 Release
QuestionnaireNote	nvarchar2 (1024)	True	Unknown	4.0.106.453	4.0 Release
QDirectoryName	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoredUserIndivID	char (22)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserLastName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserFirstName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserMiddleName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserICUserId	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ScoringUserIndivId	char (22)	True	Unknown	4.0.106.453	4.0 Release
FormId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
CombinedMaxScore	number	True	Unknown	4.0.106.453	4.0 Release
CombinedMinScore	number	True	Unknown	4.0.106.453	4.0 Release
CombinedScore	number	False	Unknown	4.0.106.453	4.0 Release
CombinedPercentileScore	number	True	Unknown	4.0.106.453	4.0 Release
RankName	nvarchar2 (40)	True	Unknown	4.0.106.453	4.0 Release
NonCriticalMaxScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalMinScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalScore	number	True	Unknown	4.0.106.453	4.0 Release
NonCriticalPercentileScore	number	True	Unknown	4.0.106.453	4.0 Release
TotalNumCriticalQuestions	number	False	Unknown	4.0.106.453	4.0 Release
NumAnsweredCriticalQstns	number	True	Unknown	4.0.106.453	4.0 Release
NumPosAnsweredCriticalQstns	number	True	Unknown	4.0.106.453	4.0 Release
CriticalScore	number	True	Unknown	4.0.106.453	4.0 Release
IsFailed	number	True	Unknown	4.0.106.453	4.0 Release
UsingForCalibration	number	False	Unknown	4.0.106.453	4.0 Release
SiteId	number	True	Unknown	4.0.106.453	4.0 Release
ConnectedTime	number	True	Unknown	4.0.106.453	4.0 Release
HoldTime	number	True	Unknown	4.0.106.453	4.0 Release
TalkTime	number	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.

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
RECORDINGID	raw (16)	False	No	ID of the recording.	17.4.0.0	Added for data extraction from IR_AccessControl table.
SECURITYPOLICYID	raw (16)	False	No	ID of the security policy.	17.4.0.0	Added for data extraction from IR_AccessControl table.
RECORDINGDATE	timestamp (11)	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.

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
RECORDINGID	raw (16)	False	No	ID of the recording.	17.4.0.0	Added for data extraction from IR_ArchiveContent table.
ARCHIVEID	raw (16)	False	No	ID of the archive volume.	17.4.0.0	Added for data extraction from IR_ArchiveContent table.
ARCHIVEDDATE	date (7)	False	No	Date that the recording was archived.	17.4.0.0	Added for data extraction from IR_ArchiveContent table.
ARCHIVEDDATEOFFSET	number (22)	False	No	UTC offset of the archive date.	17.4.0.0	Added for data extraction from IR_ArchiveContent table.
RECORDINGDATE	timestamp (11)	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.

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
RECORDINGID	raw (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	number (22)	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	nvarchar2 (510)	False	Depends on customer usage	Value of the attribute.	17.4.0.0	Added for data extraction from IR_CustomAttribute table.
VERSION	number (22)	False	No	Version of the database row.	17.4.0.0	Added for data extraction from IR_CustomAttribute table.
RECORDINGDATE	timestamp	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.

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
QANSWERID	raw (16)	False	No	ID of the answer.	17.4.0.0	Added for data extraction from IR_QAnswer table.
QFORMID	raw (16)	False	No	ID of the form that contains this answer.	17.4.0.0	Added for data extraction from IR_QAnswer table.
QQUESTIONID	raw (16)	False	No	ID of the question that was answered.	17.4.0.0	Added for data extraction from IR_QAnswer table.
SEQUENCE	number (22)	False	No	Sequence number of the answer within the form.	17.4.0.0	Added for data extraction from IR_QAnswer table.
SCORE	number (22)	True	No	Score given to the answer.	17.4.0.0	Added for data extraction from IR_QAnswer table.
RAWANSWER	nvarchar2 (2048)	True	Depends on customer usage	Raw text input of the answer.	17.4.0.0	Added for data extraction from IR_QAnswer table.
USERCOMMENTS	nvarchar2 (2048)	True	Depends on customer usage	Comments provided with the answer.	17.4.0.0	Added for data extraction from IR_QAnswer table.
ISMARKEDNA	number (22)	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	number (22)	False	No	Version of the database row.	17.4.0.0	Added for data extraction from IR_QAnswer table.
RECORDINGDATE	timestamp (11)	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.

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
QFORMID	raw (16)	False	No	ID of the form.	17.4.0.0	Added for data extraction from IR_QFORM table.
QUESTIONNAIREID	raw (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	raw (16)	False	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	number (22)	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	number (22)	False	No	Total score of the form.	17.4.0.0	Added for data extraction from IR_QFORM table.
RANKNAME	nvarchar2 (80)	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	number (22)	True	No	Maximum score of all answers scored for the form.	17.4.0.0	Added for data extraction from IR_QFORM table.
MINSCORE	number (22)	True	No	Minimum score of all answers scored for the form.	17.4.0.0	Added for data extraction from IR_QFORM table.
SCORINGDATE	date (7)	True	No	Time the form was last scored and saved.	17.4.0.0	Added for data extraction from IR_QFORM table.
SCORINGDATEOFFSET	number (22)	True	No	UTC offset of the scoring date.	17.4.0.0	Added for data extraction from IR_QFORM table.
ASSIGNEDDESC	nvarchar2 (2048)	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	number (22)	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	number (22)	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	number (22)	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	number (22)	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	number (22)	True	No	Number of critical questions answered.	17.4.0.0	Added for data extraction from IR_QFORM table.
NUMPOSANSWEREDCRITICALQSTNS	number (22)	True	No	Number of positively answered critical questions.	17.4.0.0	Added for data extraction from IR_QFORM table.
ISFAILED	number (22)	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	number (22)	False	No	Was this form used for calibration.	17.4.0.0	Added for data extraction from IR_QFORM table.
SIGNOFFSTATE	number (22)	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	nvarchar2 (4000)	True	Depends on customer usage	Comments about the sign-off.	17.4.0.0	Added for data extraction from IR_QFORM table.
VERSION	number (22)	False	No	Version of the database row.	17.4.0.0	Added for data extraction from IR_QFORM table.
RECORDINGDATE	timestamp (11)	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.

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
SNIPPETRECORDINGID	raw (16)	False	No	ID of the snippet recording.	17.4.0.0	Added for data extraction from IR_RECORDINGMEDIASNIPPETS table.
POLICYRECORDINGID	raw (16)	False	No	ID of the policy-based recording.	17.4.0.0	Added for data extraction from IR_RECORDINGMEDIASNIPPETS table.
RECORDINGDATE	timestamp (11)	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

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
RecordingId	raw (16)	True	Unknown	ID of the recording that this form refers to	17.4.0.0	New View for crystal report
RecordingDate	date	True	Unknown	Time the recording was made	17.4.0.0	New View for crystal report
MediaType	varchar2 (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	varchar2 (36)	True	Unknown	ID of the interaction of this recording	17.4.0.0	New View for crystal report
RecordingLength	number	True	Unknown	Duration of the recording in milliseconds	17.4.0.0	New View for crystal report
InitiationPolicyName	nvarchar2 (50)	True	Unknown	Name of the initiation policy that initiated this recording	17.4.0.0	New View for crystal report
Direction	number	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	nvarchar2 (50)	True	Unknown	Recorded User Last Name	17.4.0.0	New View for crystal report
RecordedUserFirstName	nvarchar2 (50)	True	Unknown	Recorded User First Name	17.4.0.0	New View for crystal report
RecordedUserMiddleName	nvarchar2 (50)	True	Unknown	Recorded User Middle Name	17.4.0.0	New View for crystal report
RecordedUserDisplayName	nvarchar2 (255)	True	Unknown	Recorded User Display Name	17.4.0.0	New View for crystal report
RecordedUserICUserId	nvarchar2 (50)	True	Unknown	Recorded User ID	17.4.0.0	New View for crystal report
WorkgroupQueue	nvarchar2 (255)	True	Unknown	Work Group Queue	17.4.0.0	New View for crystal report
QuestionnaireId	raw (16)	True	Unknown	Questionnaire ID	17.4.0.0	New View for crystal report
QuestionnaireName	nvarchar2 (255)	True	Unknown	Questionnaire Name	17.4.0.0	New View for crystal report
QuestionnaireNote	nvarchar2 (1024)	True	Unknown	Questionnaire Note	17.4.0.0	New View for crystal report
QuestionnaireMinScore	number	True	Unknown	Minimum score of Questionnaire	17.4.0.0	New View for crystal report
QuestionnaireMaxScore	number	True	Unknown	Maximum score of Questionnaire	17.4.0.0	New View for crystal report
QDirectoryName	nvarchar2 (255)	True	Unknown	Directory Name	17.4.0.0	New View for crystal report
QGroupId	raw (16)	True	Unknown	Group ID	17.4.0.0	New View for crystal report
QGroupSequence	number	True	Unknown	Group Sequence	17.4.0.0	New View for crystal report
QGroupName	nvarchar2 (255)	True	Unknown	Question Group Name	17.4.0.0	New View for crystal report
QGroupNote	nvarchar2 (1024)	True	Unknown	Question Group Note	17.4.0.0	New View for crystal report
IsOptional	number	True	Unknown	Is Optional	17.4.0.0	New View for crystal report
QuestionId	raw (16)	True	Unknown	Question ID	17.4.0.0	New View for crystal report
QuestionSequence	number	True	Unknown	Question Sequence	17.4.0.0	New View for crystal report
QuestionText	nvarchar2 (1024)	True	Unknown	Question Text	17.4.0.0	New View for crystal report
QuestionType	number	True	Unknown	Question Type	17.4.0.0	New View for crystal report
QuestionPromptType	number	True	Unknown	Importance of the question	17.4.0.0	New View for crystal report
QuestionWeight	number	True	Unknown	Weight of Question	17.4.0.0	New View for crystal report
QuestionMin	number	True	Unknown	Minimum Score given to a question	17.4.0.0	New View for crystal report
QuestionMax	number	True	Unknown	Maximum Score given to a question	17.4.0.0	New View for crystal report
QuestionMinAcceptableScore	number	True	Unknown	Minimum Acceptable score of a question	17.4.0.0	New View for crystal report
QuestionCanMarkNA	number	True	Unknown	Flag to specify whether the question can be marked as N/A	17.4.0.0	New View for crystal report
FormId	raw (16)	True	Unknown	Form ID	17.4.0.0	New View for crystal report
ScoredUserLastName	nvarchar2 (50)	True	Unknown	Scored User Last Name	17.4.0.0	New View for crystal report
ScoredUserFirstName	nvarchar2 (50)	True	Unknown	Scored User First Name	17.4.0.0	New View for crystal report
ScoredUserMiddleName	nvarchar2 (50)	True	Unknown	Scored User Middle Name	17.4.0.0	New View for crystal report
ScoredUserICUserId	nvarchar2 (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	nvarchar2 (50)	True	Unknown	Scoring User Last Name	17.4.0.0	New View for crystal report
ScoringUserFirstName	nvarchar2 (50)	True	Unknown	Scoring User First Name	17.4.0.0	New View for crystal report
ScoringUserMiddleName	nvarchar2 (50)	True	Unknown	Scoring User Middle Name	17.4.0.0	New View for crystal report
ScoringUserICUserId	nvarchar2 (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	number	True	Unknown	Combined Maximum Score	17.4.0.0	New View for crystal report
CombinedMinScore	number	True	Unknown	Combined Minimum Score	17.4.0.0	New View for crystal report
CombinedScore	number	True	Unknown	Combined Score	17.4.0.0	New View for crystal report
CombinedPercentileScore	number	True	Unknown	Combined Percentile Score of User	17.4.0.0	New View for crystal report
RankName	nvarchar2 (40)	True	Unknown	Rank Name of User	17.4.0.0	New View for crystal report
NonCriticalMaxScore	number	True	Unknown	Noncritical Maximum Score of the User	17.4.0.0	New View for crystal report
NonCriticalMinScore	number	True	Unknown	Noncritical minimum Score of the User	17.4.0.0	New View for crystal report
NonCriticalScore	number	True	Unknown	Noncritical Score of the User	17.4.0.0	New View for crystal report
NonCriticalPercentileScore	number	True	Unknown	Noncritical Percentile Score	17.4.0.0	New View for crystal report
TotalNumCriticalQuestions	number	True	Unknown	Total number of Critical Questions	17.4.0.0	New View for crystal report
NumAnsweredCriticalQstns	number	True	Unknown	Number of Answered Critical Questions	17.4.0.0	New View for crystal report
NumPosAnsweredCriticalQstns	number	True	Unknown	Number of positively answered critical questions	17.4.0.0	New View for crystal report
CriticalScore	number	True	Unknown	Critical Score of the User	17.4.0.0	New View for crystal report
IsFailed	number	True	Unknown	Flag to display whether the user is passed or failed	17.4.0.0	New View for crystal report
UsingForCalibration	number	True	Unknown	Flag to display whether the scorecard is marked for Calibration or not	17.4.0.0	New View for crystal report
AnswerScore	number	True	Unknown	Score of the given answer	17.4.0.0	New View for crystal report
RawAnswer	nvarchar2 (1024)	True	Unknown	Raw Answer of question	17.4.0.0	New View for crystal report
DisplayAnswer	nvarchar2 (255)	True	Unknown	Display answer for the question	17.4.0.0	New View for crystal report
UserComments	nvarchar2 (1024)	True	Unknown	User Comments	17.4.0.0	New View for crystal report
IsMarkedNA	number	True	Unknown	Flag to determine whether Question is marked as N/A or not	17.4.0.0	New View for crystal report
QDirectoryId	raw (16)	False	No	Directory ID	17.4.0.0	New View for crystal report