This guide last modified:
2021-04-23 06:46.
.
| 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 location site and MAC address.
| Column | Description | Example |
|---|---|---|
| Txdate | date The date of the aggregated data. |
2017-10-08 |
| Site | varchar The site of the location access point. |
MySiteName |
| APMACAddress | varchar Specifies the MAC address of the wireless access point with which the badge was connected for the speech attempts. |
000f24e9dce0 |
| Location | varchar Specifies the location name for the element or device. |
Engineering - 4th Floor |
| LocationId | varchar Displays the id generated by the Vocera Voice Server for the location. |
l_4th_floor_engineering |
| 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 |
This guide last modified:
2021-04-23 06:46.
.