Brightspace Data Sets for Email have a dependency on Brightspace Email. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Email. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Brightspace Email Log
The Brightspace Email Log Brightspace Data Set provides a log of Brightspace emails sent, with each entry representing an email sent to a single recipient from within Brightspace.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 10.11 / 11.1 |
MailId |
Unique mail identifier. |
int |
4 |
PK |
| 10.11 / 11.1 |
SenderUserId |
Unique user identifier of the sender. |
int |
4 |
FK |
| 10.11 / 11.1 |
SenderAddress |
Sender's email address.
|
nvarchar |
256 |
|
| 10.11 / 11.1 |
RecipientAddress |
Recipient's email address. |
nvarchar |
256 |
PK |
| 10.11 / 11.1 |
RecipientType |
Whether recipient added to To, Cc, or Bcc field. |
nvarchar |
4 |
|
| 10.11 / 11.1 |
DateTimeSent |
The date when the email was sent (UTC).
|
datetime2 |
8 |
|
| 10.11 / 11.1 |
Subject |
The subject line of the email, truncated to 1000 characters.
Field can be null.
|
nvarchar |
1000 |
|