MediaList table

 

Topic Last Modified: 2016-07-12

The MediaList table is a static table that stores the list of various media types.

 

Column Data Type Key/Index Details

MediaId

tinyint

Primary

Values: 1-7

Media

nvarchar(256)

Static mapping of MediaID and Media values:

  • 1 -- IM

  • 2 – File Transfer

  • 3 – Remote Assistance

  • 4 – Application Sharing

  • 5 -- Audio

  • 6 -- Video

  • 7 – App Invite

If you are trying to determine the modality type for the values in LcsCDR.SessionDetailsView.MediaTypes, then you need to use the following Join snippet:

LEFT JOIN on Media.MediaId = MediaList.MediaId
 
Show: