Page Comparison

...

Code Block

title	pseudo-sql

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:

PKG_UNEX
Function	Parameters	Description
cm_unex_feed	none	The primary procedure to run the feed for the current term.
cm_unex_main	term code, crn, external id	Invokes all sub-procedures to add a student to a course.
cm_unex_feed_get_user_info	external id	Looks up mothra information for an external id.
cm_unex_feed_check_course	term code, crn	Checks the course information to ensure it is valid.
cm_unex_feed_add_enrollment	term code, crn, external id	Adds the student to the unex_enrollment table.