1. Home
  2. Microsoft Teams Phone Reporting & Analytics
  3. Microsoft Teams Phone Call Detail Data Dictionary

Microsoft Teams Phone Call Detail Data Dictionary

Applies to: 

  • Microsoft Teams Phone administrators
  • Microsoft Teams Phone users

Background 

This article defines column names in Teams Phone reports generated using Variphy and provides examples of data that can be found in those fields.

Microsoft Teams Call Data Dictionary

Date/Time

Column NameDefinitionExample
Call Date/Time OriginationDate and time a call originated2/22/2024 8:02:25 PDT
Call Date OriginationDate a call originatedFeb 22, 2024
Call Time OriginationTime a call originated6:02:25 AM PDT
Call Date/Time TerminationDate and time a call terminated2/22/2024 9:02:25 PDT
Call Date TerminationDate a call terminatedFeb 22, 2024
Call Time TerminationTime a call terminated9:02:25 AM PDT
Sequence Date/Time OriginationDate and time a call sequence originated2/22/2024 8:12:25 PDT
Sequence Date OriginationDate a call sequence originatedFeb 22, 2024
Sequence Time OriginationTime a call sequence originated8:12:25 AM PDT
Sequence Date/Time TerminationDate and time a call sequence terminated2/22/2024 9:12:25 PDT
Sequence Date TerminationDate a call sequence terminatedFeb 22, 2024
Sequence Time TerminationTime a call sequence terminated9:12:25 AM PDT

Originating Party

Column NameDefinitionExample
OrganizerName of the organizer of a meetingJohn Doe
Calling Party NumberCaller ID or DN of a person placing a call18005244441
Calling Party User IDUnique ID for each Teams user55ad7d69-8776-4709-852c-f54844354c08
Calling Party User NameName of the Teams user placing a callBen Smith
Calling Party User TypeType of Teams user placing a callMember or Guest
Calling Party User Job TitleJob title of Teams user placing a callAccountant
Calling Party User Email Address(es)Email address(es) of Teams user placing a calljohn.doe@xyz.com
Calling Party User Location UsageLocation usage of Teams user placing a callUS
Calling Party User Preferred LanguagePreferred language of Teams user placing a callEnglish
Calling Party User Age GroupAge group of Teams user placing a callAdult
Calling Party User CityCity of Teams user placing a callChicago
Calling Party User StateState of Teams user placing a callIL
Calling Party User CountryCountry of Teams user placing a callUS
Calling Party User Postal CodePostal code of Teams user placing a call60101
Calling Party User Street AddressStreet address of Teams user placing a call125 Oak St
Calling Party User Company NameCompany name of Teams user placing a callVariphy
Calling Party User DepartmentDepartment name of Teams user placing a callTechnical Support
Calling Party User DivisionDivision name of Teams user placing a callEastern Sales Branch
Calling Party User Employee IDEmployee ID of Teams user placing a call15526985
Calling Party User Cost CenterCost center of Teams user placing a call123456789
Calling Party User Employee TypeEmployee type of Teams user placing a callLevel 1
Calling Party User Fax NumberFax number of Teams user placing a call1-800-965-3222
Calling Party User IM AddressIM address of Teams user placing a calljohn.doe@xyz.com
Calling Party User Extension Attribute 1-15Custom attributes of Teams user placing a callContractor
Calling Party User Security IdentifierSecurity identifier of Teams user placing a callS-1-5-32-544
Calling Party User TeamsGroups assigned to the Teams user placing a callVariphy
Terminating Party
Column NameDefinitionExample
Calling Party NumberThe DN or phone number called by the calling party18005244441
Calling Party User IDThe user who received the call (if applicable)55ad7d69-8776-4709-852c-f54844354c08
Calling Party User NameName of the Teams user who received a callBen Smith
Calling Party User TypeType of Teams user who received a callMember or Guest
Calling Party User Job TitleJob title of Teams user who received a callAccountant
Calling Party User Email Address(es)Email address(es) of Teams user who received a calljohn.doe@xyz.com
Calling Party User Location UsageLocation usage of Teams user who received a callUS
Calling Party User Preferred LanguagePreferred language of Teams user who received a callEnglish
Calling Party User Age GroupAge group of Teams user who received a callAdult
Calling Party User CityCity of Teams user who received a callChicago
Calling Party User StateState of Teams user who received a callIL
Calling Party User CountryCountry of Teams user who received a callUS
Calling Party User Postal CodePostal code of Teams user who received a call60101
Calling Party User Street AddressStreet address of Teams user who received a call125 Oak St
Calling Party User Company NameCompany name of Teams user who received a callVariphy
Calling Party User DepartmentDepartment name of Teams user who received a callTechnical Support
Calling Party User DivisionDivision name of Teams user who received a callEastern Sales Branch
Calling Party User Employee IDEmployee ID of Teams user who received a call15526985
Calling Party User Cost CenterCost center of Teams user who received a call123456789
Calling Party User Employee TypeEmployee type of Teams user who received a callLevel 1
Calling Party User Fax NumberFax number of Teams user who received a call1-800-965-3222
Calling Party User IM AddressIM address of Teams user who received a calljohn.doe@xyz.com
Calling Party User Extension Attribute 1-15Custom attributes of Teams user who received a callContractor
Calling Party User Security IdentifierSecurity identifier of Teams user who received a callS-1-5-32-544
Calling Party User TeamsGroups assigned to the Teams user who received a callVariphy

