FocusJoinsAndLeaves Table

 

Topic Last Modified: 2010-12-08

Each record in this table contains the CDR information about one user’s join and leave information for one conference. Each conference is represented in this table by one record for each time a user joins and leaves the conference.

Column Data Type Key/Index Details

SessionIdTime

datetime

Primary, Foreign

Time of conference instance. Used in conjunction with SessionIdSeq to uniquely identify a conference instance. Reference to the Conferences Table.

SessionIdSeq

int

Primary, Foreign

ID number to identify the conference instance. Used in conjunction with SessionIdTime to uniquely identify a conference instance. Reference to the Conferences Table.

DialogSessionIdTime

datetime

Foreign

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. Reference to the Dialogs Table.

DialogSessionIdSeq

int

Foreign

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. Reference to the Dialogs Table.

UserId

int

Primary, Foreign

Unique number identifying this user, referenced from the Users Table.

FocusUserInstance

Int

Primary

If a user is logged on at multiple computers or devices at the same time, UserInstance is used to uniquely identify the user/device combination.

IsUserInternal

Bit

 

Whether the user logged on from internal or not.

UserRole

Int

 

This user’s role in the conference, such as Presenter or Attendee.

UserJoinTime

datetime

 

The time this user joins the conference.

UserLeaveTime

datetime

 

The time this user leaves the conference.

ClientVerId

int

Foreign

Version of the user’s client software, referenced to the ClientVersions Table.