Canvas Data additions, ~Fall 2021

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 table	CD field	UCDM element	Definition
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 table	CD field	UCDM element	Definition
course_dim	conclude_at	le_end_date	Per the learning environment, the date and time when the Course offering formally ends.
course_dim	start_at	le_start_date	Per the learning environment, the date and time when the Course offering formally begins.
course_dim	account_id	learning_environment_organization_id	The Learning environment organization to which this course belongs.
course_dim	code	le_code	The 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 table	CD field	UCDM element	Definition
course_section_dim	name	le_name	The name of the course section in the learning environment.
course_section_dim	nonxlist_course_id	le_original_course_offering_id	In 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 table	CD field	UCDM element	Definition
enrollment_term_dim	date_end	le_term_end_date	Per the learning environment, the date and time when the academic term formally ends.
enrollment_term_dim	date_start	le_term_begin_date	Per the learning environment, the date and time when the academic term formally begins.

File

We are adding a requested element about Files.

CD table	CD field	UCDM element	Definition
file_dim	locked	is_locked	Denotes whether the File is locked or not.

Learning outcome

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

CD table	CD field	UCDM element	Definition
learning_outcome_dim	account_id	learning_environment_organization_id	The 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 table	CD field	UCDM element	Definition
learning_outcome_group_dim	account_id	learning_environment_organization_id	The Learning environment organization to which this Learning outcome group belongs.
learning_outcome_group_dim	parent_group_id	parent_learning_outcome_group_id	The parent Learning outcome group for this Learning outcome group.

Learning outcome group-Learning outcome

Note: this table will NOT be included in the first release of Canvas Data additions but will be part of a forthcoming release.

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

CD table	CD field	UCDM element	Definition
learning_outcome_group_association_fact	learning_outcome_id	learning_outcome_id	The Learning outcome that is associated with one or more Learning outcome groups.
learning_outcome_group_association_fact	learning_outcome_group_id	learning_outcome_group_id	The Learning outcome group that is associated with one or more learning outcomes.
learning_outcome_group_association_fact	course_id	course_offering_id	The Course offering to which this association between a Learning outcome group and a Learning outcome belongs.
learning_outcome_group_association_fact	account_id	learning_environment_organization_id	The Learning environment organization to which this association between a Learning outcome group and a Learning outcome belongs.

Person-Email

Note: this table will NOT be included in the first release of Canvas Data additions but will be part of a forthcoming release.

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 table	CD field	UCDM element	Definition
communication_channel_dim	email_address	email_address	The email address of the Person at the institution.