Brightspace Data Sets for Release Conditions
Brightspace Data Sets for Release Conditions include:
These data sets have no tool dependencies.
Here is an example of how these data sets work together.
When a user must complete a discussion post within a forum, and the user must complete a quiz to trigger a release condition for the discussion post to appear, then the discussion post is the result of the release condition, and the quiz is the pre-requisite.
- There is a single row in the Release Condition Objects data set for the discussion-quiz mapping.
- There is a row for each user who has completed the required quiz in the pre-requisite conditions met data set.
-
In some cases, a release condition is set as a negative condition, meaning that it depends on a user not doing something. In that case, Not Met would mean that they have completed the action because the condition no longer applies. In the Release Conditions data set, there is a row for every user who has met positive conditions, as well as a row for every user who has not met negative conditions.
These data sets do not have any soft deletes exposed through an IsDeleted column because of the way deletions occur within release conditions.
- When you have a release condition about an activity, such as attempting a quiz, and you delete the activity (the quiz), the condition is hard deleted and is removed from the FULL data sets.
- When you have a release condition on an activity, and you remove the conditions from that activity, the release conditions will remain in the data sets with OrgUnitId = 0 to indicate they have been removed.
In Release Condition Objects, there are fields called Id1 and Id2. Depending on the ConditionType, one or both will be populated with the Id needed to map to the object. The below table can provide some guidance on what Id is displayed.
| Domain | Type | Id1 | Example BDS | Id2 | Example BDS |
|---|---|---|---|---|---|
| Checklist | Checklist | ChecklistId | Checklist Objects | NULL | |
| Checklist Item | ItemId | Checklist Item Details | ChecklistId | Checklist Objects | |
| Classlist | Enrollments | OrgUnitId | User Enrollments | NULL | |
| Group Membership | GroupId | Not available | GroupCategoryId | Not available | |
| Role | RoleId | Role Details | NULL | ||
| Competencies | ObjectId | Content User Completion | NULL | ||
| Content | Completion | ContentObjectId | Content User Completion | NULL | |
| Discussions | Posts | TopicId | Discussion Topics | NULL | |
| Assignments | DropboxId | Assignment Submissions | NULL | ||
| Grades | Grade | GradeItemId | Discussion Topic User Scores, Quiz Attempts, Assignment Submissions | GradeSchemeId | Grade Objects |
| Score on a grade item | GradeItemId | Discussion Topic User Scores, Quiz Attempts, Assignment Submissions | GradeSchemeId | Grade Objects | |
| Quiz | CollectionId | Question Relationships | NULL | ||
| Survey | CollectionId | Question Relationships | NULL | ||
| Awards | AssociationId | Not available | NULL |
Entity Relationship Diagram
Brightspace Data Set: Release Condition Objects
About
Returns all the release conditions (pre-requisites and results) that have been created in the organization.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
|---|---|---|---|---|---|
| 6.7 - Updated key | PreRequisiteId | Unique pre-requisite identifier. | int | 4 | PK, FK |
| 3.7 / 4.2 | ResultId | Unique result identifier. | int | 4 | PK |
| 6.7 - Updated key | OrgUnitId | Unique organization identifier. | int | 4 | PK, FK |
|
5.7 / 6.0 - Updated column size |
Name | Pre-requisite condition name. | varchar | 64 | |
| 3.7 / 4.2 | IsNegativeCondition | Indicates if the condition relies on something not happening. | bit | 1 | |
| 5.5 - Corrected Field name | PreRequisiteToolId | Unique pre-requisite tool identifier. | int | 4 | FK |
|
5.7 / 6.0 - Removed FK |
Id1 |
Unique identifier for the pre-requisite tool. Field can be null. |
int | 4 | |
|
5.7 / 6.0 - Removed FK |
Id2 |
Secondary unique identifier for the pre-requisite tool when needed. Field can be null. |
int | 4 | |
| 3.7 / 4.2 | ResultToolId | Unique result tool identifier. | int | 4 | FK |
| 3.7 / 4.2 | UsesPercentage | Indicates if the pre-requisite is looking at a grade percentage. | bit | 1 | |
| 3.7 / 4.2 | OperatorTypeDesc |
Defines where all or any of the pre-requisites need to be met. Field can be null. |
varchar | 3 | |
| 3.7 / 4.2 | Version | Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. | bigint | 8 |
Brightspace Data Set: Release Condition Results
About
Returns all the release condition results and whether they have been met for applicable users in the organization. These are the resulting actions that occur when pre-requisites are met.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data. Ordered by Version to include the most recent 150 million rows when the row limit is reached.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
|---|---|---|---|---|---|
| 6.7 - Updated key | ResultId | Unique result identifier. | int | 4 | PK, FK |
| 6.7 - Updated key | UserId | Unique user identifier. | int | 4 | PK, FK |
|
5.7 / 6.0 - Updated column size |
Met | Indicates whether the result has been met or not met by the user. | varchar | 7 | |
| 3.7 / 4.2 | Version | Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. | bigint | 8 |
Brightspace Data Set: PreRequisite Conditions Met
About
Returns all the prerequisite conditions that have been met for applicable users in the organization.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data. Only includes records from the last 2 years.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
|---|---|---|---|---|---|
|
5.7 / 6.0 - Updated key |
PreRequisiteId | Unique prerequisite identifier. | int | 4 | PK |
|
5.7 / 6.0 - Updated key |
UserId | Unique user identifier. | int | 4 | PK, FK |
|
5.7 / 6.0 - Updated column size |
DateMet |
Date the prerequisite condition was met. Field can be null |
datetime2 | 8 |