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)StatusEntrySourceDescription
2024-02-27 ChangedCDM_LMS.GRADELEARN.GRADE The logic was updated, ensuring that all calculated grades are now available in the Canonical Data Model.
2024-01-19AddedCDM_LMS-PERSON-JOB_TITLELEARN.USERS.JOB_TITLEA new column in the CDM_LMS_PERSON table with the job of the person was added.
2024-01-19AddedCDM_LMS-PERSON-DEPARTMENTLEARN.USERS.DEPARTMENTA new column in the CDM_LMS_PERSON table with the department the person is part of was added.
2024-01-19AddedCDM_LMS-PERSON-COMPANYLEARN.USERS.COMPANYA new column in the CDM_LMS_PERSON table with the company the person is part of was added.
2023-12-21AddedDATA_SRC_BATCHUIDDATA_SOURCEA new element to the stage attribute of the PERSON and COURSE tables was added to include the BATCH_UID from the DATA_SOURCE table.
2023-10-25ChangedCDM_LMS.GRADELEARN.ATTEMPTUpdated with calculations from LEARN.ATTEMPT table.
2023-10-25ChangedCDM_LMS.ATTEMPTLEARN.ATTEMPTA new table that displays information about attempts on course items, such as assignments, blogs, or wikis.
2023-06-07AddedCDM_SISAnthology StudentA new canonical sub-model for SIS data, to be populated with data from Anthology Student SIS.
2023-06-07ChangedCDM_MAPAnthology Student,
Blackboard Learn
Additional tables and columns in the CDM_MAP schema to map people and course sections between Learn and Anthology Student.
2023-06-07AddedCDM_LMS.COURSE_CONTENT_ITEMS_REVIEWEDLEARN.COURSE_CONTENTS_REVIEWEDA new table that displays students’ progress against course content items where progress tracking is enabled in Ultra courses.
2023-05-17ChangedCOURSE START DATELEARN.COURSE_MAIN.START_DATE 

Modify the  DYNAMIC_DATE calculated field to reflect the real course start date when filtering by Course Start Date.

The Course Start Date column was added to the datasets where it was missing.

2023-03-08Changed  

Add the following logic to the filtering views and tables:

  • Node association not deleted = include
  • Node association deleted and course deleted = include
  • Node association deleted and course not deleted = exclude
2023-03-08AddedInstitution Hierarchy Permission 

CDM_LMS.
INSTITUTION_HIERARCHY_PERMISSION
LEARN.DOMAIN_ADMINA new table that maps users in the PERSON table to Institution Hierarchy nodes based on a “node admin” relationship. This will be used in Reporting for future “Role Based Access” functionality.
2023-03-08ChangedStage 
CDM_LMS.COURSE_ITEM.STAGE
LEARN. LEARN.BLTI_DOMAIN_CONFIG.NAMEAdding an attribute to the STAGE column to indicate the specific LTI tool used for a Basic LTI Link item, where this tool is identified in the BLTI_DOMAIN_CONFIG table.
2023-01-31AddedCopy From Courses
CDM_LMS.COURSE.COPY_FROM_COURSES
LEARN.COURSE_MAIN.COPY_FROM_UUIDSIdentifies from which course(s) content has been copied into the course.
2023-01-17AddedParent Course Item Id
CDM_LMS.COURSE_ITEM.PARENT_COURSE_ITEM_ID
LEARN.COURSE_CONTENTS.PARENT_PK1Foreign key that references itself in this table to identify the parent item that the current item sits within.
2023-01-17AddedContent Position
CDM_LMS.COURSE_ITEM.CONTENT_POSITIO
LEARN.COURSE_CONTENTS.POSITIONThe position of a content item on the page or within its parent item, with 0 being the highest.
2022-12-01AddedGrades Released Ind
CDM_ LMS. GRADEBOOK. VISIBLE_ IND
LEARN. GRADEBOOK_ MAIN. GRADES_ RELEASEDIndicates if a grade was released from a LTI item to the gradebook. If TRUE then grades are available, but VISIBLE_IND defines whether the grades are visible to students.
2022-12-01ChangedVisible Ind
CDM_ LMS. GRADEBOOK. VISIBLE_ IND

LEARN. GRADEBOOK_ MAIN. VISIBLE_ IND

LEARN. GRADEBOOK_ MAIN. VISIBLE_ IN_ BOOK_ IND

