devicestatuschange

The devicestatuschange table stores data for device statuses that have been changed by users. This table has a primary key based on the TxMillis column.

Table 1. devicestatuschange table
Column Description
TxMillis

bigint(15) unsigned NOT NULL default '0'

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 default '0000-00-00 00:00:00'

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

TxDate

date default NULL

The TxDate column stores the date of an event, accurate to the day.

DeviceID

varchar(20) NOT NULL

Specifies the device ID from the Vocera Server. Example value: D-0009ef050686

DeviceSite

varchar(50) NOT NULL

Specifies the site of the device when the status changed.

Status

varchar(30) NOT NULL

Specifies the device status.

Notes

text

Notes describing the device status.