SSR_STAD_ADVEDT

(SQL View)
 Index Back

Student Advisor Assignment Job

Student Advisor Assignment Job

SELECT PR.INSTITUTION , PR.ACAD_PROG , PR.ADVISOR_EDIT FROM PS_ACAD_PROG_TBL PR WHERE (ADVISOR_EDIT = 'P' OR (ADVISOR_EDIT = 'I' AND EXISTS ( SELECT 'X' FROM PS_INSTR_ADVISOR IA1 WHERE IA1.INSTITUTION = PR.INSTITUTION AND IA1.EFF_STATUS = 'A' AND IA1.EFFDT <= %CurrentDateIn)) OR (ADVISOR_EDIT = 'A' AND EXISTS ( SELECT 'X' FROM PS_INSTR_ADVISOR IA2 , PS_INST_ADV_ROLE IAR2 WHERE IA2.INSTITUTION = PR.INSTITUTION AND IA2.EFF_STATUS = 'A' AND IA2.EFFDT <= %CurrentDateIn AND IA2.EMPLID = IAR2.EMPLID AND IA2.INSTITUTION = IAR2.INSTITUTION AND IAR2.ACAD_CAREER = PR.ACAD_CAREER AND IAR2.EFFDT <= %CurrentDateIn AND IAR2.ACAD_PROG = PR.ACAD_PROG)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
3 ADVISOR_EDIT Character(1) VARCHAR2(1) NOT NULL Advisor Edit
A=Advisor Role
I=Instructor Advisor
P=Personal Data