Conferences Table

 

Topic Last Modified: 2010-11-07

Each record in this table contains call details about one conference.

Column Data Type Key/Index Details

SessionIdTime

datetime

Primary

Time that the conference request was captured by the CDR agent. Used only as a primary key to uniquely identify a conference instance.

SessionIdSeq

int

Primary

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a conference instance. *

ConferenceUriId

Int

Foreign

Conference URI. Reference to ConferenceUris Table.

ConfInstance

uniqueidentifier

 

Useful for recurring conferences; each instance of a recurring conference has the same ConferenceUri, but will have a different ConfInstance.

ConferenceStartTime

datetime

 

Conference start time.

ConferenceEndTime

datetime

 

Conference start time.

PoolId

Int

Foreign

ID number to identify the pool in which the conference was captured. Reference to Pools Table.

OrganizerId

Int

Foreign

ID number to identify the organizer URI of this conference. Reference to Users Table.

Flag

smallint

A bit mask that contains Conference Attributes. Possible values are:

  • 0X01

  • Synthetic

  • Transaction

* For most sessions, SessionIdSeq will have the value of 1. If two sessions start at exactly the same time, the SessionIdSeq for one will be 1, and for the other will be 2, and so on.