Org structure and courses

Source Course Deploy History data set: columns, keys and joins

Primary key: SourceCourseDeployIdSourceCourseOrgUnitIdTargetCourseOrgUnitId 7 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

ColumnTypeSizeKey
SourceCourseDeployIdbigint8PK
SourceCourseOrgUnitIdint4PK, FK
TargetCourseOrgUnitIdint4PK, FK
UserIdint4FK
Statusnvarchar128
QueuedTimedatetime28
CompletionTimedatetime28

Joins to (1)

Joined from (0)

None

Edit history links

None

Foreign keys without a stated target

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

Source