radiodetail

The radiodetail table stores detailed information regarding the audio quality experienced by Vocera badges during a call. This table has a primary key based on the id column.

Table 1. radiodetail table
Column Description
id

int(11) NOT NULL auto_increment

An incremental ID assigned to the lost connection instance.

TxParentMillis

varchar(15) default NULL

The TxParentMillis column is the unique identifier for the parent record in the radio log.

TxMillis

bigint(15) unsigned default NULL

The TxMillis column gives each row in the table a unique identifier. The value represents the number of milliseconds since January 1, 1970 (a date specified for internal use by the report system). Because of the uniqueness constraint, it may not reflect the exact actual date and time of the event. See TxDateTime.

TxDateTime

datetime NOT NULL

The TxDateTime column stores the date and time of an event, accurate to the second.

APMacAddress

varchar(12) default NULL

The APMacAddress column specifies the MAC address of the wireless access point with which the badge was most recently associated. Example value: 000f24e9dce0

OtherParty

varchar(20) default NULL

Source IP address that the badge received while in a call.

PacketsReceived

smallint(6) default NULL

Total packets received before a new log event occurred. PacketsReceived and PacketsMissed are used to compute the Packet Error Rate.

PacketsMissed

smallint(6) default NULL

Total packets missed before a new log event occurred.

CQ

smallint(6) default NULL

Communication Quality (CQ) value, which is an even number value on a logarithmic scale ranging from 0 to 92, where 0 represents no signal and 92 is the strongest possible signal with essentially no background noise.

RoamTime

mediumint(9) default NULL

Specifies the Roam Time.

Type

smallint(1) default '1'

1 if frames are unicast; 0 if frames are multicast.

Reserved1

mediumint(9) default NULL

Reserved for future use.

Reserved2

mediumint(9) default NULL

Reserved for future use.

Reserved3

mediumint(9) default NULL

Reserved for future use.