unansweredcalls

The unansweredcalls table stores data about calls that were not answered.

Table 1. unansweredcalls table
Column Description
TxMillis

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.

Called

varchar(40) NOT NULL

The Called column stores the user ID of the called party

CallID

bigint(20) NOT NULL default '20'

The CallID column stores the ID of the call as entered in the Vocera server log.

GenieID

bigint(10) NOT NULL default '0'

The GenieID column stores the ID of the Genie session as entered in the Vocera server log.

ReasonID

int(2) NOT NULL default '0'

The ReasonID column stores an integer that maps to a Reason string.

Reason

VARCHAR(25) NOT NULL

The Reason column stores a string that explains why the call was unanswered.

Possible values:
  • Busy

  • Call rejected

  • Call wait rejected

  • Caller blocked

  • Not logged in

  • Not online

  • Phone not answered

  • Unavailable