Outcomes and recognition

Portfolio Evidence Objects data set: columns, keys and joins

Primary key: EvidenceId 14 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

ColumnTypeSizeKey
EvidenceIduniqueidentifier16PK
OwnerIdint4FK
OrgUnitIdint4FK
EvidenceTypenvarchar30
Titlenvarchar1000
IsApprovedbit1
IsSpotlightedbit1
IsSharedToParentsbit1
IsDeletedbit1
IsRecoverableByInstructorbit1
LastModifieddatetime28
LastModifiedByint4FK
IsSharedWithInstructorbit1
DateSharedWithInstructordatetime28

Joins to (1)

Joined from (1)

Edit history links

  • UsersLastModifiedBy → UserId

Foreign keys without a stated target

  • OwnerId: Marked as a foreign key by D2L, without a stated target data set.

Source