SSR_RS_SUPROLVW

(SQL View)
 Index Back

Instructor/Advisor Role

This table contains the instructors and advisors and the type of instructors they are.

SELECT DISTINCT D.INSTITUTION ,D.EMPLID FROM %Table(SSR_ADMN_HDR) D WHERE D.SSR_AFL_TYP = 'S'

  • Parent record: INSTR_ADVISOR

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