Unizin Product Documentation
ProductsSupport and TrainingPolicies
  • Unizin Product Documentation
  • Products
    • Content
      • Unizin Engage
        • eReader User Guide
          • Notes, Highlights, and Citations
          • Appearance Settings
          • Download for Offline
          • eReader Layout
          • Keyboard Shortcuts
          • Navigating Your eBook
          • Print
          • Text to Speech
          • Copy and Paste
          • Creating Flashcards
          • Collaboration and Note Sharing
          • Pearson Titles
        • Institution Support
          • Disabled Student Services / Alt-Format
            • Best Practices for Republishing Course Content
            • Disabled Student Services
            • Requesting eTextbook Files for Accessibility Purposes
            • WCAG 2.0 AA evaluation for Engage
            • WCAG 2.0 AA evaluation for EPUB for Engage
          • Institution's Support Responsibilities
        • Caliper 1.1 sensor
        • Release Notes
          • 2.28.22
          • 2019-09-17
          • 2019-05-29
          • 2.26.8
          • 2.26.0
          • 2.25.0
          • 2.22.0
          • 2.21.6
          • 2.21.5
          • 2.20.8
          • 2.20.5
          • 2.20.3
          • 2.19.1
          • 2.18.0
          • 2.17.0
          • 2.14.0
          • 2.12.0
          • 2.11.0
          • 2.9.0
          • 2.8.3
          • 2016-03-17
          • 2016-02-11
          • 2016-01-28
        • Using Analytics (New)
      • Unizin Order Tool
        • Overview of the User Interface
        • Key Concepts
          • Profiles
          • Ordering periods
          • Coordinator permissions
          • Program administrator permissions
        • Courses & Ordering
          • Course filtering
          • Place an order
          • Add sections to a placed order
          • Edit a placed order
          • Cancel an order
          • Reordering
        • Order History
          • Instructor Order History
          • Coordinator and Program Administrator Order History
          • Order Activity
        • Student Choice
          • Student Choice (Program Administrators)
          • Student Choice (Students)
        • Entitlements
          • Entitlements (Program Administrators)
          • Entitlements (Students)
        • Catalog Tool
        • Schedule of Classes
        • Content Request Tool
        • Order Tool Dashboard
        • Vendor Sandbox Tenant
        • Institution Support
        • Implementation
          • SIS Data Integration
            • 1.0 - SIS Integration
            • 2.0 - SIS Integration
          • SSO integration
          • UI customizations
          • Order Feed
            • 1.0 - Order Feed
            • 2.0 - Order Feed
            • 3.0 - Order Feed
          • Publisher report
          • Final declined offers feed
          • Institutional (SIS) Catalog Import
          • Student Price
          • Historical Entitlements Import
        • Release Notes
          • Order Tool Bug Fixes and Enhancements
          • Order Tool Bug Fixes
          • Order Tool Accessibility Improvements
          • Order Feed Improvements
          • Content Request Form Update and Minor Bug Fix
          • Flat Markup Fee Update
          • Ordering Email Receipt Update & Minor Bug Fix
          • Bug Fix for Public Catalog Feature
          • Catalog Search Enhancements
          • Reordering Reminder Email Notifications
          • UX Improvements & Minor Bug Fixes
          • Historical Entitlements Import
          • Student Prices
          • Reordering Feature
          • Email Enhancements
          • Ordering Enhancements
          • Bug Fix for the Institutional Catalog Import
          • Bug Fix for the Final Declined Offers Feed (FDOF)
          • Order Activity Feature and Other Enhancements
          • Bug Fixes for Order History and Report an Issue Features
          • Public catalog feature
          • Minor Bug Fixes for Ordering and Student Choice
          • Entitlements Production Release, Bug fixes, and Minor updates
          • Minor Updates and Bug Fixes for Ordering Workflows
          • Catalog Search Optimization
          • Student Choice
          • Archive Terms Feature and Integration Improvements
          • Introduces the Program Administrator role, Catalog Tool, and Schedule
          • User interface updates and improvements
          • Order feed improvements
          • Order history, UI enhancements
          • Email notification upgrades, UI improvements
          • Order feed changes
          • New features for Course coordinators and upgrades to the UI
          • Changes to the Term, Course, and Section models; introduces a Session
          • Bug fixes, import improvements, and validation improvements
          • Tracking Order History
          • Publisher Reporting
          • Fixes the order feed, automates SIS data importing, and automates the generation of order feed repor
    • Data & Analytics
      • Unizin Data Platform
        • Key concepts
          • Platform overview
          • Data categories
          • Data models
          • Loading schemas
          • Keymap
        • Unizin Common Data Model
          • Academic structures (ERD)
          • Learners (ERD)
          • Course structures (ERD)
          • Course resources (ERD)
          • Learner activities (ERD)
          • Quizzes (ERD)
          • Social (ERD)
          • Course outcomes (ERD)
        • System overview
          • Context data pipeline
            • Context data ingress
            • Batch-ingest application
            • Batch-ingest db server
            • Context store
          • Event data pipeline
            • UDP Caliper endpoint
            • Approval process for implementing Caliper compliant tools
            • UDP Event enricher
            • Event store
        • Data stores
          • Data lake
            • UDP Context store
            • UDP Event store
              • Accessing the Event store
              • Expanded table
                • Expanded table: Canvas edApp mapping
            • Synthetic Data [beta]
              • Viewing Synthetic Data datasets within the BigQuery UI
              • Query Synthetic Data via client libraries
          • Data marts
            • UDP Distributions
            • Interaction sessions
            • Learning Environment Organization
            • File Interaction
            • Last Activity
            • Long Inactivity
            • Course Status
            • Daily Course Grade Record
            • LTI Tool Use
            • LMS Tool Use
            • Tool Usage Metrics
            • Links
            • Taskforce
              • Level 1 Aggregated
              • Level 2 Aggregated
              • Level 2 Course Weekly Distribution Summary
              • Student Term Profile
              • Course Profile
            • Student Activity Score
              • Student Course Metrics
              • Student Course Section Metrics
              • Final
              • Course Final
              • Course Section Final
        • Data integrations
          • Context data integration
            • Loading schema
            • Keymap support
            • Manifest file
            • File requirements
            • Integration mechanics
          • Event data integration
          • SIS data integration
          • LMS data integration
            • Instructure Canvas
        • Release Notes
          • UDP Marts Release Notes
            • 1.0.83
            • 1.0.80
            • 1.0.79
            • 1.0.78
            • 1.0.77
            • 1.0.72
            • 1.0.67
            • 1.0.58
            • 1.0.51
            • 1.0.44
            • 1.0.42
            • 1.0.32
            • 1.0.31
            • 1.0.0
            • Level 2 Taskforce data marts now available
          • 2.0.167
          • 2.0.152
          • 2.0.138
          • 2.0.137
          • 2.0.113
          • 2.0.112
          • 2.0.111
          • 2.0.110
          • 2.0.99
          • 2.0.98
          • 2.0.83
          • 2.0.80
          • 2.0.71
          • 2.0.66
          • 2.0.59
          • 2.0.58
          • 2.0.53
          • 2.0.47
          • 2.0.25
        • Miscellaneous
          • Canvas Data additions, ~Fall 2021
          • Canvas Live Events: from SQS to HTTPS
          • Canvas New Analytics vs. UDP
          • Course Section Enrollment Role Status Mappings
          • Migrating from UDW to UDP
      • Unizin Data Warehouse
        • Implementation Guide
        • Scope of Services
        • Access Provisioning
        • Access Revocation
        • Connecting to the UDW
      • Raw Canvas Data 2
        • Flat Files
        • BigQuery Datasets
    • Hosted Services
      • My Learning Analytics
        • Install MyLA via LTI 1.3
        • Custom configure MyLA
  • Support and Training
    • Professional Development
      • Stepping Stones: A Faculty Development Curriculum for Learning Analytics Use
      • Structured Conversations initiative
    • UDP Self-paced Training
    • Resources Site Broken Links
    • Status Pages
  • Policies
    • General policies
      • Sponsor Teams
      • Browser Support Policy
      • Opt-Out & Invoicing Policy (Order Tool)
    • Support Policy
      • Unizin Engage - SP
      • Unizin Order Tool - SP
      • Unizin Data Platform - SP
      • Unizin Data Warehouse - SP
      • Unizin Data Analysis - SP
      • Pressbooks Hosting - SP
    • Privacy Policy
      • Unizin Engage - PP
      • Unizin Order Tool - PP
      • Unizin Data Platform - PP
      • RStudio service - PP
    • End User License Agreements
      • Unizin Engage - EULA
      • Unizin Order Tool - EULA
    • Terms of Use
      • Unizin Data Platform - ToU
    • Incident Reports
