Unizin is adding new entities and elements to the UCDM that allow the following data points from Canvas to be mapped.

Learning environment organization

We are introducing a new UCDM entity to represent organizational units defined in the LMS.

CD tableCD fieldUCDM elementDefinition

account_dim

name

name

The name of the learning environment organization.

account_dim

workflow_state

status

The status of the learning environment organization. Takes an option set.

account_dim

parent_account_id

parent_learning_environment_organization_id

The parent learning environment organization for this learning environment organization.

account_dim

grandparent_account_id

grandparent_learning_environment_organization_id

The grandparent learning environment organization for this learning environment organization.

account_dim

sis_source_id

sis_ext_id

The SIS identifier associated with this Learning environment organization.

Course offering

We are adding LMS-specific versions of elements that are already in the UCDM.

CD tableCD fieldUCDM elementDefinition
course_dimconclude_atle_end_datePer the learning environment, the date and time when the Course offering formally ends.
course_dimstart_atle_start_datePer the learning environment, the date and time when the Course offering formally begins.
course_dimaccount_idlearning_environment_organization_idThe Learning environment organization to which this course belongs.
course_dimcodele_codeThe course code associated with the course in the learning environment.

Course section

We are adding LMS-specific versions of elements that are already in the UCDM.

CD tableCD fieldUCDM elementDefinition
course_section_dimnamele_nameThe name of the course section in the learning environment.
course_section_dimnonxlist_course_idle_original_course_offering_idIn the learning environment, an instructor may cross-list a course section under a course offering separate from the one assigned by the institution's system of record (usually the student information system). When this happens, the original association between the course section and the course offering is changed. The le_original_course_offering_id captures the original course_offering_id for this course_section.

Academic term

We are adding LMS-specific versions of elements that are already in the UCDM.

CD tableCD fieldUCDM elementDefinition
enrollment_term_dimdate_endle_term_end_datePer the learning environment, the date and time when the academic term formally ends.
enrollment_term_dimdate_startle_term_begin_datePer the learning environment, the date and time when the academic term formally begins.

File

We are adding a requested element about Files.

CD tableCD fieldUCDM elementDefinition
file_dimlockedis_lockedDenotes whether the File is locked or not.

Learning outcome

We are associating learning outcomes with LMS-native organizational units.

CD tableCD fieldUCDM elementDefinition
learning_outcome_dimaccount_idlearning_environment_organization_idThe Learning environment organization to which this Learning outcome belongs.

Learning outcome group

We are associated learning outcome groups with LMS-native organizational units and parent learning outcome groups.

CD tableCD fieldUCDM elementDefinition
learning_outcome_group_dimaccount_idlearning_environment_organization_idThe Learning environment organization to which this Learning outcome group belongs.
learning_outcome_group_dimparent_group_idparent_learning_outcome_group_idThe parent Learning outcome group for this Learning outcome group.

Learning outcome group-Learning outcome

We are introducing a new, composite entity to associate learning outcomes with learning outcome groups.

CD tableCD fieldUCDM elementDefinition
learning_outcome_group_association_factlearning_outcome_idlearning_outcome_idThe Learning outcome that is associated with one or more Learning outcome groups.
learning_outcome_group_association_factlearning_outcome_group_idlearning_outcome_group_idThe Learning outcome group that is associated with one or more learning outcomes.
learning_outcome_group_association_factcourse_idcourse_offering_idThe Course offering to which this association between a Learning outcome group and a Learning outcome belongs.
learning_outcome_group_association_factaccount_idlearning_environment_organization_idThe Learning environment organization to which this association between a Learning outcome group and a Learning outcome belongs.

Person-Email

We're contributing Canvas Data to the Person-Email entity in the UDP. This data will be sourced from Canvas's communication_channel_dim table.

Note: we will only extract email addresses from communication_channel_dim (where type = 'email'). We will not extract other communication channels such as Twitter handle and Facebook.

CD tableCD fieldUCDM elementDefinition
communication_channel_dimemail_addressemail_addressThe email address of the Person at institution.
  • No labels