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.

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

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