...
AAUD.STUDENTS / AAUD_STUDENTS | |
---|---|
students_pkey | mothra_person.mothraid||banner_level.term_code, |
students_term_code | banner_level.term_code, |
students_clientid | nvl(mothra_person.studentid,mothra_person.employeeid), |
students_major_code_1 | banner_level.major_code_1 |
students_degree_code_1 | banner_level.degree_code_1 |
students_coll_code_1 | banner_level.college_code_1 |
students_level_code_1 | banner_level.level_code, |
students_major_code_2 | banner_level.major_code_2 |
students_degree_code_2 | banner_level.degree_code_2 |
students_coll_code_2 | banner_level.college_code_2 |
students_level_code_2 | banner_level.level_code_2 |
students_class_level | null --!SGVCLSS_CLAS_CODE (new mviewanalysis required) |
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 | 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 (analysis requirednew mview) |
COURSES.CATALOG / COURSES_CATALOG | |
---|---|
catalog_pkey | banner_section.term_code||banner_section.crn, |
catalog_term_code | banner_section.term_code, |
catalog_subj_code | banner_section.subj_code, |
catalog_crse_numb | banner_section.crse_numb, |
catalog_origin_dept | null, --CAF |
catalog_desc_title | null, --CAF |
catalog_course_desc | null, --CAF |
catalog_quarter_offered | null, --CAF |
catalog_units | null, --CAF |
catalog_prerequisite | null, --CAF |
catalog_repeat_credit | null, --CAF |
catalog_repeat_times | null, --CAF |
catalog_remarks | null, --CAF |
catalog_grading | null, --CAF |
catalog_cafmain_id | null, --CAF |
catalog_cafmain_cafecp | null --CAF |
...