IR Archive Content View
The IR_ArchiveContent view contains the set of recordings that make up an archive volume.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| RecordingId | uniqueidentifier (16) | False | No | ID of the recording. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| ArchiveId | uniqueidentifier (16) | False | No | ID of the archive volume. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| ArchivedDate | datetime (8) | False | No | Date that the recording was archived. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| ArchivedDateOffset | int (4) | False | No | UTC offset of the archive date. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| RecordingDate | datetime2 (8) | False | No | Time the recording was made. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| RECORDINGID | raw (16) | False | No | ID of the recording. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| ARCHIVEID | raw (16) | False | No | ID of the archive volume. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| ARCHIVEDDATE | date (7) | False | No | Date that the recording was archived. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| ARCHIVEDDATEOFFSET | number (22) | False | No | UTC offset of the archive date. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |
| RECORDINGDATE | timestamp (11) | False | No | Time the recording was made. |
17.4.0.0 | Added for data extraction from IR_ArchiveContent table. |