Canonical Data Model changes as of 10 September 2020

Continuous Delivery | Release to Production 10 September 2020
Updated features, CDM Changes

Blackboard Learn SaaS CD Releases
Date (YYY-MM-DD) Status Entry Source Description
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