Canonical Data Model changes as of 18 September 2020

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

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