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. |