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 version 2.

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.

bigint

8

FK

3.6 / 4.1 SubmissionId Unique assignment submission identifier

bigint

8

PK
3.6 / 4.1

FileId

Unique file identifier.

int

4

PK

3.6 / 4.1

LastSubmissionDate

Most recent submission time stamp (UTC).

Field can be null.

datetime2

8

 

3.6 / 4.1 SubmissionStatus Status of assignment submission smallint 2  
3.6 / 4.1 SubmissionErrorType Type of submission error smallint 2  
3.6 / 4.1 ErrorMessage

Error message upon submission if applicable.

Field can be null.

nvarchar 255  
3.6 / 4.1 SubmittedBy

UserId of user who submitted the assignment to TurnItIn.

Field can be null.

int 4 FK
3.6 / 4.1 LastRefreshDate

Most recent submission refresh time stamp (UTC).

Field can be null.

datetime2 8  
6.6 LastModified

Last time the submission was modified (UTC).

Field can be null.

datetime2 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

bigint

8

PK

1.0

DropboxId

Unique assignment identifier

bigint

8

FK

4.7 / 5.1 - Removed FK

UserId

Unique user identifier.

Field can be null.

bigint

8

 

5.7 / 6.0 - Changed Type and Column Size

GroupId

Unique group identifier for the submission made to the assignment.

Field can be null.

bigint

8

 

5.7 / 6.0 - Changed Type and Column Size

NumberOfFilesSubmitted

Number of files submitted.

Field can be null.

int

4

 

1.0

TotalFileSize

Total file size of all submissions made

bigint

8

 

1.0

SubmittedByUserId

Submission made by user ID

int

4

FK

1.0

DateSubmitted

Date the submission was made (UTC).

Field can be null.

datetime2

8

 

1.0

Comments

Comments on the submission.

Field can be null.

nvarchar

1000

 

1.0

IsTurnItInExempt

Is exempt from TurnItIn.

Field can be null.

bit

1

 

1.0

IsDeleted

Is submission deleted

bit

1

 

1.0

IsPreview

Is submission preview

bit

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

bigint

8

PK, FK

 

1.0

OrgUnitId

Unique org unit identifier

int

4

FK

5.0 SubmitterId The user or group ID of the submitter. bigint 8 PK, FK

5.7 / 6.0 - Changed Column Size

SubmitterType

The type submission, either user or group.

Field can be null.

varchar 5  
1.0

FileSubmissionCount

Number of files submitted to the assignment

int

4

 

1.0

TotalFileSize

Total file size of all submissions

bigint

8

 

4.7 / 5.1 - Removed FK

FeedbackUserId

Feedback by user ID.

Field can be null.

int

4

 

1.0

FeedbackIsRead

Is feedback read

bit

1

 

4.8 / 5.2 - Updated column size

Score

Score the user achieved on the assignment submission.

Field can be null.

decimal

19, 9

 

1.0

IsGraded

Is assignment submission graded

bit

1

 

1.0

LastSubmissionDate

Last submission date time (UTC).

Field can be null.

datetime2

8

 

1.0 - Updated description

Feedback

Instructor feedback.

Field can be null.

nvarchar

1000

 

1.0

FeedbackLastModified

Feedback last modified date time (UTC).

Field can be null.

datetime2

8

 

1.0

FeedbackReadDate

Feedback read date (UTC).

Field can be null.

datetime2

8

 

3.2 CompletionDate

Indicates the date when the assignment was submitted by the learner (UTC).

Field can be null.

datetime2 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

bigint

8

PK

1.0

OrgUnitId

Unique org unit identifier

int

4

FK

5.7 / 6.0 - Changed Column Size

Name

Assignment name

nvarchar

128

 

5.7 / 6.0 - Changed Column Size

Category

Assignment category.

Field can be null.

nvarchar

128

 

1.0

Type

Individual/group assignment

varchar

10

 

1.0

GradeItemId

Unique grade item identifier.

Field can be null.

bigint

8

FK

4.8 / 5.2 - Updated column size

PossibleScore

Possible score a user can achieve on the assignment.

Field can be null.

decimal

19, 9

 

1.0

StartDate

Assignment availability start date (UTC).

Field can be null.

datetime2

8

 

1.0

EndDate

Assignment availability end date (UTC).

Field can be null.

datetime2

8

 

1.0

DueDate

Assignment due date (UTC).

Field can be null.

datetime2

8

 

1.0

IsRestricted

Is assignment restricted

bit

1

 

1.0

IsDeleted

Is assignment deleted

bit

1

 

1.0

TurnItInEnabled

Is TurnItIn enabled

bit

1

 

1.2 IsHidden True or false value indicating whether the assignment is hidden. bit 1  
2.2 SortOrder Display sort order used for the content objects int 4  
3.2 SubmissionType Indicates the format submission type for the assignment being submitted. Values for this column include File, Text, On Paper, and Observed. varchar 18  
3.2 CompletionType Indicates how the assignment was completed. Values for this column include OnSubmission, DueDate, ManuallyByLearner, and OnEvaluation. varchar 27  
4.9 / 5.3 ResultId

Unique release condition result identifier.

Field can be null.

int 4 FK
5.9 / 6.2 CategoryId

Unique category identifier for the assignment.

Field can be null.

bigint 8  
6.8 Version

Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets.

bigint 8  

Brightspace Data Set: Assignment Special Access

About

Returns all applicable special access start, end, and due dates for each assignment 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

5.8/6.1 DropboxId Unique assignment identifier bigint 8 PK,FK
5.8/6.1 UserId

Unique user identifier.

int 4 PK,FK
5.8/6.1 StartDate

Assignment special access availability start date (UTC).

Field can be null.

datetime2 8  
5.8/6.1 EndDate

Assignment special access availability end date (UTC).

Field can be null.

datetime2 8  
5.8/6.1 DueDate

Assignment special access due date (UTC).

Field can be null.

datetime2 8  
5.8/6.1 ModifiedBy User who modified the assignment special access. int 4 FK
5.8/6.1 LastModified Date when the special access was last modified for the assignment (UTC) datetime2 8  
5.8/6.1 IsDeleted Indicates if special access has been deleted. bit 1