Expand All Collapse All

IR_ArchiveVolumeDescriptor Table

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

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

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_ArchiveVolumeDescriptor Clustered ArchiveId (Ascending)