Outcomes Demonstrations data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
DemonstrationId | uniqueidentifier | 16 | PK |
ExplicitlyEnteredScaleLevelId | uniqueidentifier | 16 | FK |
AutomaticallyGeneratedScaleLevelId | uniqueidentifier | 16 | FK |
AlignedObjectType | int | 4 | |
AlignedObjectId | nvarchar | 1000 | FK |
OutcomeId | uniqueidentifier | 16 | |
RegistryId | uniqueidentifier | 16 | |
IsPublished | bit | 1 | |
AssessedUserId | int | 4 | FK |
AssessedDate | datetime2 | 8 | |
AssessorUserId | int | 4 | FK |
LastModifiedDate | datetime2 | 8 | |
LastModifiedBy | int | 4 | FK |
IsDeleted | bit | 1 |
Joins to (0)
None
Joined from (1)
- Outcomes Assessed Checkpoints
DemonstrationId→DemonstrationId
Edit history links
- Users
LastModifiedBy→UserId
Foreign keys without a stated target
AlignedObjectId: Marked as a foreign key by D2L, without a stated target data set.AssessedUserId: Marked as a foreign key by D2L, without a stated target data set.AssessorUserId: Marked as a foreign key by D2L, without a stated target data set.AutomaticallyGeneratedScaleLevelId: Marked as a foreign key by D2L, without a stated target data set.ExplicitlyEnteredScaleLevelId: Marked as a foreign key by D2L, without a stated target data set.