Links

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.