Specifications

Call Detail Record Reports
ShoreTel 7.5 Administration Guide C – 63
MediaStream Table
The MediaStream table logs media information about InterSite Calls. At a high level,
there is one such entry for each InterSite call. Information about both parties involved
in the call is recorded.
Table C-3 Media Stream
Field Name Data Type Description
ID AutoNumber Unique identifier. (4-byte integer, required)
CallID Number Unique number for the existence of the call. (4-byte integer)
SIP GUID Text SIP Unique Global ID number (32 characters, zero-length)
EncodingType Number Encoding type used for media stream. (1-byte integer)
PayloadSize Number Media payload size in bytes for each media packet. (4-byte integer)
StartTime Date/Time Date and time the call started.
Duration Date/Time Elapsed time of call from begin to end. (8-byte date/time)
DurationSeconds Number Elapsed seconds time of call from begin to end. (4-byte integer)
FailureCode Number Enumeration of error code. See MediaFailureCode table below for
enumerations (1-byte integer)
A PartyType Number Party A's type enumeration. See the PartyType table. (1-byte
integer)
A SiteID Number Party A's Site ID. (4-byte integer)
A SiteName Text Party A's Site Name. (50 characters, zero-length)
A LineID Number TAPI permanent line ID for party A. (4-byte integer)
A Name Text Call type name for party A. (50 characters, zero-length)
A_Extension Text Call extension number for party A (32 characters, zero-length)
A IP Address Text Local IP Address for party A. (15 characters, zero-length)
A TotalPackets Number Total packets received by party A. (4-byte integer)
A LostPackets Number Total packets lost by party A. (4-byte integer)
A MaxJitter Number Maximum jitter (ms) for party A. (4-byte integer)
A Underruns Number Number of receive underruns for party A. (4-byte integer)
A Overruns Number Number of receive underruns for party A. (4-byte integer)
B PartyType Number Party B's type enumeration. (1-byte integer)
B SiteID Number Party B's Site ID. (4-byte integer)
B SiteName Text Party B's Site Name. (50 characters, zero-length)
B LineID Number TAPI permanent line ID for party B. (4-byte integer)
B Name Text Call type name for party B. (50 characters, zero-length)
B_Extension Text Call extension number for party B (32 characters, zero-length)
B IP Address Text Local IP Address for party B. (15 characters, zero-length)
B TotalPackets Number Total packets received by party B. (4-byte integer)
B LostPackets Number Total packets lost by party B. (4-byte integer)
B MaxJitter Number Maximum jitter (ms) for party B. (4-byte integer)
B Underruns Number Number of receive underruns for party B. (4-byte integer)
B Overruns Number Number of receive overruns for party B. (4-byte integer)
InterSite Yes/No Boolean to indicate whether the call logged is InterSite. Currently
only Intersite calls are logged. (boolean)
Archived Yes/No Has this entry been archived? (boolean)