| Database Schema Tables / Vocera Voice Server Fact Tables | |
Fact table delivering detailed insight on information about email messages and their variables.
| Column | Description | Example |
|---|---|---|
| TenantID | int This field is for future use only, and is currently not defined. |
|
| StartedAt | timestamp Displays the date and time at which the email message was started. |
2017-12-18 11:54:53 |
| SenderName | varchar The name of the person who initiated the email message activity. |
jsmith |
| SenderEmailId | varchar The email address of the person who initiated the email message activity. |
jsmith@companyname.com |
| ReceiverType | varchar The receiver type (User or Group). |
User |
| ReceiverId | varchar The internal id for the email message. |
u-jsmith |
| Priority | varchar Specifies the priority name of the email message. Can be NORMAL or URGENT. |
NORMAL |
| PriorityId | int Specifies the priority id of the email message. This can be 0 or 1. |
0 |
| ReceiverSite | varchar The name of the receiver site for the email message. |
MySiteName |
| receiverDisplayName | varchar The receiver display name for the email message. |
Doe, Jane |
| groupDepartment | varchar Displays a comma-separated list of group departments. |
|
| userDepartments | varchar Displays a comma-separated list of user departments. |
|
| groupMembers | varchar Displays a comma-separated list of user internal IDs. |