...
AcademicSession / UCD_CM_ACADEMICSESSION (AcademicSessionCmImpl)
Primary SourceSources - BANNER Academic Terms (stvterm)
Secondary Sources - None
EID - 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 / BANNER_COURSESET
Primary Sources - BANNER College, Department, and Subject tables (stvcoll, stvdept, stvsubj)
Secondary Sources - None
EIDs - 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 | http://ucdavis.edu/course/courseset/college/stvcoll.stvcoll_code |
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 |
...