# 2.0.25 ## Full SIS 2.0, performance updates, new Canvas Data | Version | 2.0.25 | | ------------ | --------------- | | Release Date | October 5, 2020 | ## Key Features * Full support for all 27 SIS entities * Primary and foreign keys are indexed * Data type definition improvements and enforcement * New Canvas Data data supported * Course section enrollment keymap is changed * Bug fixes ## Details ### **Major changes** The UDP's context store import process now imports all 27 entities of the SIS 2.0 loading schema. Additionally, all primary and foreign keys in the entity tables are indexed. This will enable efficient JOINs between views/tables in the entity schema. And finally, we are enforcing new custom data types for joint entities, such as Course section enrollment. #### **Canvas Data additions/changes** We've added a number of Canvas Data-sourced elements in this release. Many of these elements have cousins that are already sourced from the SIS. For example, we're now bringing in Canvas's course grade data to complement the SIS-sourced course grade data. To distinguish between these similar ideas, we're using the "le\_" prefix for elements sourced from the "learning environment" where a similar element is sourced from the SIS. #### **Person** We're adding a new element to Person, contributed by the LMS, that captures the account status for the student in the learning environment (i.e., the LMS). For institutions that use Canvas, the value is sourced from the **workflow\_state** of the **user\_dim** table. It will be represented as the Person entity's **le\_account\_status** element in the UCDM. #### **Course grade** We've changed the way the UCDM represents [Course grades](https://docs.udp.unizin.org/ucdm/data-dictionary-2.0.html#course_grade) from the learning environment (i.e., the LMS) so that it's distinct from Course grades contributed by an institution's official system of record (i.e., the SIS). The following UCDM elements on [Course grade](https://docs.udp.unizin.org/ucdm/data-dictionary-2.0.html#course_grade) are renamed with an "**le\_**" prefix. Their values are contributed by the LMS: * current\_score -> le\_current\_score * final\_score -> le\_final\_score * hidden\_current\_score -> le\_hidden\_current\_score * hidden\_final\_score -> le\_hidden\_final\_score * status -> le\_final\_score\_status #### **Course section** We're adding a new element to [Course section](https://docs.udp.unizin.org/ucdm/data-dictionary-2.0.html#course_section), contributed by the LMS, that captures the original Course offering parent of a Course section in case the Course section is cross-listed by the instructor. For institutions that use Canvas, the value will be sourced from the **nonxlist\_course\_id** of the **course\_section\_dim** table. It will be represented as the Course section entityt's **le\_original\_course\_offering\_id** element in the UCDM. #### **Course section enrollment** We've changed the way the UCDM represents aspects of a student's [Course section enrollment](https://docs.udp.unizin.org/ucdm/data-dictionary-2.0.html#course_section_enrollment) status. The purpose of the change is to more clearly distinguish elements contributed by the learning environment (i.e., the LMS) and the institution's system of record (i.e., the SIS). The following elements on Course section enrollment renamed with an "le\_" prefix, which stands for "learning environment." Their values are contributed by the LMS: * self\_enrolled -> le\_is\_self\_enrolled #### **Learner activity** We're adding and changing elements on the [Learner activity](https://docs.udp.unizin.org/ucdm/data-dictionary-2.0.html#learner_activity) entity. * A new "is\_lockable" element will be sourced from Canvas **could\_be\_locked** value on **assignment\_dim** * Learner activity's **lock\_date** is now renamed to **locked\_date** * Learner activity's **unlock\_date** is now renamed to **unlocked\_date** #### **Learner activity result** We're adding and changing elements on the [Learner activity result](https://docs.udp.unizin.org/ucdm/data-dictionary-2.0.html#learner_activity_result) entity. * A new "what\_if\_score" element will be source from Canvas Data's **what\_if\_score** value on the **submission\_fact** table. #### **Quiz data** The following values from the Canvas Data **quiz\_dim** table are [now modeled in the UCDM](https://docs.udp.unizin.org/ucdm/data-dictionary-2.0.html#quiz). * browser\_lockdown\_for\_displaying\_results (boolean) is modeled as Quiz "is\_browser\_lockdown\_required\_to\_display\_results" * browser\_lockdown\_monitor (boolean), is modeled as Quiz "is\_browser\_lockdown\_monitor\_required" * hide\_correct\_answers\_at (timestamp), is modeled as Quiz "hide\_correct\_answers\_date" * show\_correct\_answers (option set), is modeled as Quiz "correct\_answers\_display\_policy." Note, this new value uses the [RefLearningActivityDisplayPolicy](https://docs.udp.unizin.org/tables/ref_learning_activity_display_policy.html) option set. * show\_correct\_answers\_at (timestamp), is modeled as Quiz "show\_correct\_answers\_date" * unpublished\_question\_count, is modeledas Quiz "unpublished\_quiz\_item\_count" ### **Bug fixes** * The prerequisite\_module\_id element on the Module entity is now properly imported. * The LMS Course grade created & updated date values are now properly imported into the Context store ### **Miscellaneous changes** * We are deprecating the "possible\_points" element on the Learner activity entity. Instead, this element is renamed to "points\_possible" to be consistent with naming elsewhere in the UCDM. ## Known Issues None.