...
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 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 |
...