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.

SQL 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.

SQL Constraints

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

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

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