Canonical Data Model changes as of 10 September 2020
Continuous Delivery | Release to Production 10 September 2020
Updated features, CDM Changes
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 |