Smartsite CourseManagement - Banner Course Data Maps
This page will list each Course Management object and the mapping of Banner data to the object fields.
AcademicSession / BANNER_ACADEMICSESSION (AcademicSessionCmImpl)
Field |
Datasource |
Reference |
---|---|---|
eid |
BANNER |
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 |
CourseSet / BANNER_COURSESET
College Listings
Note: New mview log required on stvcoll
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 |
Department Listings
Field |
Datasource |
Reference |
---|---|---|
eid |
BANNER |
http://ucdavis.edu/course/courseset/department/stvdept.stvdept_code |
title |
BANNER |
stvdept.stvdept_desc |
description |
BANNER |
stvdept.stvdept_desc |
Category |
|
'DEPARTMENT' |
Parent |
|
N/A |
createdBy |
|
'BANNER' |
createdDate |
BANNER |
stvdept.stvdept_activity_date |
lastModifiedBy |
|
'BANNER' |
lastModifiedDate |
BANNER |
stvdept.stvdept_activity_date |
CanonicalCourses |
BANNER |
BANNER_CANON_COURSESETS |
CourseOfferings |
|
BANNER_OFFERING_COURSESETS |
Subject Listings
Field |
Datasource |
Reference |
|
---|---|---|---|
eid |
BANNER |
http://ucdavis.edu/course/courseset/subject/stvsubj.stvsubj_code | |
title |
BANNER |
stvsubj.stvsubj_desc |
|
description |
BANNER |
stvsubj.stvsubj_desc |
|
Category |
|
'SUBJECT' |
|
Parent |
|
|
|
createdBy |
|
'BANNER' |
|
createdDate |
BANNER |
stvsubj.stvsubj_activity_date |
|
lastModifiedBy |
|
'BANNER' |
|
lastModifiedDate |
BANNER |
stvsubj.stvsubj_activity_date |
|
CanonicalCourses |
BANNER |
BANNER_CANON_COURSESETS |
|
CourseOfferings |
|
BANNER_OFFERING_COURSESETS |
|
CanonicalCourse / BANNER_CANONICALCOURSE (CanonicalCourseCmImpl)
Field |
Datasource |
Reference |
---|---|---|
eid |
BANNER |
http://ucdavis.edu/course/canonical/scbcrse.scbcrse_subj_code/scbcrse.scbcrse_crse_numb |
title |
BANNER |
scbcrse.scbcrse_subj_code scbcrse.scbcrse_crse_numb |
description |
BANNER |
scbcrse.scbcrse_subj_code scbcrse.scbcrse_crse_numb |
hashCode |
|
|
courseSets |
BANNER |
BANNER_CANON_COURSESETS |
crossListing |
BANNER |
No usable mapping exists. The scbcrse table records subj_code/crse_numb pairs for cross listings, but in some cases those values have changed over time (ANT 101). |
createdBy |
|
'BANNER' |
createdDate |
BANNER |
scbcrse.scbcrse_activity_date |
lastModifiedBy |
|
'BANNER' |
lastModifiedDate |
BANNER |
scbcrse.scbcrse_activity_date |
Canonical Course CourseSets / BANNER_CANON_COURSESETS
Field |
Datasource |
Reference |
---|---|---|
canonicalcourse_eid |
BANNER |
http://ucdavis.edu/course/canonical/scbcrse.scbcrse_subj_code/scbcrse.scbcrse_crse_numb |
courseset_eid |
BANNER |
http://ucdavis.edu/course/courseset/
<college,department,subject> / <scbcrse.scbcrse_coll_code,scbcrse.scbcrse_dept_code,scbcrse.scbcrse_subj_code> |
CourseOffering / COURSEMANAGEMENT_COURSEOFFERING (CourseOfferingCmImpl)
Field |
Datasource |
Reference |
---|---|---|
eid |
BANNER |
http://ucdavis.edu/course/offering/scbcrse.scbcrse_subj_code/scbcrse.scbcrse_crse_numb/stvterm.stvterm_code |
title |
BANNER |
scbcrse.scbcrse_crse_title |
description |
BANNER |
degree_nav_desc.description (scbcrse.scbcrse_crse_title) |
academicsession_eid |
BANNER |
http://ucdavis.edu/course/academicsession/stvterm.stvterm_code |
canonicalcourse_eid |
BANNER |
http://ucdavis.edu/course/canonical/scbcrse.scbcrse_subj_code/scbcrse.scbcrse_crse_numb |
StartDate |
BANNER |
stvterm.stvterm_start_date |
EndDate |
BANNER |
stvterm.stvterm_end_date |
createdBy |
|
'BANNER' |
createdDate |
BANNER |
scbcrse.scbcrse_activity_date |
lastModifiedBy |
|
'BANNER' |
lastModifiedDate |
BANNER |
scbcrse.scbcrse_activity_date |
CourseSets |
BANNER |
BANNER_OFFERING_COURSESETS |
Course Offering CourseSets / BANNER_OFFERING_COURSESETS
Field |
Datasource |
Reference |
---|---|---|
courseoffering_eid |
BANNER |
http://ucdavis.edu/course/offering/scbcrse.scbcrse_subj_code/scbcrse.scbcrse_crse_numb/stvterm.stvterm_code |
courseset_eid |
BANNER |
http://ucdavis.edu/course/courseset/
<college,department,subject> / <scbcrse.scbcrse_coll_code,scbcrse.scbcrse_dept_code,scbcrse.scbcrse_subj_code> |
Section / COURSEMANAGEMENT_SECTION (SectionCmImpl)
Field |
Datasource |
Reference |
---|---|---|
eid |
BANNER |
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_crse_title |
description |
BANNER |
ssbsect.ssbsect_crse_title |
Category |
BANNER |
ssbsect.ssbsect_schd_code |
courseoffering_eid |
BANNER |
http://ucdavis.edu/course/offering/banner_section.subj_code/banner_section.crse_numb/banner_section.term_code |
enrollmentset_eid |
BANNER |
http://ucdavis.edu/course/enrollmentset/ssbsect.ssbsect_crn/ssbsect.ssbsect_term_code |
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 |
EnrollmentSet / COURSEMANAGEMENT_ENROLLMENTSET (EnrollmentSetCmImpl)
Field |
Datasource |
Reference |
---|---|---|
eid |
BANNER |
http://ucdavis.edu/course/enrollmentset/ssbsect.ssbsect_crn/ssbsect.ssbsect_term_code |
title |
BANNER |
ssbsect.ssbsect_crse_title |
description |
BANNER |
ssbsect.ssbsect_crse_title |
courseoffering_eid |
BANNER |
http://ucdavis.edu/course/offering/ssbsect.ssbsect_subj_code/ssbsect.ssbsect_crse_numb/ssbsect.ssbsect_term_code |
DefaultEnrollmentCredits |
ssbsect.ssbsectr_credit_hrs |
|
Category |
|
|
createdBy |
|
'BANNER' |
createdDate |
BANNER |
ssbsect.ssbsect_activity_date |
lastModifiedBy |
|
'BANNER' |
lastModifiedDate |
BANNER |
ssbsect.ssbsect_activity_date |
OfficialInstructors |
BANNER |
select user_id from coursemanagement_instructors where enrollmentset = <eid> |
OfficialInstructors / COURSEMANAGEMENT_INSTRUCTORS
Field |
Datasource |
Reference |
---|---|---|
enrollment_set_id |
http://ucdavis.edu/course/enrollmentset/sirasgn.sirasgn_crn/sirasgn.sirasgn_term_code | |
person_eid |
mothra_person.mothraid (sirasgn.sirasgn_pidm) |
Enrollment / COURSEMANAGEMENT_ENROLLMENT (EnrollmentCmImpl)
Field |
Datasource |
Reference |
---|---|---|
enrollmentset_eid |
BANNER |
http://ucdavis.edu/course/enrollmentset/sfrstcr.sfrstcr_crn/sfrstcr.sfrstcr_term_code |
person_eid |
BANNER |
mothra_person.mothraid (sfrstcr.sfrstcr_pidm) |
EnrollmentStatus |
BANNER |
sfrstcr.sfrstcr_rsts_code |
Dropped |
BANNER |
case when sfrstcr.sfrstcr_rsts_code IN ('RE','WL') then 0 else 1 end |
Credits |
BANNER |
sfrstcr.sfrstcr_credit_hr |
GradingScheme |
BANNER |
sfrstcr.sfrstcr_gmod_code |
createdBy |
|
'BANNER' |
createdDate |
BANNER |
sfrstcr.sfrstcr_activity_date |
lastModifiedBy |
|
'BANNER' |
lastModifiedDate |
BANNER |
sfrstcr.sfrstcr_activity_date |
Meeting (MeetingCmImpl)
Field |
Datasource |
Reference |
---|---|---|
section_eid |
BANNER |
http://ucdavis.edu/course/section/ssbsect.ssbsect_subj_code/ssbsect.ssbsect_crse_numb/ssbsect.ssbsect_seq_numb/ssbsect.ssbsect_term_code |
StartTime |
BANNER |
ssrmeet.ssrmeet_begin_time |
EndTime |
BANNER |
ssrmeet.ssrmeet_end_time |
Location |
BANNER |
ssrmeet.ssrmeet_bldg_code ssrmeet.ssrmeet_room_code |
Sunday |
BANNER |
ssrmeet.ssrmeet_sun_day |
Monday |
BANNER |
ssrmeet.ssrmeet_mon_day |
Tuesday |
BANNER |
ssrmeet.ssrmeet_tue_day |
Wendesday |
BANNER |
ssrmeet.ssrmeet_wed_day |
Thursday |
BANNER |
ssrmeet.ssrmeet_thu_day |
Friday |
BANNER |
ssrmeet.ssrmeet_fir_day |
Saturday |
BANNER |
ssrmeet.ssrmeet_sat_day |
Notes |
|
|
createdBy |
|
'BANNER' |
createdDate |
BANNER |
ssrmeet.ssrmeet_activity_date |
lastModifiedBy |
|
'BANNER' |
lastModifiedDate |
BANNER |
ssrmeet.ssrmeet_activity_date |
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 |