ConferenceDateTime

Datetime

Primary

Time when the QoE agent receives the first report from either caller or callee; used in conjunction with SessionSeqto uniquely identify a session.

SessionSeq

Int

Primary

Sequence number to differentiate sessions when they have the same ConferenceDateTime.

SessionID

varchar(256)

DialogID which is globally unique.

Checksum

Int

Index

Checksum of SessionID, for internal use only.

ConferenceKey

Int

Foreign

Conference key, referenced from the Conference Table.

CorrelationKey

Int

Foreign

Correlation key, referenced from the SessionCorrelation Table.

DialogCategory

bit

Dialog category; 0 is OCS to Mediation Server Leg, 1 is Mediation Server to PSTN gateway leg.

StartTime

Datetime

Call start time.

EndTime

datetime

Call end time.

CallerPool

Int

Foreign

The pool of the caller, referenced from the Pool Table.

CalleePool

Int

Foreign

The pool of the call receiver, referenced from the Pool Table.

CallerPAI

Int

Foreign

SIP URI in the SIP p-asserted identity (PAI) from the calling endpoint, referenced from the User Table.

CalleePAI

int

Foreign

SIP URI in the SIP p-asserted identity (PAI) of the receiving endpoint, referenced from the User Table.

CallerURI

Int

Foreign

Caller’s URI, referenced from the User Table.

CalleeURI

int

Foreign

Call receiver’s URI, referenced from the User Table.

CallerEndpoint

Int

Foreign

Caller’s endpoint, referenced from the Endpoint Table.

CalleeEndpoint

int

Foreign

Call receiver’s endpoint, referenced from the Endpoint Table.

CallerUserAgent

Bit

Foreign

Caller’s user agent, referenced from the UserAgent Table.

CalleeUserAgent

Bit

Foreign

Call receiver’s user agent, referenced from the UserAgent Table.