...
COURSES.BASEINFO / COURSES_BASEINFO | |
---|---|
baseinfo_pkey | banner_section.term_code||banner_section.crn, |
baseinfo_term_code | banner_section.term_code, |
baseinfo_crn | banner_section.crn, |
baseinfo_subj_code | banner_section.subj_code, |
baseinfo_crse_numb | banner_section.crse_numb, |
baseinfo_seq_numb | banner_section.sec_numb, |
baseinfo_title | banner_course.crse_title, |
baseinfo_enrollment | banner_section.enrollment, |
baseinfo_unit_type | case when banner_course.credit_hours_variable is 'Y' then 'V' else 'F' end, |
baseinfo_unit_low null, --!SCBCRSE_CREDIT_HR_LOW (add column) | banner_course.credit_hours_low |
baseinfo_unit_high null, --!SCBCRSE_CREDIT_HR_HIGH (add column) | banner_course.credit_hours_high |
baseinfo_coll_code | null, --!SCBCRSE_CREDITCOLL_HR_LOW CODE (add column) |
baseinfo_dept_code | banner_course.dept_code, |
baseinfo_xlist_flag | null, --!SCBCRSE_SUBJ_CODE_XLIST (add column) |
baseinfo_xlist_group | null --!SSRXLIST_XLST_GROUP (new mview) |
...