This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Vocera Voice Server Fact Tables | |
Stores data about telephony activities.
| Column | Description | Example |
|---|---|---|
| TxMillis | bigint Gives each row in the table a unique identifier. The value represents the number of milliseconds since January 1, 1970 (a date specified for internal use by the report system). Because of the uniqueness constraint, it may not reflect the exact actual date |
1507530224921 |
| TxDateTime | datetime Stores the date and time of the event, accurate to the second. |
2017-10-08 23:23:44 |
| TxDate | date Stores the date of an event, accurate to the day. |
2017-10-08 |
| TelephonyId | bigint Identifies a telephony log entry. |
12989 |
| UserType | varchar Specifies which type of user initiated the call. |
User |
| UserID | varchar Specifies the user ID of the person who initiated the call. When the UserType value is User, this value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Server. |
JSmith |
| UserSite | varchar Specifies the Vocera site with which the calling party is associated. |
Mysitename |
| PrimarySite | varchar Specifies the Vocera site with which the VSTG array is associated. |
S-Mysitename |
| TotalLines | bigint The total number of lines allocated to the primary site. |
48 |
| AvailableLines | bigint The number of lines available at the primary site. |
47 |
| SharingSite | varchar Specifies the Vocera site to which the call is sent or from which the call is made. |
S-Mysharingsite |
| CallType | varchar Specifies the call type: Incoming, Outgoing, Disconnect, or GatewayFailed |
Incoming |
| IdCall | bigint Identifies a call placed or received through the Vocera system. However, this value is not guaranteed to be unique. Any given call could have the same IdCall value as another call that took place earlier or later. |
3216 |
| userUID | varchar Specifies the Vocera Voice Server internal user id of the person who initiated the call. When the UserType value is User, this value is the internal user id. |
u-jsmith |
| userDisplayName | varchar Specifies the user Display Name of the person who initiated the call. When the UserType value is User, this value corresponds to a LastName,FirstName specified via the Administration Console or the User Console on the Vocera Server. |
Smith, John |
This guide last modified:
2021-04-23 06:46.
.