# 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 <a href="#canvasdataadditions-fall2021-learningenvironmentorganization" id="canvasdataadditions-fall2021-learningenvironmentorganization"></a>

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

<table data-full-width="true"><thead><tr><th width="180.5">CD table</th><th width="219">CD field</th><th width="231">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>account_dim</td><td>name</td><td>name</td><td>The name of the learning environment organization.</td></tr><tr><td>account_dim</td><td>workflow_state</td><td>status</td><td>The status of the learning environment organization. Takes an option set.</td></tr><tr><td>account_dim</td><td>parent_account_id</td><td>parent_learning_environment_organization_id</td><td>The parent learning environment organization for this learning environment organization.</td></tr><tr><td>account_dim</td><td>grandparent_account_id</td><td>grandparent_learning_environment_organization_id</td><td>The grandparent learning environment organization for this learning environment organization.</td></tr><tr><td>account_dim</td><td>sis_source_id</td><td>sis_ext_id</td><td>The SIS identifier associated with this Learning environment organization.</td></tr></tbody></table>

## Course offering <a href="#canvasdataadditions-fall2021-courseoffering" id="canvasdataadditions-fall2021-courseoffering"></a>

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

<table data-full-width="true"><thead><tr><th width="172.5">CD table</th><th width="126">CD field</th><th width="324">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>course_dim</td><td>conclude_at</td><td>le_end_date</td><td>Per the learning environment, the date and time when the Course offering formally ends.</td></tr><tr><td>course_dim</td><td>start_at</td><td>le_start_date</td><td>Per the learning environment, the date and time when the Course offering formally begins.</td></tr><tr><td>course_dim</td><td>account_id</td><td>learning_environment_organization_id</td><td>The Learning environment organization to which this course belongs.</td></tr><tr><td>course_dim</td><td>code</td><td>le_code</td><td>The course code associated with the course in the learning environment.</td></tr></tbody></table>

## Course section <a href="#canvasdataadditions-fall2021-coursesection" id="canvasdataadditions-fall2021-coursesection"></a>

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

<table data-full-width="true"><thead><tr><th width="203.5">CD table</th><th width="181">CD field</th><th width="259">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>course_section_dim</td><td>name</td><td>le_name</td><td>The name of the course section in the learning environment.</td></tr><tr><td>course_section_dim</td><td>nonxlist_course_id</td><td>le_original_course_offering_id</td><td>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.</td></tr></tbody></table>

## Academic term <a href="#canvasdataadditions-fall2021-academicterm" id="canvasdataadditions-fall2021-academicterm"></a>

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

<table data-full-width="true"><thead><tr><th width="210.5">CD table</th><th width="128">CD field</th><th width="183">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>enrollment_term_dim</td><td>date_end</td><td>le_term_end_date</td><td>Per the learning environment, the date and time when the academic term formally ends.</td></tr><tr><td>enrollment_term_dim</td><td>date_start</td><td>le_term_begin_date</td><td>Per the learning environment, the date and time when the academic term formally begins.</td></tr></tbody></table>

## File <a href="#canvasdataadditions-fall2021-file" id="canvasdataadditions-fall2021-file"></a>

We are adding a requested element about Files.

<table data-full-width="true"><thead><tr><th width="174.5">CD table</th><th width="160">CD field</th><th width="286">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>file_dim</td><td>locked</td><td>is_locked</td><td>Denotes whether the File is locked or not.</td></tr></tbody></table>

## Learning outcome <a href="#canvasdataadditions-fall2021-learningoutcome" id="canvasdataadditions-fall2021-learningoutcome"></a>

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

<table data-full-width="true"><thead><tr><th width="222.5">CD table</th><th width="118">CD field</th><th width="319">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>learning_outcome_dim</td><td>account_id</td><td>learning_environment_organization_id</td><td>The Learning environment organization to which this Learning outcome belongs.</td></tr></tbody></table>

## Learning outcome group <a href="#canvasdataadditions-fall2021-learningoutcomegroup" id="canvasdataadditions-fall2021-learningoutcomegroup"></a>

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

<table data-full-width="true"><thead><tr><th width="275.5">CD table</th><th width="162">CD field</th><th width="326">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>learning_outcome_group_dim</td><td>account_id</td><td>learning_environment_organization_id</td><td>The Learning environment organization to which this Learning outcome group belongs.</td></tr><tr><td>learning_outcome_group_dim</td><td>parent_group_id</td><td>parent_learning_outcome_group_id</td><td>The parent Learning outcome group for this Learning outcome group.</td></tr></tbody></table>

## Learning outcome group-Learning outcome <a href="#canvasdataadditions-fall2021-learningoutcomegroup-learningoutcome" id="canvasdataadditions-fall2021-learningoutcomegroup-learningoutcome"></a>

{% hint style="info" %}
*Note: this table will NOT be included in the first release of Canvas Data additions but will be part of a forthcoming release.*
{% endhint %}

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

<table data-full-width="true"><thead><tr><th width="249.5">CD table</th><th width="242">CD field</th><th width="248">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>learning_outcome_group_association_fact</td><td>learning_outcome_id</td><td>learning_outcome_id</td><td>The Learning outcome that is associated with one or more Learning outcome groups.</td></tr><tr><td>learning_outcome_group_association_fact</td><td>learning_outcome_group_id</td><td>learning_outcome_group_id</td><td>The Learning outcome group that is associated with one or more learning outcomes.</td></tr><tr><td>learning_outcome_group_association_fact</td><td>course_id</td><td>course_offering_id</td><td>The Course offering to which this association between a Learning outcome group and a Learning outcome belongs.</td></tr><tr><td>learning_outcome_group_association_fact</td><td>account_id</td><td>learning_environment_organization_id</td><td>The Learning environment organization to which this association between a Learning outcome group and a Learning outcome belongs.</td></tr></tbody></table>

## Person-Email <a href="#canvasdataadditions-fall2021-person-email" id="canvasdataadditions-fall2021-person-email"></a>

{% hint style="info" %}
*Note: this table will NOT be included in the first release of Canvas Data additions but will be part of a forthcoming release.*
{% endhint %}

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.

<table data-full-width="true"><thead><tr><th width="270.5">CD table</th><th width="154">CD field</th><th width="158">UCDM element</th><th>Definition</th></tr></thead><tbody><tr><td>communication_channel_dim</td><td>email_address</td><td>email_address</td><td>The email address of the Person at the institution.</td></tr></tbody></table>