SEV_I20_INST_VW

(SQL View)
 Index Back

Student Acad Prog Inst Vw

This view displays the distinct Institutions that a student is attending from the ACAD_PROG table.

SELECT DISTINCT a.Emplid , a.Institution FROM PS_ACAD_PROG a WHERE a.EffSeq = ( SELECT MAX(b.EffSeq) FROM PS_ACAD_PROG b WHERE b.Emplid = a.Emplid AND b.Institution = a.Institution AND b.Acad_Career = a.Acad_Career AND b.Stdnt_Car_Nbr = a.Stdnt_Car_Nbr)

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution