...
Primary Source(s) - BANNER Section Meeting table, (ssrmeet), BANNER Section table (ssbsect)
Secondary Source(s) - Mothra Person Table (ucd_person_t)
EID(s) - http://ucdavis.edu/course/section/meeting/SSRMEET_TERM_CODE/SSRMEET_CRN/SSRMEET_BLDG_CODE/ SSRMEET_ROOM_CODE/SSRMEET_BEGIN_TIME/SSRMEET_END_TIME/SSRMEET_CATAGORY/SSRMEET_MON_DAY/SSRMEET_TUE_DAY/ SSRMEET_WED_DAY/SSRMEET_THU_DAY/SSRMEET_FRI_DAY/SSRMEET_SAT_DAY/SSRMEET_SUN_DAY|
Description - The Enrollment object records all of the data required to notate an student registration to an enrollmentset / section.
Derived Values - The begin and end times are recorded as strings and must be converted to an Oracle timestamp in order for Hibernate to use them.
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 ssrmeet table.)
Data Issues: This table is a case study in dirty data, lack of primary keys, and bad enforcement of business rules. In short, almost every column in the table is required in order to resolve a unique eid.
Section Category (BANNER_SECTION_CATEGORY)
Field | Datasource | Reference |
---|---|---|
code | BANNER | stvschd.stvschd_code |
label | BANNER | stvschd.stvschd_desc |
description | BANNER | stvschd.stvschd_desc_2 |
createdBy |
| 'BANNER' |
createdDate | BANNER | stvschd.stvschd_activity_date |
lastModifiedBy |
| 'BANNER' |
lastModifiedDate | BANNER | stvschd.stvschd_activity_date |
Grading Scheme (BANNER_GRADING_SCHEME)
Field | Datasource | Reference |
---|---|---|
code | BANNER | stvgmod.stvgmod_code |
description | BANNER | stvgmod.stvgmod_desc |
createdBy |
| 'BANNER' |
createdDate | BANNER | stvgmod.stvgmod_activity_date |
lastModifiedBy |
| 'BANNER' |
lastModifiedDate | BANNER | stvgmod.stvgmod_activity_date |
Enrollment Status (BANNER_ENROLLMENTSTATUS)
...
Field
...
Datasource
...
Reference
...
code
...
BANNER
...
stvrsts.stvrsts_code
...
description
...
BANNER
...
stvrsts.stvrsts_desc
...
createdBy
...
...
'BANNER'
...
createdDate
...
BANNER
...
stvrsts.stvrsts_activity_date
...
lastModifiedBy
...
...
'BANNER'
...
lastModifiedDate
...
BANNER
...
Primary Source(s) - BANNER Schedule Table (stvschd)
Secondary Source(s) - none
EID(s) - None
Description - The section category mview is used to look up category codes from the section mview for their descriptive information.
Derived Values - None
Mapping Issues - None
Grading Scheme (BANNER_GRADING_SCHEME)
Primary Source(s) - BANNER Grade Mode Table (stvgmod)
Secondary Source(s) - None
EID(s) - None
Description - The grading scheme mview is used to look up grade mode codes from the enrollment mview for their descriptive information.
Derived Values - None
Mapping Issues - None
Enrollment Status (BANNER_ENROLLMENTSTATUS)
Primary Source(s) - BANNER Registration Status Table (stvrsts)
Secondary Source(s) - None
EID(s) - None
Description - The enrollment status mview is used to look up registration codes from the enrollment mview for their descriptive information.
Derived Values - None
Mapping Issues - None