Page Comparison

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

banner_course.credit_hours_low

baseinfo_unit_high

banner_course.credit_hours_high

baseinfo_coll_code

banner_course.college_code

baseinfo_dept_code

banner_course.dept_code,

baseinfo_xlist_flag

case when banner_course.crosslist_subj_code is null then 1 else 0 end

baseinfo_xlist_group

null --!SSRXLIST_XLST_GROUP (new mviewanalysis required)