Grades and assessment

Assignment Summary data set: columns, keys and joins

Primary key: DropboxId 24 columns

Checked against D2L on October 31, 2026

Columns

Column	Type	Size	Key
`DropboxId`	`bigint`	`8`	PK
`OrgUnitId`	`int`	`4`	FK
`Name`	`nvarchar`	`128`
`Category`	`nvarchar`	`128`
`Type`	`varchar`	`10`
`GradeItemId`	`bigint`	`8`	FK
`PossibleScore`	`decimal`	`19, 9`
`StartDate`	`datetime2`	`8`
`EndDate`	`datetime2`	`8`
`DueDate`	`datetime2`	`8`
`IsRestricted`	`bit`	`1`
`IsDeleted`	`bit`	`1`
`TurnItInEnabled`	`bit`	`1`
`IsHidden`	`bit`	`1`
`SortOrder`	`int`	`4`
`SubmissionType`	`varchar`	`18`
`CompletionType`	`varchar`	`27`
`ResultId`	`int`	`4`	FK
`CategoryId`	`bigint`	`8`
`Version`	`bigint`	`8`
`StartDateAvailabilityType`	`smallint`	`2`
`EndDateAvailabilityType`	`smallint`	`2`
`AIUtilization`	`int`	`4`
`Instructions`	`nvarchar`	`10000`

None

GradeItemId: Marked as a foreign key by D2L, without a stated target data set.
ResultId: Marked as a foreign key by D2L, without a stated target data set.