Org structure and courses

Course Copy Logs data set: columns, keys and joins

Primary key: CopyCourseJobId 10 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

ColumnTypeSizeKey
SourceOrgUnitIdint4FK
DestinationOrgUnitIdint4FK
UserIdbigint8FK
Statusvarchar128
StartDatedatetime28
EndDatedatetime28
IsDestinationNewbit1
CopyProtectedResourcesbit1
CopyCourseJobIdbigint8PK
StatusIdint4

Joins to (1)

Joined from (0)

None

Edit history links

None

Foreign keys without a stated target

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

Source