About Advanced Data Sets
Advanced Data Sets are a package of several of the data sets served by the Data Hub tool. They are comprised of more complex data sets that join and aggregate data across multiple tables from Brightspace Learning Environment.
The following Advanced Data Sets help you understand more about the activity and success of instructors and learners in your organization:
- All Grades
- Awards Issued
- Course Learning Outcome Evaluation (CLOE)
- Enrollments and Withdrawals
- Final Grades
- Impersonated Sessions History
- Instructor Usage
- Learner Usage
Advanced Data Set: All Grades
About
The All Grades data set returns the grades for all gradable items for all learners in course offerings.
Note: Course offerings must be the direct or indirect children of a specific org unit.
For example, you can export all grade items for:
- all course offerings in a specific department
- all course offerings in a specific semester
- a specific course offering
Required Permission
Advanced Data Sets > Can execute All Grades (Organization level)
Available Filters
- Org Unit ID (required).
Note: This is an org unit's unique identification number that appears in the org unit's web address. All org unit IDs are listed in the Org Unit Editor. - Date Range
Note: The date range you select includes records based on the last modified date for the grade item.
Returned Fields
Field Name |
Description |
Can be null? |
User Id |
D2L’s unique identifier for the user. |
No |
Org Defined Id |
User’s Org Defined Id (often the learner identifier from an SIS system). |
Yes |
Username |
User’s username. |
No |
First Name |
User’s first name. |
No |
Last Name |
User’s last name. |
No |
Is Active |
Learner's status. |
No |
Role Id |
User’s role Id at the specific course offering. |
No |
Role Name |
User’s role at the specific course offering. |
No |
Course Offering Id |
D2L’s unique identifier for the course offering. |
No |
Course Offering Code |
Often the course identifier from an SIS system. |
Yes |
Course Offering Name |
Name of the course offering. |
No |
Course Section Id |
D2L’s unique identifier for the section. |
Yes |
Course Section Code |
Client defined code for the section. |
Yes |
Course Section Name |
Name of the section. |
Yes |
Grade Item Category Id |
D2L’s unique identifier for the category in which the grade item belongs. |
Yes |
Grade Item Category Name |
Name of the category in which the grade item belongs. |
Yes |
Grade Item Id |
D2L’s unique identifier for a grade item. Note: The final calculated grade and final adjusted grades will be included. |
No |
Grade Item Name |
Name of the grade item. |
No |
Grade Item Weight |
Weight of the grade item. |
Yes |
Grade Item Start Date |
Date the grade item will become visible in the grade book. |
Yes |
Grade Item End Date |
Date the grade item will become invisible in the grade book. |
Yes |
Points Numerator |
Numerator of the grade value. |
Yes |
Points Denominator |
Denominator of the grade value. |
Yes |
Grade Value |
Value of the grade with the grade scheme applied. |
Yes |
Grade Last Modified |
Date that the grade was last modified. Note: This is a UTC formatted date/time stamp in accordance with the org’s local timezone. |
No |
Grade Comments |
Comments/feedback left for the user. |
No |
Grader User Id |
User Id of the last user that modified the grade. |
No |
Grader Org Defined Id |
Org Defined Id of the last user that modified the grade. |
No |
Grader Username |
Grader's username. |
No |
Grader First Name |
First name of the last user that modified the grade. |
No |
Grader Last Name |
Last name of the last user that modified the grade. |
No |
Exclude From Final Grade |
Whether this grade value is not used in the final grade calculation. |
No |
Advanced Data Set: Awards Issued
About
Awards Issued data set returns all awards that have been issued and their details for all users over a date range.
Required Permission
Advanced Data Sets > Can execute Awards Issued (Organization level)
Custom Reporting Framework > Can See DataHub (Organization level)
Available Filters
- Org Unit ID (required).
Note: This is an org unit's unique identification number that appears in the org unit's web address. All org unit IDs are listed in the Org Unit Editor. All descendants of this org unit are included in the data export. - Date Range
Note: The date range you select includes records based on the issued date for the award. This field is required before you export this data.
Returned Fields
Field Name |
Description |
Can be null? |
AwardId | Identifier of the award | No |
Name | Name of the award in Brightspace Learning Environment. | No |
Type | Type of award: certificate or badge. | No |
Credits | The number of credits associated with the award. | Yes |
UserId | The identifier of the of the award recipient. | No |
UserName | The username of the of the award recipient. | No |
FirstName | The first name of the award recipient. | No |
LastName | The last name of the of the award recipient. | No |
OrgDefinedId | The organization-defined identifier to which this award is associated for the award recipient. | No |
IssuedBy | The identifier of the user who issued the award. | No |
IssuerUserName | The user name of the user who issued the award. | No |
IssuerFirstName | The first name of the user who issued the award. | No |
IssuerLastName | The last name of the user who issued the award. | No |
IssueDate | The date when the award was issued. | No |
RevokedId | Indicates if the award has been revoked. | Yes |
Criteria | Indicates the criteria that must be met to earn the award. | Yes |
Evidence | Displays the evidence that the criteria for the award was met. | Yes |
ExpiryDate | Indicates the date when the award expires | Yes |
OrgUnitId | The organization unit identifier for the org in which the award was issued. | No |
OrgUnitName | The organization unit name for the org in which the award was issued. | No |
OrgUnitCode | The organization unit code for the org in which the award was issued. | No |
Advanced Data Set: Course Learning Outcome Evaluation
About
The Course Learning Outcome Evaluation (CLOE) data set returns the learner's outcomes for required competencies.
Required Permission
Advanced Data Sets > Can execute CLOE (Organization level)
Available Filters
- Org Unit ID (required)
Note: This is an org unit's unique identification number that appears in the org unit's web address. All org unit IDs are listed in the Org Unit Editor. All courses in this org unit are included in the data export. - Roles Included
Returned Fields
Field Name |
Description |
Can be null? |
Program Enrollment |
Ancestor of the course template defined in columns (Org Unit ID, Org Unit Name, and Org Unit Code). Where multiple ancestors exist, all ancestors are displayed in the field, using ‘|" as a delimiter. The Org Unit Type to use as the parent is defined as a configuration variable. |
No |
Org Unit Id |
Org unit ID used to collect learning outcomes. |
No |
Org Unit Name |
Name of the course template used to collect results. |
No |
Org Unit Code |
Code of the course template used to collect results. |
No |
Org Unit Type Id |
ID of the course template. |
No |
Org Unit Type Name |
"Course Template". |
No |
Outcome Id |
ID of the learning objective in the course template. |
No |
Outcome Type |
Learning objective. |
No |
Outcome Name |
Name of the learning objective. |
No |
Ready For Evaluation |
Possible status' for learning objectives:
|
No |
Course Offering Id |
OU ID for the course offering. |
No |
Course Offering Name |
Name of the course offering. |
No |
Course Offering Code |
Code for the course offering. |
No |
Semester Name |
Semester that the course offering belongs to. |
Yes |
First Name |
First name of the learner. |
No |
Last Name |
Last name of the learner. |
No |
Username |
Learner's username. |
No |
Org Defined Id |
Learner’s org defined ID. |
Yes |
User Id |
Learner’s unique numeric D2L ID. |
No |
Role Name |
Role name of the learner in the specified org unit. |
No |
Role Id |
D2L ID of the learner's role in the specified org unit. |
No |
Activity Id |
ID of the activity that the outcome is attached to. |
No |
Activity Type |
Type of activity that the outcome is attached to:
|
No |
Activity Name |
Name of the activity, for example, content topic name, dropbox name, quiz name, or quiz question name. Note: If the activity is a quiz question, then the quiz name must be included too. |
No |
Assessment Type |
Numeric or Rubric (or blank if it is not assessed) |
Yes |
Rubric Id |
If the outcome is assessed by a rubric, this is the rubric ID. |
Yes |
Rubric Name |
If the outcome is assessed by a rubric, this is the rubric name. |
Yes |
Rubric Measurement |
If the outcome is assessed by a rubric, this contains Overall Score or the specific rubric criterion used to measure the outcome. |
Yes |
Assessment Threshold |
If assessed, contains the threshold considered to be successful attainment. |
Yes |
Assessment Threshold Criteria |
For numeric assessments, this field contains one of the following operators associated with the threshold:
|
Yes |
Rubric Level Achieved |
If the activity is assessed by a rubric, this is the level that the learner achieved. If the rubric measurement is Overall Score, this is the learner's overall score on the rubric. If the Rubric Measurement is a specific criterion, this is how the learner performed on that criterion. |
Yes |
Rubric Points |
If the activity is assessed by a rubric, this is the point score that the learner achieved. If the rubric measurement is Overall Score, this is the learner's overall score on the rubric. If the Rubric Measurement is a specific criterion, this is how the learner performed on that criterion. |
Yes |
Activity Grade Points |
Achieved points value the learner received when the activity is assessed by Grade. |
Yes |
Activity Grade Max Points |
Total possible points the learner could receive for the activity when the activity is assessed by Grade. |
Yes |
Activity Grade Percent |
Activity grade as recorded in the grade book. |
Yes |
Activity Threshold Achieved |
If this outcome is assessed, it is a comparison of the assessment threshold to the learner results.
|
Yes |
Advanced Data Set: Enrollments and Withdrawals
About
Returns enrollment status for all users in an org unit.
Required Permission
Advanced Data Sets > Can Execute Enrollments And Withdrawals (Organization level)
Available Filters
- Date Range
Note: The date range you select includes records based on the enrollment or unenrollment date.
Returned Fields
Field Name |
Description |
Can be null? |
Log Id |
Log entry's unique identification number. |
No |
Org Unit Id |
Org unit's unique identification number. |
No |
Org Unit Name |
Name of the org unit. |
No |
Org Unit Code |
Code of the org unit. |
No |
Org Unit Type |
Type of org unit. |
No |
User Id |
User’s unique numeric D2L ID. |
No |
First Name |
User's first name. |
No |
Last Name |
User's last name. |
No |
Username |
User's username. |
No |
Org Defined Id |
User's org defined ID. |
Yes |
Role Id |
D2L ID of the user's role in the specified org unit. |
No |
Role Name |
Role name of the user in the specified org unit. |
No |
Log Event |
Status of the user's enrollment or withdrawal. |
No |
Log Date |
Date of the user's enrollment or withdrawal. |
No |
Advanced Data Set: Final Grades
About
Returns final grades for all users in course offerings.
Required Permission
Advanced Data Sets > Can Execute Final Grades (Organization level)
Available Filters
- Date Range
Note: The date range you select includes records based on the last modified date for the final grade.
Returned Fields
Field Name |
Description |
Can be null? |
User Id |
User's unique numeric D2L ID. |
No |
Org Defined Id |
User's org defined ID. |
Yes |
Username |
User's username. |
No |
First Name |
User's first name. |
No |
Last Name |
User's last name. |
No |
Role Id |
D2L ID of the user's role in the specified org unit. |
No |
Role Name |
Role name of the user in the specified org unit. |
No |
Semester Id |
Unique semester numeric identifier in Brightspace Learning Environment. If a course is not associated with a semester, the value is NULL. |
Yes |
Semester Name |
Semester name associated with the course offering. |
Yes |
Semester Code |
Semester code associated with the course offering. The semester is the organization unit type as defined by the Standard Semester in Brightspace Learning Environment. If a semester is not associated as a direct parent of the course offering being exported, the value is NULL. If a course offering is associated with multiple semesters, these are exported as a pipe-delimited list of strings. |
Yes |
Course Offering Id |
D2L’s unique identifier for the course offering. |
No |
Course Offering Code |
Often the course identifier from an SIS system. |
Yes |
Course Offering Name |
Name of the course offering. |
No |
Course Section Name |
Name of the course section. |
Yes |
Final Calculated Grade (Percentage) |
Final calculated grade as a percentage. |
Yes |
Final Calculated Grade Last Modified Date |
Last modified date for the final calculated grade. |
No |
Final Adjusted Grade (Percentage) |
Final adjusted grade as a percentage. |
No |
Final Adjusted Last Modified Date |
Last modified date for the final adjusted grade. |
Yes |
Final Adjusted Comments |
Comments for the final adjusted grade. |
Yes |
Final Adjusted Grade Is Released? |
Indicates if the final adjusted grade is released. |
No |
Final Adjusted Last Modified By |
User that last modified the final adjusted grade. |
Yes |
Advanced Data Set: Impersonated Session History
About
The Impersonated Session History data set returns all impersonated sessions for a specific user or all users over a date range, including D2LSupport.
Note: The course offerings must be children of a given parent org unit.
Required Permission
Advanced Data Sets > Can Execute Impersonation Session History (Organization level)
Available Filters
- Roles Included
- Date Range Start and End dates are required before exporting the data set, and the range cannot exceed the last 2 calendar years.
Returned Fields
Version History |
Field |
Description |
Type |
Column Size |
Key |
2.2 |
SessionId |
Unique session identifier |
Integer |
4 |
|
2.2 |
OrgUnitId |
Unique org unit Identifier |
Integer |
4 |
|
2.2 |
UserId |
Unique user identifier. |
Integer |
4 |
|
2.2 |
Username |
Username of the impersonated user |
Navchar |
540 |
|
2.2 |
DateStarted |
Session start date time (UTC) |
DateTime |
8 |
|
2.2 |
DateEnded |
Session end date time (UTC) |
DateTime |
8 |
|
2.2 | ImpersonatingUser Id | Unique user identifier of the impersonator. |
Integer |
4 |
|
2.2 | ImpersonatingUsername | Impersonator’s username. |
Navchar |
540 |
Advanced Data Set: Instructor Usage
About
The Instructor Usage data set returns information about how instructors are using Brightspace Learning Environment functionality within their courses.
Required Permission
Advanced Data Sets > Can execute Instructor Usage (Organization level)
Available Filters
- Org Unit ID (required)
Note: This is an org unit's unique identification number that appears in the org unit's web address. All org unit IDs are listed in the Org Unit Editor. All courses in this org unit are included in the data export. - Roles Included (required)
- Date Range
Note: The date range you select includes records based on the last accessed date.
Returned Fields
Field Name |
Description |
Can be null? |
---|---|---|
Username |
Instructor’s username. |
No |
First Name |
Instructor’s first name. |
No |
Last Name |
Instructor’s last name. |
No |
Org Defined Id |
Instructor’s Org Defined Id (often the learner identifier from an SIS system). |
Yes |
User Id |
D2L’s unique identifier for the instructor. |
No |
Role Name |
Instructor’s role at the specific course offering. |
No |
Role Id |
Instructor’s role Id at the specific course offering. |
No |
Is Active |
Instructor's status. |
No |
Course Offering Name |
Name of the course offering. |
No |
Course Offering Code |
Often the course identifier from an SIS system. |
Yes |
Course Offering Id |
D2L’s unique identifier for the course offering. |
No |
Number of Content Topics Visited |
Number of content topics the instructor visited in the course offering. |
No |
Last Access to Course Offering Content |
Last date/time the instructor accessed content within the course offering. |
Yes |
Number of Assignments |
Number of assignments in the course offering. |
No |
Number of Assignment Submissions Commented on |
Number of assignment submissions the instructor commented on in the course offering. |
No |
Number of Grade Items |
Number of grade items in the course offering. |
No |
Number of Graded Grade Items |
Number of grade items the instructor graded in the course offering. |
No |
Last Modification of a Grade Item |
Last date/time a grade item in the course was modified by the instructor. |
Yes |
Number of Discussion Posts |
Number of discussion posts in the course offering. |
No |
Number of Discussion Posts Authored |
Number of discussion posts the instructor authored in the course offering. |
No |
Last Discussion Post Date |
Date/time the instructor last posted a discussion in the course. |
Yes |
Last Access to Course Offering |
Last date/time (UTC format) the instructor accessed the course offering. |
Yes |
Number of Logins to the System |
Number of times the instructor accessed Brightspace. |
No |
Last Sent Mail Date |
Last date/time the instructor sent an email from within the course offering. |
Yes |
Advanced Data Set: Learner Usage
About
The Learner Usage data set returns the activity for all learners in course offerings.
Note: The course offerings must be children of a given parent org unit.
Required Permission
Advanced Data Sets > Can execute Learner Usage (Organization level)
Available Filters
- Org Unit ID (required)
Note: This is an org unit's unique identification number that appears in the org unit's web address. All org unit IDs are listed in the Org Unit Editor. All courses in this org unit are included in the data export. - Roles Included
- Date Range
Note: The date range you select includes records based on the last accessed date.
Returned Fields
Field name |
Description |
Can be null? |
---|---|---|
Course Offering Id |
Unique course offering numeric identifier in Brightspace Learning Environment. |
No |
Course Offering Code |
Course offering string code. |
Yes |
Course Offering Name |
Course offering string name. |
No |
Parent Department Name |
Org unit name of the parent department. |
No |
Parent Department Code |
Org unit code of the parent department. |
Yes |
Semester Id |
Unique semester numeric identifier in Brightspace Learning Environment. If a course is not associated with a semester, the value is NULL. |
Yes |
Semester Code |
Semester code associated with the course offering. The semester is the organization unit type as defined by the Standard Semester in Brightspace Learning Environment. If a semester is not associated as a direct parent of the course offering being exported, the value is NULL. If a course offering is associated with multiple semesters, these are exported as a pipe-delimited list of strings. |
Yes |
Semester Name |
Semester name associated with the course offering. |
Yes |
User Id |
Internal numeric user identifier within Brightspace Learning Environment. |
No |
Username |
User name that identifies the learner. |
No |
Org Defined Id |
Organization-defined identifier within Brightspace Learning Environment for the learner. |
No |
First Name |
First name. |
No |
Last Name |
Last name. |
No |
Is Active |
Learner's status. |
No |
Role Id |
The learner's numeric role ID within the course offering. |
No |
Role Name |
A string identifying the learner's role within the course offering such as Learner. |
Yes |
Content Completed |
Number of content topics completed by the learner. |
No |
Content Required |
Number of content topics required by the learner (for user progress). Required:Manual and Required:Automatic refer to published topics. |
No |
Checklist Completed |
Number of checklists completed by the learner. |
No |
Quiz Completed |
Number of quizzes completed by the learner. |
No |
Total Quiz Attempts |
Number of times quizzes were attempted by the learner. |
No |
Discussion Post Created |
Number of discussion posts created by the learner. |
No |
Discussion Post Replies |
Number of discussion replies by the learner. |
No |
Discussion Post Read |
Number of discussion posts read by the learner. |
No |
Last Discussion Post Date |
Date the user last posted to a discussion. If the user has not posted in any discussion, this field is NULL. |
Yes |
Number Of Assignment Submissions |
Number of times the learner submitted an item to assignments within the course offering. |
No |
Last Assignment Submission Date |
Date/time the learner’s last submission/post into an assignment. |
Yes |
Total Time Spent In Content |
Sum of all the time spent in course content, measured in seconds. If the learner has not visited any of the content in this course, this field is ZERO. Note: TotalTimeSpent is an approximate time based on normal usage. If the learner has multiple instances/tabs open with the same content, this tracks each instance as a separate session, and as a result, substantially increases total time spent. |
No |
Last Visited Date |
Most recent visit date/time for the course. If the course has not been visited by the learner, this field is NULL. |
Yes |
Last System Login |
Date/time the learner last logged in to Brightspace Learning Environment. |
Yes |
Number Of Logins To The System |
Total number of times the learner logged in to Brightspace Learning Environment. |
No |
Auditor Name |
Username of the user who is assigned as the auditor for this learner. |
Yes |