...
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 | 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 | 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 | DEFERRED: null --!SGVCLSS_CLAS_CODE (analysis required) |
...