fctemailmessages

Fact table delivering detailed insight on information about email messages and their variables.

Table 1. fctemailmessages table
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.