This indicator will now consider the VISIBLE_IN_BOOK_IND column to truly represent the visibility of grades to students.

Indicates whether the gradable item is released and visible or not for students and instructors in the Gradebook. If the value is FALSE, the column is hidden from students and may also be hidden from instructors. (Original Course View only)

2022-09-14AddedPrimary Instructor Ind
CDM_LMS.PERSON_COURSE.PRIMARY_INSTRUCTOR_IND
LEARN.COURSE_USERS.DISPLAY_ORDERIf TRUE then this user is the main instructor for the course. If FALSE then this user is not the primary instructor for the course.
2022-07-27AddedEnd Time
CDM_LMS.COURSE.END_TIME
LEARN.COURSE_MAIN.END_DATEThe date and time a course stops being available for students in the LMS.
2022-07-27AddedEnd Time
CDM_LMS.TERM.END_TIME
LEARN.TERM.END_DATEThe date and time a term ends in the LMS.
2022-07-27AddedStart Time
CDM_LMS.COURSE.START_TIME
LEARN.COURSE_MAIN.START_DATEThe date and time a course starts to be available for students in the LMS.
2022-07-27AddedStart Time
CDM_LMS.TERM.START_TIME
LEARN.TERM.START_DATEThe date and time a term begins in the LMS.
2022-05-31AddedDue Date Exception
CDM_LMS.PERSON_COURSE.DUE_DATE_EXCEPTION
LEARN.COURSE_USERS.DUE_DATE_EXCEPTIONBlackboard Learn Ultra user due date exception. Null: no due date exception, <=0: unlimited due date exception, >0: limited due date exception with a specified duration in seconds.
2022-05-31AddedEnrollment Time
CDM_LMS.PERSON_COURSE.ENROLLMENT_TIME
LEARN.COURSE_USERS.ENROLLMENT_DATEDate and time of course enrollment.
2022-05-31AddedTime Limit Exception
CDM_LMS.PERSON_COURSE.TIME_LIMIT_EXCEPTION
LEARN.COURSE_USERS.TIME_LIMIT_EXCEPTIONBlackboard Learn Ultra user time limit exception. NULL: no set time limit exception, 0: time limit exception set to unlimited time limit, 150: time limit exception set to 1.5 times time limit, 200: time limit exception set to 2 times time limit.
2022-01-07RemovedBBD_REPORTING Baseline reporting submodel (database schema) used for the legacy BRS
"Learning Tools Activity and Use" report.
2022-01-07RemovedBBD_REPORTING.
COURSE_TOOL_ACTIVITY_HOUR
 

