Page Comparison

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

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)