Page Comparison

...

AcademicSession / UCD_CM_ACADEMICSESSION (AcademicSessionCmImpl)

Primary SourcesSource(s) - BANNER Academic Terms (stvterm)
Secondary SourcesSource(s) - None
EID(s) - http://ucdavis.edu/course/academicsession/stvterm.stvterm_code
Description - The AcademicSession object closely models the BANNER concept of Academic Terms. This object will largely be a direct mapping from BANNER's STVTERM term information lookup table.
Derived Values - The AcademicSession Description field is filled out with a special hash of the term code value instead of the actual description. The description is instead encoded in the title field. The hash generates a short-form description of the term by taking the year from the term code and combining it with a lookup of the term code against a set of <4 character abbreviations, resulting in values of the type: FQ 2007, SS1 2005, etc...
Mapping Issues - None

CourseSet /

...

UCD_CM_COURSESET (CourseSetCmImpl)

Primary SourcesSource(s) - BANNER College, Department, and Subject tables (stvcoll, stvdept, stvsubj)
Secondary SourcesSource(s) - None
EIDs EID(s) - http://ucdavis.edu/course/courseset/college/stvcoll.stvcoll_code, http://ucdavis.edu/course/courseset/department/stvdept.stvdept_code, http://ucdavis.edu/course/courseset/subject/stvsubj.stvsubj_code
Description - The CourseSet object is a generic container used to group Course Offerings and Sections. In our domain, this maps well to our representation of Colleges, Departments, and Subjects in Banner. As of yet we do not have any other types of course sets defined.
Derived Values - None
Mapping Issues - The College data is generally consistent and issue free, however there are problems with the data in the Department and Subject tables. Both tables have a large number of extraneous values. These values range in purpose from testing values to location-specific encodings. For the Subject table, this is easily handled by using the web indicator flag in the source table to weed out the extraneous data. No such flag exists in the department table, so that query selects only departments with a 3 character name which eliminates most of the extraneous data.

College Listings

...

Field

...

Datasource

...

Reference

...

eid

...

BANNER

CanonicalCourse / UCD_CM_CANONICALCOURSE (CanonicalCourseCmImpl)

Primary Source(s) - BANNER Course table (scbcrse)
Secondary Source(s) - Degree Navigator course descriptions (ucd_cm_dn_description_t)
EID(s) - http://ucdavis.edu/course/

...

canonical/

...

title

...

BANNER

...

stvcoll.stvcoll_desc

...

description

...

BANNER

...

stvcoll.stvcoll_desc

...

Category

...

...

'COLLEGE'

...

Parent

...

...

N/A

...

createdBy

...

...

'BANNER'

...

createdDate

...

BANNER

...

stvcoll.stvcoll_activity_date

...

lastModifiedBy

...

...

'BANNER'

...

lastModifiedDate

...

BANNER

...

stvcoll.stvcoll_activity_date

...

CanonicalCourses

...

BANNER

...

BANNER_CANON_COURSESETS

...

CourseOfferings

...

...

BANNER_OFFERING_COURSESETS

Department Listings

Subject Listings

CanonicalCourse / BANNER_CANONICALCOURSE (CanonicalCourseCmImpl)

Canonical Course CourseSets / BANNER_CANON_COURSESETS

...

Field

...

Datasource

...

Reference

...

canonicalcourse_eid

...

BANNER

...

courseset_eid

...

BANNER

http://ucdavis.edu/course/courseset/

...

scbcrse.scbcrse_subj_code/scbcrse.scbcrse_crse_numb
Description - The CanonicalCourse object in the Sakai CourseManagement framework records a non-temporal definition of a course. Unfortunately, BANNER has no such concept of a course throughout time, at least through its tables. While we were able to create CanonicalCourse objects, their usefulness is limited as they do not have descriptions and may actually be different courses through time.
Derived Values - The title and description fields take the value of the concatenation of the subject code and course number.
Mapping Issues - The scbcrse table, which has the closest correlation to this object, is referenced by academic term. Therefore the generating query needs to use a distinct clause to compress the data and remove the temporally-specific data. Given that the data is pulled via a materialized view, this form of transformation is not especially problematic, although it does render the resuting mview incapable of fast refresh. In addition, the create and last update times use max and min of the banner activity dates respectively.

Canonical Course CourseSets / BANNER_CANON_COURSESETS

Primary Source(s) - BANNER Course table (scbcrse)
Secondary Source(s) - None
EID(s) - None, lookup between canonicalcourse and courseset EIDs
Description - This object relates CourseSets to Canonical Courses. The BANNER scbcrse table has columns for college, department, and subject, so this table takes those values, expands them to eids and creates one row for each object type mapping to one canonicalcourse EID.
Derived Values - TNone
Mapping Issues - The subject and department data present several challenges in this mapping. As mentioned in the CourseSet description, there are a large number of subject codes and departments that are not in general use. This is especially the case for the location-specific subjects, which have 4 characters rather than three. The inclusion of the extra codes was confusing the Sakai interface, so the decision was made to supress the four character subject and department codes. However, there are actually some classes taught in the four-character subjects, and we cannot afford to lost those classes. So, the solution is to drop the fourth character of the subject for any classes in those subjects. This has the effect of adding the course to the three character subject. In general this is fine although there is a risk that two courses may overlap, in which case the only way to differentiate would be by instructor or description.

CourseOffering / COURSEMANAGEMENT_OFFERING (CourseOfferingCmImpl)

...