...
AAUD.IDS / AAUD_IDS | |
---|---|
ids_pkey | mothra_person.mothraid, |
ids_term_code | null, --only latest data is recorded in external database |
ids_clientid | nvl(mothra_person.studentid,mothra_person.employeeid), |
ids_mothraid | mothra_person.mothraid, |
ids_logind | mothra_person.kerberos_name, |
ids_mailid | mothra_person.email, |
ids_spriden_id | null, --!Add to Mothra Person table/feed |
ids_pidm | mothra_person.banner_pidm, |
ids_employee_id | mothra_person.employeeid, |
ids_vmacs_id | null --SVM specific field |
...
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 | null, --!SGBSTDN_MAJR_CODE_1 (add column) |
students_degree_code_1 | null, --!SGBSTDN_DEGC_CODE_1 (add column) |
students_coll_code_1 | null, --!SGBSTDN_COLL_CODE_1 (add column) |
students_level_code_1 | banner_level.level_code, |
students_major_code_2 | null, --!SGBSTDN_MAJR_CODE_2 (add column) |
students_degree_code_2 | null, --!SGBSTDN_DEGC_CODE_2 (add column) |
students_coll_code_2 | null, --!SGBSTDN_COLL_CODE_2 (add column) |
students_level_code_2 | null, --!SGBSTDN_LEVL_CODE_2 (add column) |
students_class_level | null --!SGVCLSS_CLAS_CODE (new mview) |
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) |
baseinfo_unit_high | null, --!SCBCRSE_CREDIT_HR_HIGH (add column) |
baseinfo_coll_code | null, --!SCBCRSE_CREDIT_HR_LOW (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) |
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 |
...
COURSES.TERMINFO / COURSES_TERMINFO | |
---|---|
term_academic_year | case when banner_term.term_id >= 9 then banner_term.term_yr + 1 else banner_term.term_yr end, |
term_code | banner_term.term_code, |
term_desc | banner_term.term_desc, |
term_coll_code | null, --Not in current use |
term_start_date | banner_term.start_date, |
term_end_date | banner_term.end_date, |
term_current_term | case when sysdate between banner_term.start_date and banner_term.end_date then 1 else 0 end, |
term_academic_year_description | case when banner_term.term_id >= 9 then banner_term.term_yr||banner_term.term_yr+1 else banner_term.term_yr-1||banner_term.term_yr end |
Key | |
---|---|
Style | Description |
Plain Text | Currently mapped data |
Green Text | Data that must be added to an existing MView before being mapped |
Blue Text | Data requiring a new MView before being mapped |
Bold Text | Data that does not exist in the external database and will not be mapped |