Table with basic aggregations for report COURSE - TOOL activity. Granularity is on the login level. (https://data.blackboard.com/dictionary/entries/entry/BBD_REPORTING-COURSE_TOOL_ACTIVITY_HOUR)

We published the query used for calculated measures in this table, which is available to clients in the Blackboard Data Queries GitHub.

2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_IDCDM_LMS.COURSE_TOOL.IDForeign key that references the primary key of the CDM_LMS.COURSE_TOOL table.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_COURSE_IDCDM_LMS.COURSE.IDForeign key that references the primary key of the CDM_LMS.COURSE table.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_IDCDM_LMS.TOOL.IDForeign key that references the primary key of the CDM_LMS.TOOL table.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_IDCDM_LMS.PERSON.IDForeign key that references the primary key of the CDM_LMS.PERSON table.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_COURSE_IDCDM_LMS.PERSON_COURSE.IDForeign key that references the primary key of the CDM_LMS.PERSON_COURSE table.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ACTIVITY_TIMECDM_LMS.ACTIVITY.ACCESSED_TIMEDate and time an activity was performed on the course tool.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_NAMECDM_LMS.COURSE.NAMEName of the course.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_NAMECDM_LMS.TOOL.NAMEName of the tool.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_COURSE_ROLECDM_LMS.PERSON_COURSE.COURSE_ROLE_SOURCE_DESCName of the role of a person in the course.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_AVAILABLE_INDCDM_LMS.COURSE.AVAILABLE_INDShows if the course is available.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_AVAILABLE_INDCDM_LMS.COURSE_TOOL.AVAILABLE_INDShows if the tool is available in the course.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_AVAILABLE_INDCDM_LMS.PERSON.AVAILABLE_INDShows if the tool is available in the course.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ACTIVITY_DURATION_SUMCDM_LMS.ACTIVITY.DURATION_SUMLength of time a person spent in the course in seconds.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_SOURCE_IDCDM_LMS.COURSE_TOOL.COURSE_SOURCE_IDPrimary key of the course.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_SOURCE_IDCDM_LMS.COURSE_TOOL.TOOL_SOURCE_IDPrimary key of the source system.
2022-01-07RemovedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ROW_OVERWRITTEN_TIMECDM_LMS.COURSE_TOOL.TOOL_SOURCE_IDDate and time the record was overwritten in the table.
2021-12-14AddedCOURSE_TOOL_ACTIVITY_HOUR.COURSE_ROLE_DESCCDM_LMS.PERSON_COURSE.COURSE_ROLE_DESCDescription of a person's role in a course such as a student or an instructor. (This is the canonical course role description, in addition to the source course role description.)
2021-10-20AddedCOURSE_ROLE_DESCCDM_LMS.PERSON_COURSEDescription of a person's role in a course such as a student or instructor.
2021-10-20AddedCDM_LMS.PERSON_COURSE.ACT_AS_INSTRUCTOR_INDLEARN.COURSE_ROLES.ACT_AS_INSTRUCTOR_INDIf TRUE then this role should be treated similarly to the default Instructor role. If FALSE then this is not an instructor-like role.
2021-08-10ChangedCDM_CLB.PERSON.ROLE_TYPEJANUS_APOLLO_USER.ROLEThis attribute will now be based on the janus_apollo_user.role table from Blackboard Collaborate's source data
2021-08-10AddedCDM_CLB.PERSON.USER_TYPEJANUS_APOLLO_USER.APOLLO_USER_TYPEThe type of user in Blackboard Collaborate
2021-08-10AddedCDM_CLB.PERSON.EMAILJANUS_APOLLO_USER.EMAILUser's email address
2021-08-10AddedCDM_CLB.PERSON.STAGE:USER_UIDJANUS_APOLLO_USER.APOLLO_USER_UIDBlackboard Collaborate user's Universal ID
2021-08-10AddedCDM_CLB.ROOM.DELETED_INDJANUS_APOLLO_SESSION_IS_DELETEDIndicator that shows if the Session was deleted
2021-08-10AddedCDM_CLB.ROOM.ALLOW_GUEST_INDJANUS_APOLLO_SESSION.ALLOW_GUESTIndicator that shows if guest access is allowed in the Session
2021-08-10AddedCDM_CLB.ROOM.LARGE_SESSION_INDJANUS_APOLLO_SESSION.LARGE_SESSION_ENABLEIndicator that shows if the Session is a Large Session
2021-08-10AddedCDM_CLB.MEDIA.PLAYBACK_CNTJANUS_APOLLO_MEDIA.PLAYBACK_COUNTNumber of playbacks for the Recording
2021-08-10AddedCDM_CLB.MEDIA.DOWNLOAD_CNTJANUS_APOLLO_MEDIA.DOWNLOAD_COUNTNumber of downloads for the Recording
2021-08-10AddedCDM_CLB.MEDIA.LAST_DOWNLOAD_TIMEJANUS_APOLLO_MEDIA.LAST_DOWNLOAD_TSTimestamp representing when the Recording was last downloaded
2021-08-10AddedCDM_CLB.MEDIA.PUBLIC_ACCESS_INDJANUS_APOLLO_MEDIA.PUBLIC_LINK_ALLOWEDIndicator that represents if the Recording is public or not
2021-08-10AddedCDM_CLB.MEDIA.STAGE:MEDIA_UIDJANUS_APOLLO_MEDIA.MEDIA_UIDMedia Universal ID.

Can be used in API calls
2021-08-10AddedCDM_CLB.ATTENDANCE.USER_TYPEJANUS_APOLLO_ATTENDEE.USER_TYPECanonical code for user type
2021-08-10AddedCDM_CLB.ATTENDANCE.STAGE:CACHE_UIDJANUS_APOLLO_ATTENDEE_CACHE_UIDCache Universal ID
2021-08-10AddedCDM_CLB.SESSION.STAGE:SESSION_INSTANCE_UIDJANUS_APOLLO_SESSION_INSTANCE.UIDSession Instance Universal ID.

Can be used with session_uid in API calls against collab API
2021-05-27AddedCDM_TLM.ULTRA_EVENTSBlackboard Learn UltraUltra telemetry events table
2021-05-27AddedCDM_TLM.ULTRA_EVENTS.EVENT_TYPEBlackboard Learn UltraType of telemetry event
2021-05-27AddedCDM_TLM.ULTRA_EVENTS.EVENT_TIMEBlackboard Learn UltraDate and time of the telemetry event
2021-05-27AddedCDM_TLM.ULTRA_EVENTS.DATABlackboard Learn UltraData of the telemetry event in JSON structure
2020-12-15ChangedCDM_META.CANON_CODELMS PERSON, CLB PERSONThe BB_FACILITATOR role is now mapping to the Instructor ('I') role from Learn.
2020-10-29AddedCDM_LMS.COURSE_ITEM.AVAILABLE_INDLEARN.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_AVAILABLEShows if course item is available
2020-10-29AddedCDM_LMS.COURSE_ITEM.AVAILABLE_START_TIMELEARN.COURSE_CONTENTS.START_DATE, LEARN.FORUM_MAIN.START_DATE, LEARN.BLOGS.START_DATE, LEARN.WIKI.START_DATE, LEARN.ANNOUNCEMENTS.START_DATETime the course item started or became available
2020-10-29AddedCDM_LMS.COURSE_ITEM.AVAILABLE_END_TIMELEARN.COURSE_CONTENTS.END_DATE, LEARN.FORUM_MAIN.END_DATE, LEARN.BLOGS.END_DATE, LEARN.WIKI.END_DATE, LEARN.ANNOUNCEMENTS.END_DATETime the course item ended or became unavailable
2020-09-17AddedCDM_LMS.GRADE.MODIFIER_ROLELEARN.GRADEBOOK_LOG.MODIFIER_ROLEGrader role
2020-09-17AddedCDM_LMS.GRADE.MODIFIER_PERSON_IDCDM_LMS.PERSON.IDForeign key that references the primary key of the CDM_LMS.PERSON table for the person who modified the grade
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHYLEARN.MI_NODETable 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-17AddedCDM_LMS.INSTITUTION_HIERARCHY.IDDerived from CDMSurrogate primary key for the table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.INSTANCE_IDDerived from CDMforeign key that references the primary key of the CDM_LMS.INSTANCE table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.INSTITUTION_HIERARCHY_PARENT_IDLEARN.MI_NODE.PARENT_PK1Foreign key that references a parent key in the table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.SOURCE_IDLEARN.MI_NODE.PK1Primary key of the source system
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.NAMELEARN.MI_NODE.NAMEName of the institution hierarchy node
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.DESCRIPTIONLEARN.MI_NODE.DESCRIPTIONDescription of the institution hierarchy node
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.HIERARCHY_ID_SEQLEARN.MI_NODE.PK1List of primary parent nodes of the institution hierarchy node
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.STAGELEARN.MI_NODE.DOMAIN_PK1, LEARN.MI_NODE.BATCH_UIDAuxiliary attributes for the CDM_LMS.INSTITUTION_HIERARCHY table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.ROW_INSERTED_TIMEDerived from CDMDate and time the record was inserted to the table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.ROW_UPDATED_TIMEDerived from CDMDate and time the record was modified in the table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY.ROW_DELETED_TIMEDerived from CDMDate and time the record was marked as removed
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSELEARN.MI_NODE, LEARN.COURSE_MAIN, LEARN.DOMAIN_COURSE_COLLTable that holds information about the relation between institutional hierarchy nodes and courses
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.IDDerived from CDMSurrogate primary key for the table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.INSTANCE_IDCDM_LMS.INSTANCE.IDForeign key that references the primary key of the CDM_LMS.INSTANCE table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.COURSE_IDCDM_LMS.COURSE.IDForeign key that references the primary key of the CDM_LMS.COURSE table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.INSTITUTION_HIERARCHY_IDCDM_LMS.INSTITUTION_HIERARCHY.IDForeign key that references the primary key of the CDM_LMS.INSTITUTION_HIERARCHY table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.SOURCE_IDLEARN.MI_NODE.PK1, LEARN.DOMAIN_COURSE_COLL.COURSE_MAIN_PK1Primary key of the source system
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.PRIMARY_INDLEARN.DOMAIN_COURSE_COLL.PRIMARY_INDShows if this association is primary association for the object. Only applicable to direct multi-institution associations.
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.STAGELEARN.MI_NODE.DOMAIN_PK1, LEARN.MI_NODE.BATCH_UIDAuxiliary attributes for CDM_LMS.INSTITUTION_HIERARCHY_COURSE table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.ROW_INSERTED_TIMEDerived from CDMDate and time the record was inserted to the table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.ROW_UPDATED_TIMEDerived from CDMDate and time the record was modified in the table
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.ROW_DELETED_TIMEDerived from CDMDate and time the record was marked as removed
2020-09-17AddedCDM_LMS.INSTITUTION_HIERARCHY_COURSE.HIERARCHY_NAME_SEQLEARN.MI_NODE.PK1List of names of parent nodes of the institution hierarchy node
2020-09-09AddedBBD_REPORTINGDerived from CDMNew submodel that includes the metrics and calculations for Blackboard Reporting Tier
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOURDerived from CDMBasic aggregations for report COURSE - TOOL activity. Granularity is on login level.
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_TOOL_IDCDM_LMS.COURSE_TOOL.IDForeign key that references the primary key of the CDM_LMS.COURSE_TOOL table
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_IDCDM_LMS.COURSE.IDForeign key that references the primary key of the CDM_LMS.COURSE table
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_IDCDM_LMS.TOOL.IDForeign key that references the primary key of the CDM_LMS.TOOL table
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_IDCDM_LMS.PERSON.IDForeign key that references the primary key of the CDM_LMS.PERSON table
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_COURSE_IDCDM_LMS.PERSON_COURSE.IDForeign key that references the primary key of the CDM_LMS.PERSON_COURSE table
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ACTIVITY_TIMECDM_LMS.ACTIVITY.ACCESSED_TIMEDate and time an activity was performed on the course tool
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_NAMECDM_LMS.COURSE.NAMEName of the course
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_NAMECDM_LMS.TOOL.NAMEName of the tool
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_COURSE_ROLECDM_LMS.PERSON_COURSE.COURSE_ROLE_SOURCE_DESCName of the role of a person in the course
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_AVAILABLE_INDCDM_LMS.COURSE.AVAILABLE_INDShows if the course is available
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_AVAILABLE_INDCDM_LMS.COURSE_TOOL.AVAILABLE_INDShows if the tool is available in the course
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.PERSON_AVAILABLE_INDCDM_LMS.PERSON.AVAILABLE_INDShows if the person is available
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ACTIVITY_DURATION_SUMCDM_LMS.ACTIVITY.DURATION_SUMLength of time a person spent in the course in seconds
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.COURSE_SOURCE_IDCDM_LMS.COURSE_TOOL.COURSE_SOURCE_IDPrimary key of the course
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.TOOL_SOURCE_IDCDM_LMS.COURSE_TOOL.TOOL_SOURCE_IDPrimary key of the source system
2020-09-09AddedBBD_REPORTING.COURSE_TOOL_ACTIVITY_HOUR.ROW_OVERWRITTEN_TIMEDerived from CDMDate and time the record was overwritten in the table
2020-08-05AddedCDM_LMS.TRANSLATIONDerived from CDMTranslations for tools and course roles to es_ES and en_US locales. One row per locale, bundle name and translation key.
2020-08-05AddedCDM_LMS.TRANSLATION.IDDerived from CDMSurrogate primary key for the table
2020-08-05AddedCDM_LMS.TRANSLATION.INSTANCE_IDCDM_LMS.INSTANCE.IDForeign key that references the primary key of the CDM_LMS.INSTANCE table
2020-08-05AddedCDM_LMS.TRANSLATION.SOURCE_IDLEARN.RESOURCE_STRINGS.LOCALE, LEARN.RESOURCE_STRINGS.BUNDLE_NAME, LEARN.RESOURCE_STRINGS.TRANSLATION_KEYPrimary keys of the source system. Keys are separated by semicolon. List begins with the locale, followed by bundle_name and resource_key.
2020-08-05AddedCDM_LMS.TRANSLATION.LOCALELEARN.RESOURCE_STRINGS.LOCALETranslations locales in a form of language_TERRITORY, e.g. en_US
2020-08-05AddedCDM_LMS.TRANSLATION.BUNDLE_NAMELEARN.RESOURCE_STRINGS.BUNDLE_NAMEBundle name
2020-08-05AddedCDM_LMS.TRANSLATION.TRANSLATION_KEYLEARN.RESOURCE_STRINGS.RESOURCE_KEYUniversal string from source system to be translated
2020-08-05AddedCDM_LMS.TRANSLATION.TRANSLATION_VALUELEARN.RESOURCE_STRINGS.RESOURCE_VALUETranslation of translation key to given locale
2020-08-05AddedCDM_LMS.TRANSLATION.ENABLED_INDLEARN.LOCALES.IS_ENABLEDShows if the locale is generally enabled in source system
2020-08-05AddedCDM_LMS.TRANSLATION.COURSE_ENABLED_INDLEARN.LOCALES.IS_ENABLED_COURSEShows if the locale is enabled for courses in source system
2020-08-05AddedCDM_LMS.TRANSLATION.ORGANIZATION_ENABLED_INDLEARN.LOCALES.IS_ENABLED_ORGANIZATIONShows if the locale is enabled for organizations in source system
2020-08-05AddedCDM_LMS.TRANSLATION.USER_ENABLED_INDLEARN.LOCALES.IS_ENABLED_USERShows if the locale is enabled for users in source system
2020-08-05AddedCDM_LMS.TRANSLATION.STAGEDerived from CDMAuxiliary attributes for the CDM_LMS.TRANSLATION table
2020-08-05AddedCDM_LMS.TRANSLATION.ROW_INSERTED_TIMEDerived from CDMDate and time the record was added to the table
2020-08-05AddedCDM_LMS.TRANSLATION.ROW_UPDATED_TIMEDerived from CDMDate and time the record was modified in the table
2020-08-05AddedCDM_LMS.TRANSLATION.ROW_DELETED_TIMEDerived from CDMDate and time the record was marked as removed
2020-05-20AddedCDM_LMS.ATTENDANCE.ROLEDerived from CDMCanonical attendance role
2020-05-20AddedCDM_LMS.ATTENDANCE.ROLE_SOURCE_CODECOLLAB.APOLLO_ATTENDEE.ROLEEnum code of the collaboration tool attendee role
2020-05-20AddedCDM_LMS.ATTENDANCE.ROLE_SOURCE_DESCCOLLAB.APOLLO_ATTENDEE.ROLEDescription of the collaboration tool attendee role.
2020-05-20AddedCDM_LMS.GRADEBOOK.DUE_TIMELEARN.GRADEBOOK_MAIN.DUE_DATEDue date for gradable item
2020-04-01AddedCDM_LMS.TOOL.PLUGIN_HANDLELEARN.PLUGINS.HANDLEPlugin handle name
2019-12-05RemovedCDM_LMS.ACTIVITY.ACCESSED_DATELEARN.ACTIVITY_ACCUMULATOR_ARCHIVE.TIMESTAMPRemoved this column to solve duplication. Date information can be retrieved from CDM_LMS.ACTIVITY.ACCESSED_TIME
2019-11-01RemovedCDM_CLB.MEDIA_ACCESS Table unused, not being populated with data in the model
2019-07-24AddedCDM_MAP.INSTANCE.STAGEDerived from CDMAuxiliary attributes for CDM_MAP.INSTANCE table
2019-07-24AddedCDM_MAP.INSTANCE.ROW_INSERTED_TIMEDerived from CDMDate and time when the record was inserted to the table
2019-07-24AddedCDM_MAP.INSTANCE.ROW_UPDATED_TIMEDerived from CDMDate and time when the record was modified in the table
2019-07-24AddedCDM_MAP.PERSON.STAGEDerived from CDMAuxiliary attributes for CDM_LMS.PERSON table
2019-07-24AddedCDM_MAP.PERSON.ROW_INSERTED_TIMEDerived from CDMDate and time when the record was inserted to the table
2019-07-24AddedCDM_MAP.PERSON.ROW_UPDATED_TIMEDerived from CDMDate and time when the record was modified in the table
2019-07-24AddedCDM_MAP.COURSE_ROOM.STAGEDerived from CDMAuxiliary attributes for CDM_MAP.COURSE_ROOM table
2019-07-24AddedCDM_MAP.COURSE_ROOM.ROW_INSERTED_TIMEDerived from CDMDate and time when the record was inserted to the table
2019-07-24AddedCDM_MAP.COURSE_ROOM.ROW_UPDATED_TIMEDerived from CDM1Date 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.