Grades and assessment

Grade Results data set: columns, keys and joins

Primary key: GradeObjectIdOrgUnitIdUserId 17 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`GradeObjectId`	`int`	`4`	PK, FK
`OrgUnitId`	`int`	`4`	PK, FK
`UserId`	`int`	`4`	PK, FK
`PointsNumerator`	`decimal`	`19, 9`
`PointsDenominator`	`decimal`	`19, 9`
`WeightedNumerator`	`decimal`	`19, 9`
`WeightedDenominator`	`decimal`	`19, 9`
`IsReleased`	`bit`	`1`
`IsDropped`	`bit`	`1`
`LastModified`	`datetime2`	`8`
`LastModifiedBy`	`int`	`4`	FK
`Comments`	`nvarchar`	`1000`
`PrivateComments`	`nvarchar`	`1000`
`GradeText`	`nvarchar`	`50`
`GradeReleasedDate`	`datetime2`	`8`
`Version`	`bigint`	`8`
`IsDeleted`	`bit`	`1`

Joins to (3)

Grade ObjectsGradeObjectId → GradeObjectId
Organizational UnitsOrgUnitId → OrgUnitId
UsersUserId → UserId

Joined from (0)

None

Edit history links

UsersLastModifiedBy → UserId

Source

Source: Grades data sets on the D2L Brightspace Community