Brightspace Data Sets for Awards

Brightspace Data Sets for Awards include:

These data sets have a dependency on Awards. 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 Awards, click the following thumbnail image:

Entity Relationship Diagram for Awards

 

Brightspace Data Set: Awards Issued

About

Returns a list of all the awards that have been issued 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

2.5/3.0 - Added FK

AwardId

Unique award identifier

BigInteger

8

FK

1.4 - Removed Primary Key designation

OrgUnitId

Unique org unit identifier

BigInteger

4

FK

1.4 - Removed Primary Key designation

UserId

Unique user identifier

BigInteger

8

FK

1.0

Type

Award type

nvarchar

256

 

1.0

IssuedBy

Issued by user ID

Integer

4

FK

1.0

IssueDate

Award issue date (UTC)

DateTime

8

 

1.0

ExpiryDate

Award expiry date. Field can be null.(UTC)

DateTime

8

 

1.0

IsRevoked

Is award revoked

Integer

1

 

1.4 - Added IssuedId Unique issued identifier BigInteger 8 PK
3.2 - Added Credits Indicates if the award has credits, and how many. Decimal

9

 

 
3.4 - Added Criteria Indicates the criteria necessary to issue the award. nvarchar Unlimited  
3.4 - Added Evidence Provides the proof that the user has met the criteria for the award. nvarchar Unlimited  

 

Brightspace Data Set: Course Awards

About

Returns a list of all the awards that exist in each course for all 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. Note that differentials reset when switching from Brightspace Data Sets 3.0 to Brightspace Data Sets 4.0, or from Brightspace Data Sets 4.0 back to Brightspace Data Sets 3.0.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

1.4 - Added AssociationId Unique association identifier BigInteger 8 PK
1.0

AwardId

Unique award identifier

BigInteger

8

 

1.0

OrgUnitId

Unique org unit identifier

BigInteger

8

FK

1.0 DateCreated Date when the award was created. (UTC)

DateTime

8

 
4.0 HiddenAward Award is hidden from learner view Boolean 1  
4.0 ConditionSetId Identifier for the conditions that need to be met in order to issue this award. Field can be null. Biginteger 8  

Brightspace Data Set: Award Objects

About

Returns details on all awards were created anywhere in the organization.

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

3.4

AwardId

Unique award identifier

BigInteger

8

PK

3.4 Name Award name nvarchar 512  
3.4

AwardTypeId

Award type identifier

Integer

4

 

5.5 - Update to column size

Type

Award type (Certificate or Badge)

nvarchar

256

 

3.4 Description Description of the award nvarchar Truncated to 1000 characters. To change the default value, contact D2L.  
3.4 ExpiryCalculationType Calculation type for expiry of award nvarchar 256  
3.4

ExpiryNotificationType

Time unit for expiry notification (such as days)

nvarchar

256

 

3.4 ExpiryDate Date when the award is scheduled to expire. Can be NULL if the award never expires.

DateTime

8

 
3.4 ImagePath Indicates the location where the award image is stored varchar Unlimited  
3.4

CreatedbyUserId

User who created the award

BigInteger

8

 

3.4

LastModified

Date award was last changed (UTC)

DateTime

8

 

3.4 IsDeleted Indicates whether the award is deleted Boolean 1