Announcements data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
AnnouncementId | bigint | 8 | PK |
OrgUnitId | bigint | 8 | FK |
Title | nvarchar | 400 | |
StartDate | datetime2 | 8 | |
EndDate | datetime2 | 8 | |
IsGlobal | bit | 1 | |
IsDraft | bit | 1 | |
NumAttachments | int | 4 | |
DeletedDate | datetime2 | 8 | |
DeletedByUserId | int | 4 | FK |
LastModified | datetime2 | 8 | |
LastModifiedBy | int | 4 | |
CreatedBy | int | 4 | |
IsAuthorInfoShown | bit | 1 | |
CreatedDate | datetime2 | 8 | |
ResultId | bigint | 8 | FK |
Joins to (1)
- Organizational Units
OrgUnitId→OrgUnitId
Joined from (0)
None
Edit history links
- Users
DeletedByUserId→UserId
Foreign keys without a stated target
ResultId: Marked as a foreign key by D2L, without a stated target data set.