SIS Course Merge Log data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
BatchId | uniqueidentifier | 16 | PK |
JobType | nvarchar | 32 | |
Status | nvarchar | 32 | |
OriginalTargetOrgUnitId | bigint | 8 | FK |
OriginalSourceOrgUnitId | bigint | 8 | PK, FK |
SourceSystemId | bigint | 8 | |
NumberOfCoursesInBatch | int | 4 | |
UserId | bigint | 8 | FK |
ErrorType | nvarchar | 48 | |
Timestamp | datetime2 | 8 | PK |
Joins to (1)
- Users
UserId→UserId
Joined from (0)
None
Edit history links
None
Foreign keys without a stated target
OriginalSourceOrgUnitId: Marked as a foreign key by D2L, without a stated target data set.OriginalTargetOrgUnitId: Marked as a foreign key by D2L, without a stated target data set.