Recording Details
| Column Name | Data Type | Description |
|---|---|---|
Recording_ID *1 |
uniqueidentifier |
Unique identifier of media in QMS. |
Start_Date |
date |
Date media collection started. |
Start_Time |
time |
Time media collection started. |
Stop_Date |
date |
Date media collection stopped. |
Stop_Time |
time |
Time media collection stopped. |
Duration |
int |
Duration of collected media in seconds. |
Media_Type |
smallint |
Call - 0, Screen - 1, SMS - 3, WebChat - 4, Email - 5, UCMessage - 6, Video - 7, Fax - 8, Text - 9, Image - 10, Transcription - 11, IVR - 15, Voicemail - 16. |
User_ID *3 |
uniqueidentifier |
Unique identifier of user in QMS the media is associated with. |
Description |
nvarchar-255 |
Media description. |
Notes |
nvarchar-2000 |
Notes attached to media. |
Inbound_ID |
nvarchar-255 |
Inbound numeric metadata attached to media. |
Inbound_Name |
nvarchar-50 |
Inbound numeric metadata attached to media. |
Outbound_ID |
nvarchar-255 |
Outbound numeric metadata attached to media. |
Outbound_Name |
nvarchar-50 |
Outbound numeric metadata attached to media. |
DNIS |
nvarchar-255 |
DNIS attached to media. |
File_Size |
bigint |
Size of media in bytes. |
External_Word_Count |
smallint |
Unique utterances in text based media attributed to an external source. |
Internal_Word_Count |
smallint |
Unique utterances in text based media attributed to an internal source. |
Recording_Profile_Name *2 |
nvarchar-50 |
Name of the governing profile that recorded media. |
Recording_Summary |
nvarchar-max |
Enghouse AI generated media summary where available. |
*1 |
Member is the table’s primary key. |
*2 |
Member has an accompanying, like-named member that serves as a unique identifier. Where the identifier is named member_Id |
*3 |
This member is a foreign key linking a record in the User_Details table. |