Page Comparison

...

• createdBy: The name of the source system for the majority of columns. (This will almost always be 'BANNER')
• createdDate: The activity date from the source system's row.
• lastModifiedBy: The name of the source system for the majority of columns. (This will almost always be 'BANNER')
• lastModifiedDate: The activity date from the source system's row.

AcademicSession / UCD_CM_ACADEMICSESSION (AcademicSessionCmImpl)

...

Term Window

Banner records data about courses starting from its inception date (a long time ago). Given that Smartsite isn't concerned with classes that occcured before its incept date, all of the banner queries that select term-related data filter by term code. The term code filter requires two parts, one to limit to terms greater that the cutoff term, and another to eliminate the testing term 99999.

AcademicSession / UCD_CM_ACADEMICSESSION (AcademicSessionCmImpl)

Primary Source(s) - BANNER Academic Terms (stvterm)
Secondary Source(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

...

Section / COURSEMANAGEMENT_SECTION (SectionCmImpl)

...

Field

...

Datasource

...

Reference

...

eid

...

BANNER

Primary Source(s) - BANNER Section table (ssbsect)
Secondary Source(s) - Degree Navigator course descriptions (ucd_cm_dn_description_t)
EID(s) - http://ucdavis.edu/course/section/ssbsect.ssbsect_subj_code/ssbsect.ssbsect_crse_numb/ssbsect.ssbsect_seq_numb/ssbsect.ssbsect_term_code

...

title

...

BANNER

...

ssbsect.ssbsect_subj_code ssbsect.ssbsect_crse_numb - ssbsect.ssbsect_seq_numb ssbsect.ssbsect_crse_title Lookup(ssbsect.ssbsect_term_code to two character code for term and year)

...

description

...

BANNER

...

degree_navigator.description /ssbsect.ssbsect_crse_title

...

Category

...

BANNER

...

ssbsect.ssbsect_schd_code

...

courseoffering_eid

...

BANNER

Description - The Section object in the Sakai CourseManagement framework records an instance of a course that is tied to a number of instance objects, such as instructor, meeting times, and academic session.
Derived Values - In the event of blank description or title date, '(Description Unavailable)' is rendered instead.
Mapping Issues - This object needs to retrieve its description fields from the ucd_cm_dn_description table which is fed from the Degree Navigator system. This system also stores only changes to data, and so needs to be joined in specially to ensure the appropriate course description is returned. Unfortunately, the Degree Navigator data is inconsistent in its use of start and end terms, and so must be joined specially on max date to ensure duplicate records are not generated.

EnrollmentSet / BANNER_ENROLLMENTSET (EnrollmentSetCmImpl)

Primary Source(s) - BANNER Section table (ssbsect)
Secondary Source(s) - None
EID(s) - http://ucdavis.edu/course/

...

enrollmentset/

...

ssbsect.

...

ssbsect_

...

crn/

...

ssbsect.

...

enrollmentset_eid

...

BANNER

...

MaxSize

...

BANNER

...

ssbsect.ssbsect_max_enrl

...

createdBy

...

...

'BANNER'

...

createdDate

...

BANNER

...

ssbsect.ssbsect_activity_date

...

lastModifiedBy

...

...

'BANNER'

...

lastModifiedDate

...

BANNER

...

ssbsect.ssbsect_activity_date

...

Meetings

...

BANNER

...

select banner_schedule.term_code, banner_schedule.crn
from banner_schedule
where banner_schedule.term_code = <eid,2> and banner_schedule.crn = <eid,3>

...

term_code

...

BANNER

...

ssbsect.ssbsect_term_code

...

crn

...

BANNER

...

ssbsect.ssbsect_crn

...

coursecode

...

BANNER

...

ssbsect.ssbsect_subj_codessbsect.ssbsect_crse_numb

EnrollmentSet / BANNER_ENROLLMENTSET (EnrollmentSetCmImpl)

OfficialInstructors / COURSEMANAGEMENT_INSTRUCTORS

Enrollment / COURSEMANAGEMENT_ENROLLMENT (EnrollmentCmImpl)

...

Field

...

Datasource

...

Reference

...

eid

...

BANNER

...

ssbsect_term_code
Description - The EnrollmentSet object is a peer of the Section object. It is used to collect student and instructor associations with Courses/Section.
Derived Values - In the event of blank description or title date, '(Description Unavailable)' is rendered instead.
Mapping Issues - We are currently unaware of the use of the Category field, and have set this value to the literal 'Lecture'.

OfficialInstructors / COURSEMANAGEMENT_INSTRUCTORS

Primary Source(s) - BANNER Instructor Assignment table (sirasgn), BANNER Section table (ssbsect)
Secondary Source(s) - Mothra Person Table (ucd_person_t)
EID(s) - http://ucdavis.edu/course/enrollmentset/sirasgn.sirasgn_crn/sirasgn.sirasgn_term_code/instructor/sirasgn.sirasgn.pidm
Description - The OfficialInstructors object is a simple mapping of person eids to enrollmentsets and sections for the purposes of denoting instruction assignment.
Derived Values - In the event of blank description or title date, '(Description Unavailable)' is rendered instead.
Mapping Issues - In order to reproduce the section eid, the ssbsect table must be joined on the mview query. (The unique columns for the section_eid are not stored in the sirasgn table. This table is eligible for mview fast refresh under the simple join condition. This is effected by capturing the rowids of the two source tables.
This object also needs to capture a person eid, which we have identified as the Mothraid of the person. The Banner source data uses pidm to uniquely identify users in its system. Therefore, a lookup from pidm to mothraid must be performed. This is currently done via a view, but other methods are under investigation.
Data Issues: Ideally, the Banner data would only record one instance of an instructor assigned to one course. However, there are isolated cases in which the same instructor is assigned to a section multiple times. Normally, a distinct clause would be able to eliminate the extra assignments, but in this case that would break the fast-refresh of this table. Since we want up to date instructor assignments, we will need to find another way of weeding out the extra assignments.

Enrollment / COURSEMANAGEMENT_ENROLLMENT (EnrollmentCmImpl)

Primary Source(s) - BANNER Student Registration table (sftstcr)
Secondary Source(s) - Mothra Person Table (ucd_person_t)
EID(s) - http://ucdavis.edu/course/enrollmentset/sfrstcr.sfrstcr_crn/sfrstcr.sfrstcr_term_code/sfrstcr.sfrstcr_rsts_code/mothra_person.mothraid
Description - The Enrollment object records all of the data required to notate an student registration to an enrollmentset / section.
Derived Values - In the event of blank description or title date, '(Description Unavailable)' is rendered instead.
Mapping Issues - This object needs to capture a person eid, which we have identified as the Mothraid of the person. The Banner source data uses pidm to uniquely identify users in its system. Therefore, a lookup from pidm to mothraid must be performed. This is currently done via a view, but other methods are under investigation.
Data Issues: Ideally, the Banner data would only record one instance of an student assigned to one course. However, there are cases in which the same student is registered to a section multiple times. As opposed to the Instructor assignment case, it is possible to differentiate the enrollments by adding the registration status into the eid. While a student may be registered multiple times, it is always with a different registration code.

...