Duration

Column NameDefinitionExample
Call Duration (sec)Duration of a call in seconds279
Call Duration (hh:mm:ss)Duration of a call in Hours:Minutes:Seconds0:04:39
Sequence Duration (sec)Duration of the entire sequence of a call in seconds10
Sequence Duration (hh:mm:ss)Duration of the entire sequence in Hours:Minutes:Seconds0:00:10
Segment Duration (sec)Duration of the entire segment of a call in seconds79
Segment Duration (hh:mm:ss)Duration of the entire segment in Hours:Minutes:Seconds0:01:19

Signaling

Column NameDefinitionExample
DirectionDirection of a callInbound, Outbound, Internal, External Group Call, Internal Group Call

User Agent

Column NameDefinitionExample
Calling Party User Agent TypeUser agent of an endpoint in a callService User Agent, Client User Agent
Calling Party User-Agent HeaderUser-Agent header value reported by this endpointpstn (Teams/)
Calling Party User Agent Application VersionVersion of application software used by this endpoint
Calling Party User Agent Azure Application IDUnique identifier of the Microsoft Entra application used by this endpoint
Calling Party User Agent Communication Service IDImmutable resource identifier of the Azure Communication Service associated with this endpoint based on Communication Services APIs
Calling Party User Agent PlatformPlatform used by this endpointIOS, windows
Calling Party User Agent Product FamilyFamily of application software used by this endpointteams
Calling Party User Agent RoleAgent role used by this endpointCustom Bot
Called Party User Agent TypeUser agent of an endpoint in a callService User Agent, Client User Agent
Called Party User-Agent HeaderUser-Agent header value reported by this endpointpstn (Teams/)
Called Party User Agent Application VersionVersion of application software used by this endpoint
Called Party User Agent Azure Application IDUnique identifier of the Microsoft Entra application used by this endpoint
Called Party User Agent Communication Service IDImmutable resource identifier of the Azure Communication Service associated with this endpoint based on Communication Services APIs
Called Party User Agent PlatformPlatform used by this endpointIOS, windows
Called Party User Agent Product FamilyFamily of application software used by this endpoint.teams
Called Party User Agent RoleAgent role used by this endpointCustom Bot

Call Identifier

Column NameDefinitionExample
Call Record IDUnique identifier for the call recorda919ba4e-46b1-4edc-b63d-0c6918b826cc
Call Session IDUnique identifier for the session7173523c-91e9-46f0-b027-ca0525d01303
Call Segment IDUnique identifier for the segment (usually same as Session ID)7173523c-91e9-46f0-b027-ca0525d01303
Join Web URLMeeting URL associated to the call. May not be available for a peer-to-peer call record typehttps://teams.microsoft.com/l/meetup-join/19%3ameeting…

Miscellaneous/Other

Column NameDefinitionExample
Call ScenariosSummary of each call sessionConnected, Medium Duration, Peer to Peer
Call TypeType of the callPeer to Peer, Group Call
ModalitiesList of all the modalities used in the callAudio, Video, Screen Sharing
Call Session Failure ReasonClassification of why a call or portion of a call failed
Call Session Failure StageStage when the failure occurredCall Setup, Mid-call
Call Segment Failure ReasonClassification of why a call or portion of a call failed
Call Segment Failure StageStage when the failure occurredCall Setup, Mid-call
Call Segment Media LabelMedia associated with this segmentmain-audio
Calling Party Endpoint CPU Cores CountNumber of CPU cores available on the endpoint8
Calling Party Endpoint CPU NameName of the CPU used by the endpointIntel(R) Core(TM) i7-8665U CPU @ 1.90GHz
Calling Party Endpoint CPU Processor Speed (Mhz)Speed in MHz of the CPU used by the endpoint1900
Calling Party Endpoint NameMachine name reported by the endpoint if the endpoint is a server or a cloud service clientLAPTOP-847ICNP6
Calling Party Device Capture Device DriverName of the capture device driver used by the endpointUnknown:x.x.x.x
Calling Party Device Capture Device NameName of the capture device used by the endpointAudio
Calling Party Device Render Device DriverName of the render device driver used by the endpointRealtek Semiconductor Corp.: 6.0.9354.1
Calling Party Device Render Device NameName of the render device name used by the endpointRealtek(R) Audio
Called Party Endpoint CPU Cores CountNumber of CPU cores available on the endpoint8
Called Party Endpoint CPU NameName of the CPU used by the endpointIntel(R) Core(TM) i7-8665U CPU @ 1.90GHz
Called Party Endpoint CPU Processor Speed (Mhz)Speed in MHz of the CPU used by the endpoint1900
Called Party Endpoint NameMachine name reported by the endpoint if the endpoint is a server or a cloud service clientLAPTOP-847ICNP6
Called Party Device Capture Device DriverName of the capture device driver used by the endpointUnknown:x.x.x.x
Called Party Device Capture Device NameName of the capture device used by the endpointAudio
Called Party Device Render Device DriverName of the render device driver used by the endpointRealtek Semiconductor Corp.: 6.0.9354.1
Called Party Device Render Device NameName of the render device name used by the endpointRealtek(R) Audio
Updated on April 5, 2024

Was this article helpful?

Related Articles