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

BigInteger

8

PK

1.0

OrgUnitId

Unique org unit identifier

BigInteger

8

FK

1.0

Title

Announcement title

nvarchar

800

 

1.0

StartDate

First time the announcement is visible (UTC)

DateTime

8

 

1.0

Updated description.

EndDate

Last date the announcement is visible (UTC). Field can be null

DateTime

8

 

1.0

IsGlobal

If new items are visible across orgs

Boolean

1

 

1.0

IsDraft

If in draft, then the announcement has not been published yet

Boolean

1

 

1.0

HasReleaseCondition

Has associated release condition

Boolean

1

 

1.0

NumAttachments

Number of attachments

Integer

4

 

1.0

DeletedDate

Date (UTC) the announcement was deleted. Field can be null

DateTime

8

 

1.0

DeletedByUserId

Deleted by user ID. Field can be null

Integer

4

FK

1.0

LastModified

Last modified date/time (UTC).

DateTime

8

 

4.7 / 5.1 LastModifiedBy User who last modified the announcement. Field can be null Integer 4  
4.7 / 5.1 CreatedBy User who created the announcement. Field can be null Integer 4  
4.7 / 5.1 IsAuthorInfoShown If author information is displayed. Boolean 1  
4.7 / 5.1 CreatedDate Date (UTC) the announcement was created. Field can be null DateTime 8