This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Vocera Voice Server Fact Tables | |
Fact table delivering detailed events and values pertaining to the server speech channel statistics event.
These statistics are measured over a sliding window, usually 30 minutes in length. This window is divided into a number of time periods or slots, usually 60, each lasting 30 seconds. After a slot is completed, the window slides, and a new slot is created.
| Column | Description | Example |
|---|---|---|
| TenantId | int This field is for future use only, and is currently set to 0. |
|
| StartedAt | timestamp Displays the date and time of the start of the event. |
2017-10-14 19:21:58 |
| EventType | int Displays the event type. |
0 |
| ChansAvg | decimal Displays the average number of concurrent Genie sessions, over the sliding window, at the end of each slot. |
0.03 |
| ChansMax | int Displays the maximum number of concurrent Genie sessions during the current set of slots in the sliding window. |
2 |
| ChansAllTimeMax | int Displays the all-time maximum number of concurrent Genie sessions since the server was started. |
3 |
| Freq | decimal(5,2) NOT NULL Displays the average of the number of started Genie sessions per time slot divided by the minutes per slot. |
0.13 |
| DurationSec | decimal Displays the average, over all slots in the sliding window, of the average length of the ended Genie sessions in a slot. |
0.42 |
| RecogPrc | int Displays the percentage of accepted speech recognition attempts that return with a confidence score higher than the confirm threshold. |
83 |
| ProbBusyPrc | decimal(11,2) NOT NULL The average of the number of times a started Genie session had to wait to get a speech port, divided by the average of the number of started Genie sessions over the sliding window. |
17.24 |
| BusyTimeSec | decimal Displays the average amount of wait time in seconds, over the sliding window, for waiting Genie sessions. |
0.11 |
| LoginCount | int Displays the number of logins (using a login license, and not necessarily active). |
7926 |
| TenantName | varchar This field is for future use only, and is currently blank. |
|
| BatchID | int This field is for future use only, and is currently set to 0. |
|
| RowCreatedTS | timestamp Displays the date and time that the table row was created. |
2017-12-05 23:43:52 |
This guide last modified:
2021-04-23 06:46.
.