Page Comparison

...

University Extension Data Architecture

The Degree Navigator University Extension system stores all of its course description enrollment data in a single table called COURSEDESCRIPTION_DAGan Oracle-based application. In order to insulate us from their underlying table architecture, they have created a view that contains all of the information we require.

External IDs

Open Campus Students are issued unique ids by University Extension, which are then matched with their Campus computing account information. This is done for several reasons:

1. Most Open Campus students have no other affiliation with the University, therefore University Extension must sponsor their campus computing account. In order to keep track of these students, the shared external id is used.
2. In some cases, ex-students will take Open Campus courses. In order to avoid confusion, these students must be referenced by an ID other than their student id.

Requirements

• Availability: The University Extension data used by Sakai must be available on a 24x7 basis.
• Refresh: MyUCDavis currently refreshes Extension data nightly, so the minimum refresh interval will be nightly. A long term goal would be to increase the refresh frequency of Extension data.

...

The current view-based structure of the Course Management schema lends itself well to integrating multiple sources of data. The extension students can be added to the coursemanagement_enrollment records simply by performing a sql UNION of the Banner and Extension data.

SELECT *
   FROM banner_enrollment be
UNION
SELECT *
   FROM unex_enrollment ue

Implementation

The implementation of Open Campus enrollments will have two artifacts:

• UNEX_ENROLLMENT Table: This table will be a column-for-column copy of the Banner-source mview (with the exception of using mothraid instead of pidm). The table will be filled nightly via the feed procedure.
• UNEX Package: The UNEX package is a pl/sql package that contains all of the code necessary to update the unex_enrollment table with information from the Extension database. The functions of the package are as follows: