Page Comparison

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

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)