Expand All Collapse All

IR_RecordingMedia Table

  • Table Type - Historical
  • Last Changed Version - 16.3.0.354
  • Last Changed Reason - Added column recordingtype for snippet recordings.

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
RecordingId uniqueidentifier False No

4.0.106.453 4.0 Release
RelatedRecordingId uniqueidentifier True No

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

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

4.0.106.453 4.0 Release
MediaType smallint False No

4.0.106.453 4.0 Release
FileSize int True No

4.0.106.453 4.0 Release
RecordingDate datetime2 False No

4.0.106.453 4.0 Release
RecordingDateOffset int False No

4.0.106.453 4.0 Release
ExpirationDate datetime True No

4.0.106.453 4.0 Release
StartEventCode int False No

4.0.106.453 4.0 Release
Duration int True No

4.0.106.453 4.0 Release
FromConnValue nvarchar (255) True Yes

4.0.106.453 4.0 Release
ToConnValue nvarchar (255) True Yes

4.0.106.453 4.0 Release
MediaStatus nvarchar (56) True No

4.0.106.453 4.0 Release
Direction tinyint True No

4.0.106.453 4.0 Release
QueueObjectIdKey varchar (36) True No

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

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

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

4.0.106.453 4.0 Release
NumAttachments smallint True No

4.0.106.453 4.0 Release
CallType tinyint True No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release
KeywordCustomerScorePositive int True No

4.0.106.453 4.0 Release
KeywordCustomerScoreNegative int True No

4.0.106.453 4.0 Release
KeywordAgentScorePositive int True No

4.0.106.453 4.0 Release
KeywordAgentScoreNegative int True No

4.0.106.453 4.0 Release
IsArchived tinyint False No

4.0.106.453 4.0 Release
RecordingType smallint True No

16.3.0.354 Added for snippet recordings.
Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
RecordingId 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.

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)