Powered by GitBook
LogoLogo

Unizin Homepage

  • unizin.org

Data & Analytics

  • Unizin Data Platform
  • Unizin Data Warehouse

Content

  • Unizin Engage
  • Unizin Order Tool

Hosted Services

  • My Learning Analytics

Copyright © 2023, Unizin, Ltd.

On this page
  • Full SIS 2.0, performance updates, new Canvas Data
  • Key Features
  • Details
  • Major changes
  • Bug fixes
  • Miscellaneous changes
  • Known Issues
  1. Products
  2. Data & Analytics
  3. Unizin Data Platform
  4. Release Notes

2.0.25

Unizin Data Platform

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

  • 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

Course section enrollment

  • self_enrolled -> le_is_self_enrolled

Learner activity

  • 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

  • A new "what_if_score" element will be source from Canvas Data's what_if_score value on the submission_fact table.

Quiz data

  • 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_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.

Previous2.0.47NextMiscellaneous

Last updated 1 year ago

We've changed the way the UCDM represents 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 are renamed with an "le_" prefix. Their values are contributed by the LMS:

We're adding a new element to , 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.

We've changed the way the UCDM represents aspects of a student's 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:

We're adding and changing elements on the entity.

We're adding and changing elements on the entity.

The following values from the Canvas Data quiz_dim table are .

show_correct_answers (option set), is modeled as Quiz "correct_answers_display_policy." Note, this new value uses the option set.

Course grades
Course grade
Course section
Course section enrollment
Learner activity
Learner activity result
now modeled in the UCDM
RefLearningActivityDisplayPolicy