Brightspace Data Sets for Announcements have a dependency on Announcements. 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 Announcements. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Announcements
The Announcements Brightspace Data Set returns details on the announcements a user has created for your org units.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.0 |
AnnouncementId
|
Unique announcement identifier
|
bigint
|
8
|
PK
|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
bigint
|
8
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
Title
|
Announcement title
|
nvarchar
|
400
|
|
| 1.0 |
StartDate
|
First time the announcement is visible (UTC).
|
datetime2
|
8
|
|
|
1.0
|
EndDate
|
Last date the announcement is visible (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
IsGlobal
|
If new items are visible across orgs
|
bit
|
1
|
|
| 1.0 |
IsDraft
|
If in draft, then the announcement has not been published yet
|
bit
|
1
|
|
| 1.0 |
NumAttachments
|
Number of attachments
|
int
|
4
|
|
| 1.0 |
DeletedDate
|
Date the announcement was deleted (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
DeletedByUserId
|
Deleted by user ID.
Field can be null.
|
int
|
4
|
FK
|
| 1.0 |
LastModified
|
Last modified date/time (UTC).
|
datetime2
|
8
|
|
| 4.7 / 5.1 |
LastModifiedBy |
User who last modified the announcement.
Field can be null.
|
int |
4 |
|
| 4.7 / 5.1 |
CreatedBy |
User who created the announcement.
Field can be null.
|
int |
4 |
|
| 4.7 / 5.1 |
IsAuthorInfoShown |
If author information is displayed. |
bit |
1 |
|
| 4.7 / 5.1 |
CreatedDate |
Date the announcement was created (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 5.7 / 6.0 |
ResultId |
Unique release condition result identifier.
Field can be null.
|
bigint |
8 |
FK |