Brightspace Data Sets for SIS Course Merge depend on the SIS Course Merge tool being enabled. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for SIS Course Merge. To enlarge the diagram, right-click on the image and select Open image in a new tab.
SIS Course Merge Log
The SIS Course Merge Log Brightspace Data Set returns a list of attempts to merge or unmerge course offerings using the SIS Course Merge tool.
This data set only captures data from July 2023 onwards.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 8.6 |
BatchId
|
The batch ID for this job.
|
uniqueidentifier
|
16
|
PK
|
| 8.6 |
JobType
|
What type of job was requested: Merge or Unmerge.
|
nvarchar
|
32
|
|
| 8.6 |
Status |
The status of the job: Started, CompletedWithErrors, Completed, or Failed.
|
nvarchar |
32 |
|
| 8.6 |
OriginalTargetOrgUnitId |
The target course which the source courses are merged or were originally merged into. |
bigint |
8 |
FK |
| 8.6 |
OriginalSourceOrgUnitId |
The source course which is being merged or was previously merged into the target. |
bigint |
8 |
PK, FK |
| 8.6 |
SourceSystemId |
The ID of the source system that this course belongs to. |
bigint |
8 |
|
| 8.6 |
NumberOfCoursesInBatch |
The total number of source courses with the same batch ID being attempted to merge or unmerge. Only shown for course merge jobs with the "Started" status.
Field can be null.
|
int |
4 |
|
| 8.6 |
UserId |
The user who requested the merge or unmerge. |
bigint |
8 |
FK |
| 8.6 |
ErrorType |
The type of error that occurred. Possible values:
-
SourceSystemDisabled
-
OrgUnitDeleted
-
CourseHasMultipleMappingsToSameSIS
-
UserNoLongerExists
-
CourseHasMultipleSourceSystems
-
CourseHasSectionAssociation
-
LostBatch
-
SourceCourseNotMerged
-
IncorrectPendingState
-
SameSourceAndTarget
-
TargetAlreadyMerged
-
CourseNotUnmerged
-
OrgUnitNotCourseOffering
-
UnexpectedError
Field can be null.
|
nvarchar |
48 |
|
| 8.6 |
Timestamp |
The date and time when the merge or unmerge event occurred (UTC).
|
datetime2 |
8 |
PK |