Follow

VIA Data Query Table Schema

Below is the schema for all available tables for Data Query.

Calls Table

Field Data Type Description
SessionIdTime datetime Primary key in conjunction with SessionIdSeq
SessionIdSeq int Primary key in conjunction with SessionIdTime
CallStartTime datetime Time the call started in UTC
CallEndTime datetime Time the call ended in UTC
Duration int Duration in seconds 
IM bit Flag if instant messaging was used
Audio bit Flag if audio was used 
Video bit Flag if video was used 
FileTransfer bit Flag if file transfer was used
AppSharing bit Flag if application sharing was used 
RemoteAssistance bit Flag if remote assistance was used 
AppInvite bit Flag if application invite was used 
Parent_SessionIdTime datetime Foreign key, in conjuction with Parent_SessionIdSeq if this call is part of another call for example a transfer
Parent_SessionIdSeq int Foreign key, in conjuction with Parent_SessionIdTime if this call is part of another call for example a transfer 
Conference_SessionIdTime datetime Foreign key to the Conferences table, in conjuction with Conference_SessionIdSeq if this call is part of a conference
Conference_SessionIdSeq int Foreign key to the Conferences table, in conjuction with Conference_SessionIdTime if this call is part of a conference
FromPstn bit Flag if the call came from the telephone network
ToPstn bit Flag if the call was made to the telephone network 
FromUserMessageCount int Not currently used 
ToUserMessageCount int Not currently used 
SegmentStartTime datetime Start time, in UTC, for this call leg if the call was parented by another such as a transfer
SegmentEndTime datetime Start time, in UTC, for this call leg if the call was parented by another such as a transfer
DiagnosticId int Internal Diagnostic Id for the call 
ResponseCode int SIP Response Code for the call
FromUser_UserId uniqueidentifier From User User Id if present
FromUser_UserName nvarchar(max) From User Display Name if present
FromUser_SipAddress nvarchar(max) From User Sip Address if present
FromUser_TelOffice nvarchar(max) From User Telephone if present 
FromUser_OrganisationId uniqueidentifier From User OrganisationId if present
FromUser_Department nvarchar(max) From User Department if present 
FromUser_Office nvarchar(max) From User Office if present 
FromUser_JobTitle nvarchar(max) From User Job Title if present 
FromUser_License nvarchar(max) From User License Name if present
ToUser_UserId uniqueidentifier To User User Id if present
ToUser_UserName nvarchar(max) To User Display Name if present
ToUser_SipAddress nvarchar(max) To User Sip Address if present
ToUser_TelOffice nvarchar(max) To User Telephone if present 
ToUser_OrganisationId uniqueidentifier To User OrganisationId if present
ToUser_Department nvarchar(max) To User Department if present 
ToUser_Office nvarchar(max) To User Office if present 
ToUser_JobTitle nvarchar(max) To User Job Title if present 
ToUser_License nvarchar(max) To User License Name if present
RefUser_UserId uniqueidentifier Referred by User Id if present if the call was transferred
RefUser_UserName nvarchar(max) Referred by User Display Name if present if the call was transferred
RefUser_SipAddress nvarchar(max) Referred by User Sip Address if present if the call was transferred
RefUser_TelOffice nvarchar(max) Referred by User Telephone if present if the call was transferred
RefUser_OrganisationId uniqueidentifier Referred by User OrganisationId if present if the call was transferred
RefUser_Department nvarchar(max) Referred by User Department if present if the call was transferred
RefUser_Office nvarchar(max) Referred by User Office if present if the call was transferred
RefUser_JobTitle nvarchar(max) Referred by User Job Title if present if the call was transferred
RefUser_License nvarchar(max) Referred by User License Name if present if the call was transferred
BillingCall_SummaryGroup nvarchar(max) Description of the call destination if the call was billable
BillingCall_TotalCost float Total cost of the call if billable 
BillingCall_BilledTotal float Total billed if organisation is on a bundled minutes package 

Conferences Table

 

Organiser_UserIduniqueidentifierOrganiser User Id if present

Field Data Type Description
SessionIdTime datetime Primary key in conjunction with SessionIdSeq
SessionIdSeq int Primary key in conjunction with SessionIdTime
StartTime datetime Time the conference started in UTC
EndTime datetime Time the conference ended in UTC
Uri nvarchar(400) Meeting Uri for the conference
Subject nvarchar(400) Subject for the meeting if present
Organiser_UserName nvarchar(max) Organiser Display Name if present
Organiser_SipAddress nvarchar(max) Organiser Sip Address if present
Organiser_TelOffice nvarchar(max) Organiser Telephone if present 
Organiser_OrganisationId uniqueidentifier Organiser OrganisationId if present
Organiser_Department nvarchar(max) Organiser Department if present 
Organiser_Office nvarchar(max) Organiser Office if present 
Organiser_JobTitle nvarchar(max) Organiser Job Title if present 
Organiser_License nvarchar(max) Organiser License Name if present
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request