summaryspeechuser

This summary table aggregates daily data from the fctrecresults table: recognized, rejected, and other speech items, and speech, non-speech, and total counts, grouped by user.

Table 1. summaryspeechuser table
Column Description Example
Txdate

date

The date of the aggregated data.

2017-10-09
Site

varchar

The Vocera Voice Server site name for the user.

MySiteName
Unit

varchar

The comma-separated list of user departments.

g-engineering0,g-office
User

varchar

Specifies the user display name of the person who uttered the speech.

Smith, John
UserUID

varchar

The internal Vocera Voice Server id of the user.

u-jsmith
UserId

varchar

Specifies the user name of the person who uttered the speech. This field contains the same information as the UserName field in the dimusers table.

JohnSmith
MACAddress

varchar

Specifies the device MAC address.

0009ef006e9
DeviceVersion

varchar

The version of the device from which the speech was sent.

B3000N
Recognized

int

The number of recognized speech items.

20
Rejected

int

The number of rejected speech items.

1
Others

int

The number of speech items that were neither recognized nor rejected.

0
speechAttempts

bigint

The total number of detected speech attempts.

21
NoSpeech

int

The number of attempts where no speech was detected.

1
TotalAttempts

bigint

The total number of attempts. This should be the sum of the speechAttempts and NoSpeech fields.

22