Database Schema Tables / Summary Tables |
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.
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 |