|Database Details / Vocera Usage Data|
The unansweredcalls table stores data about calls that were not answered.
bigint(15) unsigned NOT 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.
varchar(40) NOT NULL
The Called column stores the user ID of the called party
bigint(20) NOT NULL default '20'
The CallID column stores the ID of the call as entered in the Vocera server log.
bigint(10) NOT NULL default '0'
The GenieID column stores the ID of the Genie session as entered in the Vocera server log.
int(2) NOT NULL default '0'
The ReasonID column stores an integer that maps to a Reason string.
VARCHAR(25) NOT NULL
The Reason column stores a string that explains why the call was unanswered.