Brightspace Data Sets for Grades have 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
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Grades. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Grade Book Settings
The Grade Book Settings Brightspace Data Set returns all the grade book settings for your org units.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK,
FK
|
| 2.5 / 3.0 - Removed FK |
GradeSchemeId
|
Unique grade scheme identifier
|
bigint
|
8
|
PK
|
| 5.7 / 6.0 - Changed Column Size |
GradingSystem
|
Type of grading system setup for the course
|
varchar
|
8
|
|
| 5.7 / 6.0 - Changed Column Size |
UngradedItems
|
Drop ungraded items/Treat them as 0
|
varchar
|
25
|
|
| 1.0 |
IsAdjustedFinalGradeReleased
|
Is final adjusted grade released to user.
Field can be null.
|
bit
|
1
|
|
| 1.0 |
IsCalculatedFinalGradeReleased
|
Is calculated adjusted grade released to user.
Field can be null.
|
bit
|
1
|
|
| 6.7 |
LastModified |
Date gradebook settings were last modified (UTC).
Field can be null.
|
datetime2 |
8 |
|
Grade Objects
The Grade Objects Brightspace Data Set returns a list of the grade objects created for your org units.
The data set returns a NULL grade scheme value when the grade item is using the default scheme.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
GradeObjectId
|
Unique grade object identifier
|
int
|
4
|
PK
|
| 1.0 |
OrgUnitId
|
Unique org unit identifier.
Field can be null.
|
int
|
4
|
FK
|
| 8.0 - Updated Description |
ParentGradeObjectId
|
Parent grade object identifier.
Note: Categories are considered Parent grade objects. Category names can be determined by using the ParentGradeObjectId and joining the data set to itself.
Field can be null.
|
int
|
4
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
Grade object name
|
nvarchar
|
128
|
|
| 1.0 |
TypeName
|
Grade object type name.
Field can be null.
|
varchar
|
50
|
|
| 1.0 |
StartDate
|
Start date for the grade object (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
EndDate
|
End date for the grade object (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
IsAutoPointed
|
Indicates if the object is automatically pointed. If this contains a value, the object automatically has points assigned; if it is set to 0, then the grade object must manually have points assigned.
|
bit
|
1
|
|
| 1.0 |
IsFormula
|
Is a formula associated with the grade object
|
bit
|
1
|
|
| 1.0 |
IsBonus
|
Is bonus grade
|
bit
|
1
|
|
| 4.8 / 5.2 - Updated column size |
MaxPoints
|
Maximum points achievable in this grade
|
decimal
|
19, 9
|
|
| 1.0 |
CanExceedMaxGrade
|
Can user get more than maximum points
|
bit
|
1
|
|
| 1.0 |
ExcludeFromFinalGradeCalc
|
Is grade excluded from final grade calculation
|
bit
|
1
|
|
|
3.2 - Updated description
|
GradeSchemeId
|
Unique grade scheme identifier. This column returns a null result when the grade item is set to use default scheme. This is intended.
Field can be null.
|
bigint
|
8
|
|
| 4.8 / 5.2 - Updated column size |
Weight
|
Weight associated with the grade.
Field can be null.
|
decimal
|
19, 9
|
|
| 1.0 |
NumLowestGradesToDrop
|
Drop number of lowest grades from the calculated grade
|
int
|
4
|
|
| 1.0 |
NumHighestGradesToDrop
|
Drop number of highest grades from the calculated grade
|
int
|
4
|
|
| 5.7 / 6.0 - Changed Column Size |
WeightDistributionType
|
Grade weight distribution within category.
Field can be null.
|
varchar
|
8
|
|
| 1.0 |
CreatedDate |
Date the grade was created (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 5.7 / 6.0 - Changed Column Size |
ToolName
|
Tool associated with the object.
Field can be null.
|
nvarchar
|
50
|
|
| 1.0 |
AssociatedToolItemId
|
Unique activity ID associated with the grade object: Dropbox ID, Quiz ID, Discussion ID.
Field can be null.
|
bigint
|
8
|
|
| 1.1 |
LastModified |
Last time the grade was modified (UTC). |
datetime2 |
8 |
|
| 5.7 / 6.0 - Changed Column Size |
ShortName |
The item or category short name as per the corresponding field in Brightspace.
Field can be null.
|
nvarchar |
128 |
|
| 6.11 - Updated description |
GradeObjectTypeId |
ID of the grade object type.
Possible values:
-
Numeric = 1
-
Pass/Fail = 2
-
Select box = 3
-
Text = 4
-
Calculated = 5
-
Formula = 6
-
Final Calculated = 7
-
Final Adjusted = 8
-
Category = 9
|
int |
4 |
|
| 1.1 |
SortOrder |
Specified sort order of grade objects |
int |
4 |
|
| 1.10 |
IsDeleted |
Indicates if the grade object is deleted.
Field can be null.
|
bit |
1 |
|
| 1.10 |
DeletedDate |
Date the grade object was soft deleted.
Field can be null.
|
datetime2 |
8 |
|
| 5.7 / 6.0 - Changed Type and Column Size |
DeletedByUserId |
ID of the user who deleted the grade object.
Field can be null.
|
int |
4 |
FK |
| 5.5 |
ResultId |
Unique release condition result identifier.
Field can be null.
|
int |
4 |
FK |
Grade Objects Log
The Grade Objects Log Brightspace Data Set returns a log of all changes to grades for each applicable user in the organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 5.7 / 6.0 - Changed Type and Column Size |
LogId
|
Unique grade object log identifier.
|
bigint
|
8
|
PK
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
Name of the action.
Field can be null.
|
nvarchar
|
50
|
|
| 3.7 / 4.2 |
GradeObjectId
|
Grade object identifier.
|
int
|
4
|
FK
|
| 3.7 / 4.2 |
UserId |
Unique identifier of the user who completed the action. |
int |
4 |
FK
|
| 5.7 / 6.0 - Changed Column Size |
GradeSymbolString
|
Value of the grade.
Field can be null.
|
nvarchar
|
50
|
|
|
4.8 / 5.2 - Updated column size
|
PointsDenominator |
Total number of points possible.
Field can be null.
|
decimal
|
19, 9
|
|
|
4.8 / 5.2 - Updated column size
|
PointsNumerator |
Number of points received by user.
Field can be null.
|
decimal
|
19, 9
|
|
|
4.8 / 5.2 - Updated column size
|
WeightedDenominator |
Total number of points possible after weight is applied.
Field can be null.
|
decimal
|
19, 9
|
|
|
4.8 / 5.2 - Updated column size
|
WeightedNumerator |
Number of points received after weight is applied.
Field can be null.
|
decimal |
19, 9 |
|
| 3.7 / 4.2 |
Modified |
Date and time the action was made. |
datetime2 |
8 |
|
| 3.7 / 4.2 |
ModifiedBy |
User who modified the grade object.
Field can be null if done automatically.
|
int |
4 |
|
Grade Results
The Grade Results Brightspace Data Set returns data from the newest grade objects first.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
GradeObjectId
|
Unique grade object identifier
|
int
|
4
|
PK, FK
|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK, FK
|
| 1.0 |
UserId
|
Unique user identifier
|
int
|
4
|
PK, FK
|
| 4.8 / 5.2 - Updated column size |
PointsNumerator
|
Number of points received by user.
Field can be null.
|
decimal
|
19, 9
|
|
| 4.8 / 5.2 - Updated column size |
PointsDenominator
|
Total number of points possible.
Field can be null.
|
decimal
|
19, 9
|
|
| 4.8 / 5.2 - Updated column size |
WeightedNumerator
|
Number of points received after weight is applied.
Field can be null.
|
decimal
|
19, 9
|
|
| 4.8 / 5.2 - Updated column size |
WeightedDenominator
|
Total number of points possible after weight is applied.
Field can be null.
|
decimal
|
19, 9
|
|
| 7.13 - Updated description |
IsReleased
|
Is grade released.
Field can be null. For example, it is null when the grade object is not submitted.
|
bit
|
1
|
|
| 1.0 |
IsDropped
|
Is score dropped from final grade
|
bit
|
1
|
|
| 1.0 |
LastModified
|
Last time score was modified (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 5.7 / 6.0 - Changed Type and Column Size |
LastModifiedBy
|
User ID of user who last modified the grade object.
Field can be null.
|
int
|
4
|
FK
|
| 1.0 |
Comments
|
Comments.
Field can be null.
|
nvarchar
|
1000
|
|
| 1.0 |
PrivateComments
|
Private comments.
Field can be null.
|
nvarchar
|
1000
|
|
| 1.1 |
IsExempt |
Is exempt.
Field can be null.
|
bit |
1 |
|
| 1.6 |
GradeText |
Field can be null.
|
nvarchar |
50 |
|
| 3.2 |
GradeReleasedDate |
Date when the grade was released to the learner (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 3.2 |
Version |
Indicates the version of the grade result.
Field can be null.
|
bigint
|
8 |
|
Grade Schemes
The Grade Schemes Brightspace Data Set returns data about created grade schemes.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.4 - Added Primary Key designation |
GradeSchemeId |
Unique grade scheme identifier. |
bigint |
8 |
PK |
| 9.11 - Fixed nullability |
OrgUnitId |
Unique org unit identifier.
|
int |
4 |
FK |
| 5.7 / 6.0 - Changed Column Size |
SchemeName |
Grade scheme name |
nvarchar |
128 |
|
| 1.10 |
DeletedDate |
Date when the scheme was deleted (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 5.7 / 6.0 |
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 |
|
Grade Scheme Ranges
The Grade Schemes Ranges Brightspace Data Set describes the ranges used in grade schemes in the organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 5.7 / 6.0 |
GradeSchemeRangeId
|
Unique grade scheme range identifier.
|
bigint
|
8
|
PK, FK
|
| 5.7 / 6.0 |
GradeSchemeId
|
Unique grade scheme identifier.
|
bigint
|
8
|
PK, FK
|
| 5.7 / 6.0 |
SymbolString
|
The name of the range.
|
nvarchar
|
100
|
|
| 5.7 / 6.0 |
AssignedValue
|
The value assigned to the grade scheme range.
Field can be null.
|
decimal
|
19, 9
|
|
| 5.7 / 6.0 |
RangeStart
|
The starting value (in percent) of the grade scheme.
|
decimal
|
19, 9
|
|
| 5.7 / 6.0 |
IsDeleted
|
Indicates that the grade scheme is deleted
|
bit
|
1
|
|
| 5.7 / 6.0 |
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 |
|