Expand All Collapse All

IR_RecordingWork Table

  • Table Type - Lookup
  • Last Changed Version - 16.3.0.354
  • Last Changed Reason - Changed data type of IR_recordingWork.RecorderDate to DATETIME2 for SQL Server and TIMESTAMP(3) for Oracle to match IR_RecordingMedia.RecordingDate.

Column Definitions

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

4.0.106.453 4.0 Release
RecordingId uniqueidentifier False No

4.0.106.453 4.0 Release
RecordingDate datetime2 False No

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

4.0.106.453 4.0 Release
Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
SessionId 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

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)