This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Database View Tables | |
The VMP users database view.
| Column | Description | Example |
|---|---|---|
| Id | int Displays the unique id for this user. |
5 |
| VoceraId | varchar Displays the Vocera id. |
u-jsmith |
| VstId | varchar Displays the Vocera Secure Texting id if it exists. |
2208 |
| Active | tinyint Displays 1 if the user is active or 0 otherwise. |
1 |
| Created | timestamp Displays the date and time that this user was created. |
2017-02-19 23:21:23 |
| Updated | timestamp Displays the date and time that this user was last updated. |
2017-11-30 23:01:08 |
| Deactivated | timestamp If the user has been deactivated, displays the date and time of deactivation. |
2017-11-07 21:49:40 |
| FirstName | varchar Displays the user's first name. |
John |
| MiddleName | varchar Displays the user's middle name, if there is one. |
|
| LastName | varchar Displays the user's last name. |
Smith |
| DeviceRoute | int Displays the details of the device route. |
14 |
| ClientVersion | varchar Displays the client version. |
3.0.3.524 iOS |
| LastActivity | timestamp Displays the time and date of the last use or activity. |
2017-11-02 21:50:16 |
| LastDeviceActivity | timestamp Displays the time and date of the last device activity. |
2017-11-02 21:50:16 |
| RemoteId | varchar Displays the remote id. |
|
| DisplayName | varchar The display name for the element/user. |
John Smith |
| EmailId | varchar Displays the email id for the user. |
jsmith@companyname.com |
| DeviceId | varchar Displays the device id. |
|
| SiteId | int Displays the site id. |
5 |
| FileId | int Displays the file id. |
|
| department | varchar Displays the department. |
g-icu |
This guide last modified:
2021-04-23 06:46.
.