Grades and assessment

Quiz Attempts data set: columns, keys and joins

Primary key: AttemptId 20 columns

Checked against D2L on October 31, 2026

Columns

Column	Type	Size	Key
`AttemptId`	`bigint`	`8`	PK
`QuizId`	`bigint`	`8`	FK
`UserId`	`int`	`4`	FK
`OrgUnitId`	`int`	`4`	FK
`AttemptNumber`	`int`	`4`
`TimeStarted`	`datetime2`	`8`
`TimeCompleted`	`datetime2`	`8`
`Score`	`decimal`	`19, 9`
`IsGraded`	`bit`	`1`
`OldAttemptNumber`	`int`	`4`
`IsDeleted`	`bit`	`1`
`PossibleScore`	`decimal`	`19, 9`
`IsRetakeIncorrectOnly`	`bit`	`1`
`DueDate`	`datetime2`	`8`
`TimeLimit`	`int`	`4`
`TimeLimitEnforced`	`bit`	`1`
`TimeLimitExceededBehaviour`	`nvarchar`	`128`
`IsSynchronous`	`bit`	`1`
`DeductionPercentage`	`int`	`4`
`Version`	`bigint`	`8`

None