Brightspace Data Sets for Exemptions

Brightspace Data Sets for Exemptions include:

This data set has a dependency on Grades. 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 Exemptions, click the following thumbnail image:

Activity Exemptions Logs Entity Relationship Diagram

 

Brightspace Data Set: Activity Exemptions Log

About

Returns details on the exemptions a user has created for your organization 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

5.7 / 6.0 - Changed Type and Column Size OrgUnitId Unique org unit identifier int 4 FK
5.7 / 6.0 - Changed Type and Column Size UserId Unique user identifier. int 4 FK
1.6 ObjectId

Unique identifier of the object with an exemption.

Field can be null.

int 4  
1.6 ActivityId Unique identifier for an activity associated with the exemption varchar 225  
1.6 LogTypeName

Name of log type.

Field can be null.

varchar 50  
1.6 LastModifiedUtc Time of the last log entry (UTC). datetime2 8  
5.7 / 6.0 - Changed Type and Column Size LastModifiedBy

User ID of user who last modified the exemption.

Field can be null.

int 4 FK
1.6

ActivityExemptionsLogId

Unique exemptions log identifier

bigint

8

PK

4.7 / 5.1 - Updated description

ToolId Unique identifier for the tool with an exemption int 4 FK