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 |
|||
term_code |
BANNER |
stvterm.stvterm_code |
CourseSet / BANNER_COURSESET
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 |
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 |
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_OFFERING (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_subj_code scbcrse.scbcrse_crse_numb : scbcrse.scbcrse_title |
status |
|
'active' |
description |
BANNER |
degree_navigator.description / scbcrse.scbcrse_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_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 |
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 |
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)
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 |
|
'Lecture' |
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> |
term_code |
BANNER |
ssbsect.ssbsect_term_code |
crn |
BANNER |
ssbsect.ssbsect_crn |
OfficialInstructors / COURSEMANAGEMENT_INSTRUCTORS
Field |
Datasource |
Reference |
|---|---|---|
eid |
BANNER/MOTHRA |
http://ucdavis.edu/course/enrollmentset/sirasgn.sirasgn_crn/sirasgn.sirasgn_term_code/instructor/sirasgn.sirasgn.pidm |
enrollment_set_id |
BANNER |
http://ucdavis.edu/course/enrollmentset/sirasgn.sirasgn_crn/sirasgn.sirasgn_term_code |
section_id |
BANNER |
http://ucdavis.edu/course/section/ssbsect.ssbsect_subj_code/ssbsect.ssbsect_crse_numb/ssbsect.ssbsect_seq_numb/ssbsect.ssbsect_term_code |
person_eid |
MOTHRA |
mothra_person.mothraid (sirasgn.sirasgn_pidm) |
Enrollment / COURSEMANAGEMENT_ENROLLMENT (EnrollmentCmImpl)
Field |
Datasource |
Reference |
|---|---|---|
eid |
BANNER |
http://ucdavis.edu/course/enrollmentset/sfrstcr.sfrstcr_crn/sfrstcr.sfrstcr_term_code/sfrstcr.sfrstcr_rsts_code/mothra_person.mothraid |
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 |
|---|---|---|
eid |
BANNER |
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 |
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 (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 |