...
CourseManagement
...
Institutional Data
...
This page will list each Course Management object and the mapping of Banner data to the object fields.
...
Mapping
The objects in the CourseManagement framework will be filled almost entirely with data from institutional systems. This page will outline each CourseManagement Object, the institutional data that will be referenced, and any implementation issues. Additionally, each CourseManagement object requires an EID to uniquely identify rows. The algorithm for generating each eid will be captured here.
EID Structure
Common Fields
All of the CourseManagement Objects share a set of fields in common. These fields seem to primarily be concerned with determining the actor that created or updated the data in the object, as well as when that happened. Luckily, the source systems all record activity dates for rows in source tables. So, we will be generically mapping the following columns thusly:
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)
...
Field
...
Datasource
...
Reference
...
eid
...
BANNER
...
term_code
...
BANNER
...
Primary Source - BANNER Academic Terms (stvterm)
Secondary Sources - None
EID - http://ucdavis.edu/course/academicsession/stvterm.stvterm_code
...
title
...
BANNER
...
stvterm.stvterm_desc
...
description
...
BANNER
...
stvterm.stvterm_desc
...
StartDate
...
BANNER
...
stvterm.stvterm_start_date
...
EndDate
...
BANNER
...
stvterm.stvterm_end_date
...
createdBy
...
...
'BANNER'
...
createdDate
...
BANNER
...
stvterm.stvterm_activity_date
...
lastModifiedBy
...
...
'BANNER'
...
lastModifiedDate
...
BANNER
...
stvterm.stvterm_activity_date
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
...