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. |