Brightspace Data Sets for Assignments 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
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Assignments. To enlarge the diagram, right-click on the image and select Open image in a new tab.
About Availability Type
Availability type determines whether learners can view or access assignments. Possible column values and their meanings are:
| Value |
Availability type |
|---|
| 0 |
AccessRestricted
|
| 1 |
SubmissionRestricted
|
| 2 |
Hidden
|
Assignment Special Access
The Assignment Special Access Brightspace Data Set returns all applicable special access start, end, and due dates for each assignment in the organization.
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 |
|
| 7.13 |
StartDateAvailabilityType |
Determines whether learners can view or access the assignment before the StartDate. See About Availability Type for details.
No data available for assignments created before December 2022/20.22.12.
Field can be null.
|
smallint |
2 |
|
| 7.13 |
EndDateAvailabilityType |
Determines whether learners can view or access the assignment after the EndDate. See About Availability Type for details.
No data available for assignments created before December 2022/20.22.12.
Field can be null.
|
smallint |
2 |
|
Assignment Submission Details
The Assignment Submission Details Brightspace Data Set returns details of each individual submission made by the user for all your org units. Results are ordered from newest to oldest.
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
|
|
| 6.14 / 7.2 - Updated Description |
TotalFileSize
|
Total file size of all submissions made, in bytes.
|
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
|
|
Assignment Submissions
The Assignment Submissions Brightspace Data Set 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.
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
|
|
| 6.14 / 7.2 - Updated Description |
TotalFileSize
|
Total file size of all submissions, in bytes.
|
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
|
|
| 6.16 / 7.4 - Updated description |
FeedbackLastModified
|
Last modified date time for draft and published feedback (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 6.16 / 7.4 - Updated description |
FeedbackReadDate
|
First date time that feedback is read (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 |
|
Assignment Summary
The Assignment Summary Brightspace Data Set returns information on the assignments for your org units.
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 |
|
| 7.13 |
StartDateAvailabilityType |
Determines whether learners can view or access the assignment before the StartDate. Refer to About Availability Type for details.
All assignments with start dates created before December 2022/20.22.12 have default value '0'.
Field can be null.
|
smallint |
2 |
|
| 7.13 |
EndDateAvailabilityType |
Determines whether learners can view or access the assignment after the EndDate. Refer to About Availability Type for details.
All assignments with end dates created before December 2022/20.22.12 have default value '0'.
Field can be null.
|
smallint |
2 |
|
| 9.9 |
AIUtilization |
Indicates whether D2L Lumi (Brightspace AI) capabilities were used and the level of AI involvement. Possible values:
0 - No AI capabilities were involved.
1 - Generated by AI and reviewed by a human.
2 - Generated by AI and edited by a human.
3 - Assisted or uplifted by AI.
|
int |
4 |
|
TurnItIn Submissions
The TurnItIn Submissions Brightspace Data Set returns details of assignment submissions shared with TurnItIn version 2.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 3.6 / 4.1 |
DropboxId
|
Unique assignment identifier.
|
bigint
|
8
|
FK
|
| 8.9 - Changed Key |
SubmissionId |
Unique assignment submission identifier. |
bigint
|
8
|
PK, FK |
| 7.15 / 8.1 - Changed Type and Column Size |
FileId
|
Unique file identifier.
|
bigint
|
8
|
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. Possible values: 0 - Assignment has not been submitted. 1 - Assignment is pending retrieval. 2 - Assignment has been submitted. 3 - An error has occurred 4 - Assignment is pending Originality report. 5 - Assignment's Originality report is complete. 6 - Assignment has been deleted. 7 - The assignment's deletion has been canceled. |
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 |
|