...
AAUD.FLAGS / AAUD_FLAGS | |
---|---|
flags_pkey | mothra_person.mothraid, |
flags_term_code | null, --only latest data is recorded in external database |
flags_clientid | nvl(mothra_person.studentid,mothra_person.employeeid), |
flags_student | case when mothra_person.studentid is null user_type IN ('U','R','P','C') then 1 else 0 end, |
flags_academic | null, --PPS (maybe when mothra_person.user_type IN ('F','M','P','C') then 1 else 0 end) |
flags_staff | case when mothra_person.user_type is IN ('S','R','M','C') then 1 else 0 end , |
flags_teaching_faculty | case when mothra_person.teaching_flag is 'Y' then 1 else 0 end, |
flags_wosemp | null, --PPS |
flags_confidential | case when mothra_person.last is 'CONFIDENTIAL' then 1 else 0 end, |
flags_svm_people | null, --SVM specific field |
flags_svm_student | null --SVM specific field |
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 | DEFERRED: banner_id.spriden_id |
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) | banner_level.major_code_1 |
students_degree_code_1 null, --!SGBSTDN_DEGC_CODE_1 (add column) | banner_level.degree_code_1 |
students_coll_code_1 null, --!SGBSTDN_COLL_CODE_1 (add column) | banner_level.college_code_1 |
students_level_code_1 | banner_level.level_code, |
students_major_code_2 null, --!SGBSTDN_MAJR_CODE_2 (add column) | banner_level.major_code_2 |
students_degree_code_2 null, --!SGBSTDN_DEGC_CODE_2 (add column) | banner_level.degree_code_2 |
students_coll_code_2 null, --!SGBSTDN_COLL_CODE_2 (add column) | banner_level.college_code_2 |
students_level_code_2 null, --!SGBSTDN_LEVL_CODE_2 (add column) | banner_level.level_code_2 |
students_class_level | DEFERRED: 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 null, --!SCBCRSE_COLL_CODE (add column) | banner_course.college_code |
baseinfo_dept_code | banner_course.dept_code, |
baseinfo_xlist_flag null, --!SCBCRSE_SUBJ_CODE_XLIST (add column) | case when banner_course.crosslist_subj_code is null then 1 else 0 end |
baseinfo_xlist_group | null --!SSRXLIST_XLST_GROUP (new mview) |
...