This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Vocera Voice Server Fact Tables | |
Fact Table delivering detailed insight into Genie sessions.
| Column | Description | Example |
|---|---|---|
| TenantId | int This field is for future use only, and is currently set to 0. |
|
| TenantName | varchar This field is for future use only, and is currently blank. |
|
| DeviceId | varchar Displays the device id. |
0009ef31a31d |
| DeviceType | varchar Displays the device type. |
Badge |
| DeviceVersion | varchar Displays the device version. |
B3000N |
| UserName | varchar Displays the internal user id. If the device is a telephone, this is the phone number. |
u-jsmith |
| UserDisplayName | varchar Displays the user display name if the device is not a telephone. |
John Smith |
| Site | varchar Displays the site details for the device if it is not a telephone. |
MySiteName |
| GlobalSessionId | varchar Displays the global session id. |
|
| SessionId | int Displays the session id. This is useful for the Vocera support team when debugging. |
|
| SpeechPort | int Displays the speech port address or number. |
27 |
| SpeechAttempt | int Displays the number of speech attempts. |
|
| Result | varchar Displays the result - for example: No Match, Maxtime, Success. |
No Match |
| SessionStartedAt | timestamp Displays the date and time at which the session was started. |
2017-11-17 16:47:04 |
| SpeechStartedAt | timestamp Displays the date and time at which speech was started. |
2017-11-17 16:47:04 |
| SpeechFinishedAt | timestamp Displays the date and time at which speech was finished. |
2017-11-17 16:47:04 |
| SpeechRecognizedAt | timestamp If any speech was recognized, displays the date and time at which this happened. |
2017-11-17 16:47:04 |
| SessionFinishedAt | timestamp Displays the date and time at which the session was finished. |
2017-11-17 16:47:04 |
| OnlineSessionID | int Displays the online session id. This is useful for the Vocera support team when debugging. |
|
| AccessPoint | varchar Displays the access point as a hexadecimal number. Defined only when the device is not a telephone. |
b4a4e3b4a95e |
| BatteryStateOfCharge | int This field is for future use only. |
|
| BatchId | int This field is for future use only, and is currently set to 0. |
|
| RowCreatedTS | timestamp Displays the date and time at which the table row was created. |
2017-12-05 23:52:54 |
| DeviceSite | varchar Displays the device's home site. |
MyDeviceSite |
| DeviceSerialNo | varchar Displays the device's serial number. |
H5AB153011C5 |
| UserSite | varchar Displays the user's home site. |
MyUserSite |
| Location | varchar Displays the element/device location. |
Customer Support |
| UserType | varchar Displays the type of user. |
|
| SpeechDuration | bigint Specifies the speech duration in the Genie session, in seconds. |
This guide last modified:
2021-04-23 06:46.
.