Brightspace Data Sets for Assignments

Brightspace Data Sets for Assignments include:

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

Entity Relationship Diagram for the Assignment tables

 

Brightspace Data Set: Turnitin Submissions

About

Returns details of assignment submissions shared with Turnitin.

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.6 / 4.1

DropboxId

Unique assignment identifier.

BigInteger

8

FK

3.6 / 4.1 SubmissionId Unique assignment submission identifier

BigInteger

8

PK
3.6 / 4.1

FileId

Unique file identifier.

Integer

4

PK

3.6 / 4.1

LastSubmissionDate

Most recent submission time stamp (UTC). Field can be null.

DateTime

8

 

3.6 / 4.1 SubmissionStatus Status of assignment submission Integer 4  
3.6 / 4.1 SubmissionErrorType Type of submission error Integer 4  
3.6 / 4.1 ErrorMessage Error message upon submission if applicable. Field can be null. String    
3.6 / 4.1 SubmittedBy UserId of user who submitted the assignment to Turnitin. Field can be null. Integer 4 FK
3.6 / 4.1 LastRefreshDate Most recent submission refresh time stamp (UTC). Field can be null. DateTime 8  

 

Brightspace Data Set: Assignment Submission Details

About

Returns details of each individual submission made by the user for all your org units. Results are ordered from newest to oldest.

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 - Removed FK

SubmissionId

Unique submission identifier

BigInteger

8

PK

1.0

DropboxId

Unique assignment identifier

BigInteger

8

FK

4.7 / 5.1 - Removed FK

UserId

Unique user identifier. Field can be null

BigInteger

8

 

4.7 / 5.1 - Removed FK

GroupId

Unique group identifier for the submission made to the assignment. Field can be null

Integer

4

 

1.0

NumberOfFilesSubmitted

Number of files submitted

BigInteger

8

 

1.0

TotalFileSize

Total file size of all submissions made

BigInteger

8

 

1.0

SubmittedByUserId

Submission made by user ID

Integer

4

FK

1.0

Updated description

DateSubmitted

Date the submission was made (UTC). Field can be null

DateTime

8

 

1.0

Comments

Comments on the submission. Field can be null

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L.

 

1.0

Updated description

IsTurnItInExempt

Is exempt from TurnItIn. Field can be null

Boolean

1

 

1.0

IsDeleted

Is submission deleted

Boolean

1

 

1.0

IsPreview

Is submission preview

Boolean

1

 

 

Brightspace Data Set: Assignment Submissions

About

Returns a high-level summary information of all submissions made by a user to a given assignment for all your org units. Results are ordered from newest to oldest.

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

DropboxId

Unique assignment identifier

BigInteger

8

PK, FK

 

1.0

OrgUnitId

Unique org unit identifier

Integer

4

FK

5.0 – Added SubmitterId The user or group ID of the submitter BigInteger 8 PK, FK

4.9 / 5.3 - Corrected Field name

SubmitterType The type submission, either user or group. Field can be null nvarchar 25  
1.0

FileSubmissionCount

Number of files submitted to the assignment

Integer

4

 

1.0

TotalFileSize

Total file size of all submissions

BigInteger

8

 

4.7 / 5.1 - Removed FK

FeedbackUserId

Feedback by user ID. Field can be null

Integer

4

 

1.0

FeedbackIsRead

Is feedback read

Boolean

1

 

4.8 / 5.2 - Updated column size

Score

Score the user achieved on the assignment submission. Field can be null

Numeric

19, 9

 

1.0

IsGraded

Is assignment submission graded

Boolean

1

 

1.0

LastSubmissionDate

Last submission date time (UTC). Field can be null

DateTime

8

 

1.0 - Updated description

Feedback

Instructor feedback. Field can be null

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L.

 

1.0

FeedbackLastModified

Feedback last modified date time (UTC). Field can be null

DateTime

8

 

1.0

FeedbackReadDate

Feedback read date (UTC). Field can be null

DateTime

8

 

3.2 CompletionDate Indicates the date when the assignment was submitted by the learner (UTC). Field can be null DateTime 8  

 

Brightspace Data Set: Assignment Summary

About

Returns information on the assignments 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

DropboxId

Unique assignment identifier

BigInteger

8

PK

1.0

OrgUnitId

Unique org unit identifier

Integer

4

FK

1.0

Name

Assignment name

nvarchar

256

 

1.0

Category

Assignment category

nvarchar

256

 

1.0

Type

Individual/group assignment

String

10

 

1.0

GradeItemId

Unique grade item identifier. Field can be null.

BigInteger

8

FK

4.8 / 5.2 - Updated column size

PossibleScore

Possible score a user can achieve on the assignment. Field can be null.

Numeric

19, 9

 

1.0

StartDate

Assignment availability start date. Field can be null (UTC).

DateTime

8

 

1.0

EndDate

Assignment availability end date. Field can be null (UTC).

DateTime

8

 

1.0

DueDate

Assignment due date. Field can be null (UTC)

DateTime

8

 

1.0

IsRestricted

Is assignment restricted

Boolean

1

 

1.0

IsDeleted

Is assignment deleted

Boolean

1

 

1.0

TurnItInEnabled

Is TurnItIn enabled

Boolean

1

 

1.2 - Added IsHidden True or false value indicating whether the assignment is hidden. Boolean 1  
2.2 - Added SortOrder Display sort order used for the content objects Integer 4  
3.2 - Added SubmissionType Indicates the format submission type for the assignment being submitted. Values for this column include File, Text, On Paper, and Observed. String 18  
3.2 - Added CompletionType Indicates how the assignment was completed. Values for this column include OnSubmission, DueDate, ManuallyByLearner, and OnEvaluation. String 27  
4.9 / 5.3 - Added ResultId Unique release condition result identifier. Field can be null. Integer 4 FK