IR Recording Media Snipppets View
The IR_RecordingMediaSnipppets view maps snippet recording IDs to corresponding policy recording IDs. Note that an entry will only exist in this table for a snippet recording if a policy recording of an interaction was done at the same time as a snippet recording of the same interaction.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| SnippetRecordingId | uniqueidentifier (16) | False | No | ID of the snippet recording. |
17.4.0.0 | Added for data extraction from IR_RecordingMediaSnippets table. |
| PolicyRecordingId | uniqueidentifier (16) | False | No | ID of the policy-based recording. |
17.4.0.0 | Added for data extraction from IR_RecordingMediaSnippets table. |
| RecordingDate | datetime2 (8) | False | No | Time the recording was made. |
17.4.0.0 | Added for data extraction from IR_RecordingMediaSnippets table. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| SNIPPETRECORDINGID | raw (16) | False | No | ID of the snippet recording. |
17.4.0.0 | Added for data extraction from IR_RECORDINGMEDIASNIPPETS table. |
| POLICYRECORDINGID | raw (16) | False | No | ID of the policy-based recording. |
17.4.0.0 | Added for data extraction from IR_RECORDINGMEDIASNIPPETS table. |
| RECORDINGDATE | timestamp (11) | False | No | Time the recording was made. |
17.4.0.0 | Added for data extraction from IR_RECORDINGMEDIASNIPPETS table. |