Follow this page to get email updates when we publish changes to the Canonical Data Model (CDM)

Blackboard Learn SaaS CD Releases
Date (YYYY-MM-DD) Status Entry Source Description
2020-10-29 Added CDM_LMS.COURSE_ITEM.AVAILABLE_IND LEARN.COURSE_CONTENTS.AVAILABLE_IND, LEARN.FORUM_MAIN.AVAILABLE_IND, LEARN.CONFERENCE_MAIN.AVAILABLE_IND, LEARN.BLOGS.AVAILABLE_IND, LEARN.WIKI.IS_AVAILABLE, LEARN.STAFFINFORMATION.AVAILABLE_IND, LEARN.COLLAB_SESSION.IS_AVAILABLE Shows if course item is available
2020-10-29 Added CDM_LMS.COURSE_ITEM.AVAILABLE_START_TIME LEARN.COURSE_CONTENTS.START_DATE, LEARN.FORUM_MAIN.START_DATE, LEARN.BLOGS.START_DATE, LEARN.WIKI.START_DATE, LEARN.ANNOUNCEMENTS.START_DATE Time the course item started or became available
2020-10-29 Added CDM_LMS.COURSE_ITEM.AVAILABLE_END_TIME LEARN.COURSE_CONTENTS.END_DATE, LEARN.FORUM_MAIN.END_DATE, LEARN.BLOGS.END_DATE, LEARN.WIKI.END_DATE, LEARN.ANNOUNCEMENTS.END_DATE Time the course item ended or became unavailable
2020-09-17 Added CDM_LMS.GRADE.MODIFIER_ROLE LEARN.GRADEBOOK_LOG.MODIFIER_ROLE Grader role
2020-09-17 Added CDM_LMS.GRADE.MODIFIER_PERSON_ID CDM_LMS.PERSON.ID Foreign key that references the primary key of the CDM_LMS.PERSON table for the person who modified the grade
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY LEARN.MI_NODE Table that holds information about the hierarchy management user interface designed to allow administrators to create a multi-level framework within Blackboard Learn that mirrors their institution.
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.ID Derived from CDM Surrogate primary key for the table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.INSTANCE_ID Derived from CDM foreign key that references the primary key of the CDM_LMS.INSTANCE table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.INSTITUTION_HIERARCHY_PARENT_ID LEARN.MI_NODE.PARENT_PK1 Foreign key that references a parent key in the table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.SOURCE_ID LEARN.MI_NODE.PK1 Primary key of the source system
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.NAME LEARN.MI_NODE.NAME Name of the institution hierarchy node
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.DESCRIPTION LEARN.MI_NODE.DESCRIPTION Description of the institution hierarchy node
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.HIERARCHY_ID_SEQ LEARN.MI_NODE.PK1 List of primary parent nodes of the institution hierarchy node
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.STAGE LEARN.MI_NODE.DOMAIN_PK1, LEARN.MI_NODE.BATCH_UID Auxiliary attributes for the CDM_LMS.INSTITUTION_HIERARCHY table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.ROW_INSERTED_TIME Derived from CDM Date and time the record was inserted to the table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.ROW_UPDATED_TIME Derived from CDM Date and time the record was modified in the table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY.ROW_DELETED_TIME Derived from CDM Date and time the record was marked as removed
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE LEARN.MI_NODE, LEARN.COURSE_MAIN, LEARN.DOMAIN_COURSE_COLL Table that holds information about the relation between institutional hierarchy nodes and courses
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.ID Derived from CDM Surrogate primary key for the table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.INSTANCE_ID CDM_LMS.INSTANCE.ID Foreign key that references the primary key of the CDM_LMS.INSTANCE table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.COURSE_ID CDM_LMS.COURSE.ID Foreign key that references the primary key of the CDM_LMS.COURSE table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.INSTITUTION_HIERARCHY_ID CDM_LMS.INSTITUTION_HIERARCHY.ID Foreign key that references the primary key of the CDM_LMS.INSTITUTION_HIERARCHY table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.SOURCE_ID LEARN.MI_NODE.PK1, LEARN.DOMAIN_COURSE_COLL.COURSE_MAIN_PK1 Primary key of the source system
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.PRIMARY_IND LEARN.DOMAIN_COURSE_COLL.PRIMARY_IND Shows if this association is primary association for the object. Only applicable to direct multi-institution associations.
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.STAGE LEARN.MI_NODE.DOMAIN_PK1, LEARN.MI_NODE.BATCH_UID Auxiliary attributes for CDM_LMS.INSTITUTION_HIERARCHY_COURSE table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.ROW_INSERTED_TIME Derived from CDM Date and time the record was inserted to the table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.ROW_UPDATED_TIME Derived from CDM Date and time the record was modified in the table
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.ROW_DELETED_TIME Derived from CDM Date and time the record was marked as removed
2020-09-17 Added CDM_LMS.INSTITUTION_HIERARCHY_COURSE.HIERARCHY_NAME_SEQ LEARN.MI_NODE.PK1 List of names of parent nodes of the institution hierarchy node
2020-09-09 Added BBD_REPORTING Derived from CDM New submodel that includes the metrics and calculations for Blackboard Reporting Tier
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR Derived from CDM Basic aggregations for report COURSE - TOOL activity. Granularity is on login level.
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_TOOL_ID CDM_LMS.COURSE_TOOL.ID Foreign key that references the primary key of the CDM_LMS.COURSE_TOOL table
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_ID CDM_LMS.COURSE.ID Foreign key that references the primary key of the CDM_LMS.COURSE table
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_ID CDM_LMS.TOOL.ID Foreign key that references the primary key of the CDM_LMS.TOOL table
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_ID CDM_LMS.PERSON.ID Foreign key that references the primary key of the CDM_LMS.PERSON table
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_COURSE_ID CDM_LMS.PERSON_COURSE.ID Foreign key that references the primary key of the CDM_LMS.PERSON_COURSE table
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ACTIVITY_TIME CDM_LMS.ACTIVITY.ACCESSED_TIME Date and time an activity was performed on the course tool
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_NAME CDM_LMS.COURSE.NAME Name of the course
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_NAME CDM_LMS.TOOL.NAME Name of the tool
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_COURSE_ROLE CDM_LMS.PERSON_COURSE.COURSE_ROLE_SOURCE_DESC Name of the role of a person in the course
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_AVAILABLE_IND CDM_LMS.COURSE.AVAILABLE_IND Shows if the course is available
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_AVAILABLE_IND CDM_LMS.COURSE_TOOL.AVAILABLE_IND Shows if the tool is available in the course
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_AVAILABLE_IND CDM_LMS.PERSON.AVAILABLE_IND Shows if the person is available
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ACTIVITY_DURATION_SUM CDM_LMS.ACTIVITY.DURATION_SUM Length of time a person spent in the course in seconds
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_SOURCE_ID CDM_LMS.COURSE_TOOL.COURSE_SOURCE_ID Primary key of the course
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_SOURCE_ID CDM_LMS.COURSE_TOOL.TOOL_SOURCE_ID Primary key of the source system
2020-09-09 Added BBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ROW_OVERWRITTEN_TIME Derived from CDM Date and time the record was overwritten in the table
2020-08-05 Added CDM_LMS.TRANSLATION Derived from CDM Translations for tools and course roles to es_ES and en_US locales. One row per locale, bundle name and translation key.
2020-08-05 Added CDM_LMS.TRANSLATION.ID Derived from CDM Surrogate primary key for the table
2020-08-05 Added CDM_LMS.TRANSLATION.INSTANCE_ID CDM_LMS.INSTANCE.ID Foreign key that references the primary key of the CDM_LMS.INSTANCE table
2020-08-05 Added CDM_LMS.TRANSLATION.SOURCE_ID LEARN.RESOURCE_STRINGS.LOCALE, LEARN.RESOURCE_STRINGS.BUNDLE_NAME, LEARN.RESOURCE_STRINGS.TRANSLATION_KEY Primary keys of the source system. Keys are separated by semicolon. List begins with the locale, followed by bundle_name and resource_key.
2020-08-05 Added CDM_LMS.TRANSLATION.LOCALE LEARN.RESOURCE_STRINGS.LOCALE Translations locales in a form of language_TERRITORY, e.g. en_US
2020-08-05 Added CDM_LMS.TRANSLATION.BUNDLE_NAME LEARN.RESOURCE_STRINGS.BUNDLE_NAME Bundle name
2020-08-05 Added CDM_LMS.TRANSLATION.TRANSLATION_KEY LEARN.RESOURCE_STRINGS.RESOURCE_KEY Universal string from source system to be translated
2020-08-05 Added CDM_LMS.TRANSLATION.TRANSLATION_VALUE LEARN.RESOURCE_STRINGS.RESOURCE_VALUE Translation of translation key to given locale
2020-08-05 Added CDM_LMS.TRANSLATION.ENABLED_IND LEARN.LOCALES.IS_ENABLED Shows if the locale is generally enabled in source system
2020-08-05 Added CDM_LMS.TRANSLATION.COURSE_ENABLED_IND LEARN.LOCALES.IS_ENABLED_COURSE Shows if the locale is enabled for courses in source system
2020-08-05 Added CDM_LMS.TRANSLATION.ORGANIZATION_ENABLED_IND LEARN.LOCALES.IS_ENABLED_ORGANIZATION Shows if the locale is enabled for organizations in source system
2020-08-05 Added CDM_LMS.TRANSLATION.USER_ENABLED_IND LEARN.LOCALES.IS_ENABLED_USER Shows if the locale is enabled for users in source system
2020-08-05 Added CDM_LMS.TRANSLATION.STAGE Derived from CDM Auxiliary attributes for the CDM_LMS.TRANSLATION table
2020-08-05 Added CDM_LMS.TRANSLATION.ROW_INSERTED_TIME Derived from CDM Date and time the record was added to the table
2020-08-05 Added CDM_LMS.TRANSLATION.ROW_UPDATED_TIME Derived from CDM Date and time the record was modified in the table
2020-08-05 Added CDM_LMS.TRANSLATION.ROW_DELETED_TIME Derived from CDM Date and time the record was marked as removed
2020-05-20 Added CDM_LMS.ATTENDANCE.ROLE Derived from CDM Canonical attendance role
2020-05-20 Added CDM_LMS.ATTENDANCE.ROLE_SOURCE_CODE COLLAB.APOLLO_ATTENDEE.ROLE Enum code of the collaboration tool attendee role
2020-05-20 Added CDM_LMS.ATTENDANCE.ROLE_SOURCE_DESC COLLAB.APOLLO_ATTENDEE.ROLE Description of the collaboration tool attendee role.
2020-05-20 Added CDM_LMS.GRADEBOOK.DUE_TIME LEARN.GRADEBOOK_MAIN.DUE_DATE Due date for gradable item
2020-04-01 Added CDM_LMS.TOOL.PLUGIN_HANDLE LEARN.PLUGINS.HANDLE Plugin handle name
2019-12-05 Removed CDM_LMS.ACTIVITY.ACCESSED_DATE LEARN.ACTIVITY_ACCUMULATOR_ARCHIVE.TIMESTAMP Removed this column to solve duplication. Date information can be retrieved from CDM_LMS.ACTIVITY.ACCESSED_TIME
2019-11-01 Removed CDM_CLB.MEDIA_ACCESS   Table unused, not being populated with data in the model
2019-07-24 Added CDM_MAP.INSTANCE.STAGE Derived from CDM Auxiliary attributes for CDM_MAP.INSTANCE table
2019-07-24 Added CDM_MAP.INSTANCE.ROW_INSERTED_TIME Derived from CDM Date and time when the record was inserted to the table
2019-07-24 Added CDM_MAP.INSTANCE.ROW_UPDATED_TIME Derived from CDM Date and time when the record was modified in the table
2019-07-24 Added CDM_MAP.PERSON.STAGE Derived from CDM Auxiliary attributes for CDM_LMS.PERSON table
2019-07-24 Added CDM_MAP.PERSON.ROW_INSERTED_TIME Derived from CDM Date and time when the record was inserted to the table
2019-07-24 Added CDM_MAP.PERSON.ROW_UPDATED_TIME Derived from CDM Date and time when the record was modified in the table
2019-07-24 Added CDM_MAP.COURSE_ROOM.STAGE Derived from CDM Auxiliary attributes for CDM_MAP.COURSE_ROOM table
2019-07-24 Added CDM_MAP.COURSE_ROOM.ROW_INSERTED_TIME Derived from CDM Date and time when the record was inserted to the table
2019-07-24 Added CDM_MAP.COURSE_ROOM.ROW_UPDATED_TIME Derived from CDM1 Date and time when the record was modified in the table

Status key

  • Added: New entries added to CDM
  • Changed: Changes to existing entries in CDM
  • Deprecated: Entries that will be removed from CDM in upcoming releases
  • Removed: Entries removed from CDM

1 Derived from CDM means there’s no product source for that entry. Instead it is calculated and derived from the data model itself.