Sakai 2.1.x Multi-CRN Site Support

Requirements

1. The external database must provide a representation of groups of crns.
2. The external database must map crn groups to a fake crn.
3. Fake crns must inhabit a namespace that will not conflict with Banner crns.
4. All sakai-specific views must provide usable records referencing fake crns.
5. The roster view for fake crns must provide the enrollment from all grouped crns.
6. The instructor view for fake crns must provide the set of all assigned instructors.
7. The course batching mechanism and course providers must retrieve the fake crns and their accompanying data.

Design

In order to provide a multi-crn strategy, a new table must be created to record groupings of "real" crns under one "fake" crn. This table will then need to be added to the query logic of all views that are affected.

New Table:
sakai_course_group_members
term_code char(6)
group_crn char(5)
member_crn char(5)

Affected Views:

• ucdsakai_course_instructor
• ucdsakai_roster

Testing