Survey Attempts data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
AttemptId | bigint | 8 | PK |
SurveyId | bigint | 8 | FK |
UserId | int | 4 | FK |
OrgUnitId | int | 4 | FK |
AttemptNumber | int | 4 | |
TimeStarted | datetime2 | 8 | |
TimeCompleted | datetime2 | 8 | |
AttemptedFromOrgUnitId | int | 4 | FK |
OldAttemptNumber | int | 4 | |
IsDeleted | bit | 1 | |
Version | bigint | 8 |
Joins to (3)
- Organizational Units
OrgUnitId→OrgUnitId - Survey Objects
SurveyId→SurveyId - Users
UserId→UserId
Joined from (2)
- Survey User Answer Responses
AttemptId→AttemptId - Survey User Answers
AttemptId→AttemptId
Edit history links
None
Foreign keys without a stated target
AttemptedFromOrgUnitId: Marked as a foreign key by D2L, without a stated target data set.