Behind the Blackboard! Changes to the Course Role data in the Blackboard Data CDM - Behind the Blackboard Skip Navigation
Download PDF Icon Download PDF    Print article

Changes to the Course Role data in the Blackboard Data CDM

Date Published: Dec 02,2021


CategoryProduct:Analytics; Version:Analytics
Article No.: 000075926

Product:  
Analytics

Information:

We want to inform you of the changes made to the Course Role data in the Blackboard Data CDM as of 20 October 2021:
  1. Updated logic behind the CDM_LMS.PERSON_COURSE.COURSE_ROLE column, to better align with settings available in Blackboard Learn, and to include mapping for custom course roles from Blackboard Learn.
  2. New Course Role Description column (COURSE_ROLE_DESC) added to CDM_LMS.PERSON_COURSE.

Given that Blackboard Data is where data from all Blackboard products come together into a unified database clients can access, these changes serve to better align data recorded in the Blackboard Data canonical data model (CDM) with settings available in Blackboard Learn.  These changes provide more flexibility for clients creating custom queries and reports using the Developer Tier available via Snowflake, and will enable additional (upcoming) filtering and drilling options in reports available via the Reporting Tier (data.blackboard.com).
 

Updated logic behind the CDM_LMS.PERSON_COURSE.COURSE_ROLE

Historically, we have used the following mapping between Course Role Source (Blackboard Learn) and Canonical Course Role (Blackboard Data).
 
Source Code (Blackboard Learn)Canonical Code (Blackboard Data)
G (Grader)
P (Instructor)
T (Teaching Assistant)
BB_FACILITATOR (Facilitator)		I (Instructor)
B (Course Builder)O (Other)
Custom RoleN/A

To better align with the settings available for course roles in Blackboard Learn, we have recently added a new column called CDM_LMS.PERSON_COURSE.ACT_AS_INSTRUCTOR_IND that stores a flag (true/false) in case that a Source Course Role (from Blackboard Learn) has been set to act as an instructor.  For more information about this flag, please visit our Help Site Documentation.  

The table below shows the modified logic for the COURSE_ROLE column mapping.
 
Source Code (Blackboard Learn)ACT_AS_INSTRUCTOR_INDCanonical Code (Blackboard Data)
P (Instructor)TRUEI (Instructor)
P (Instructor)FALSEI (Instructor)
G (Grader)
T (Teaching Assistant)
BB_FACILITATOR (Facilitator)		TRUEI (Instructor)
G (Grader)
T (Teaching Assistant)
BB_FACILITATOR (Facilitator)		FALSEO (Other)
Custom RoleTRUEI (Instructor)
Custom RoleFALSEO (Other)
   

New Course Role Description column

We have added a new column, COURSE_ROLE_DESC, to CDM_LMS.PERSON_COURSE, which serves to describe existing Canonical Course Role Codes.
 
Canonical CodeDescription
SStudent
IInstructor
OOther
UGuest
   

Questions?

Please reach out to us via the Community Site in case you have questions about these changes.

To learn more about Blackboard Data and its Developer and Reporting tiers and/or review release notes, please visit our Help Site Documentation. 

Don't have Blackboard Data?  Please submit a request for Blackboard Data on Behind the Blackboard.

If training or custom reporting services are needed, consulting engagements may be contracted by contacting your account executive.




The information contained in the Knowledge Base was written and/or verified by Blackboard Support. It is approved for client use. Nothing in the Knowledge Base shall be deemed to modify your license in any way to any Blackboard product. If you have comments, questions, or concerns, please send an email to kb@blackboard.com. © 2024 Blackboard Inc. All rights reserved