Brightspace Data Sets for Announcements

Brightspace Data Sets for Announcements include:

This data set has 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

To show the relationships between entities used to create Brightspace Data Sets for Announcements, click the following thumbnail image:

Entity Relationship Diagram for Announcements

 

Brightspace Data Set: Announcements

About

Returns details on the announcements a user has created for your org units.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

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