SSR_RS_PRISUPVW

(SQL View)
 Index Back

RET Supervisors

Supervisor - Research Enrollment Tracking

SELECT SUPRVSR.EMPLID , SUPRVSR.INSTITUTION ,SUPRVSR.SSR_RS_CANDIT_NBR , SUPRVSR.SSR_RS_SUPER_ID , SUPRVSR.SSR_RS_SUPER_TYPE , SUPRVSR.SSR_RS_STATUS , SUPRVSR.SSR_RS_PRI_SUPR FROM %Table(SSR_RS_SUPRVSRS) SUPRVSR WHERE SUPRVSR.SSR_RS_PRI_SUPR = 'Y' AND %EffdtCheck( SSR_RS_SUPRVSRS eff1, SUPRVSR,%currentdatein) AND SUPRVSR.effseq = ( SELECT MAX(eff2.effseq) FROM %Table(SSR_RS_SUPRVSRS) eff2 WHERE SUPRVSR.EMPLID = eff2.EMPLID AND SUPRVSR.INSTITUTION = eff2.INSTITUTION AND SUPRVSR.SSR_RS_CANDIT_NBR = eff2.SSR_RS_CANDIT_NBR AND SUPRVSR.ssr_rs_super_nbr = eff2.ssr_rs_super_nbr AND SUPRVSR.effdt = eff2.effdt) AND SUPRVSR.SSR_RS_SUPER_ID <> ' '

  • Parent record: SSR_RS_CAND_HDR

    • # 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
    3 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number
    4 SSR_RS_SUPER_ID Character(11) VARCHAR2(11) NOT NULL Supervisor Number
    5 SSR_RS_SUPER_TYPE Character(4) VARCHAR2(4) NOT NULL Supervisor Role
    6 SSR_RS_STATUS Character(12) VARCHAR2(12) NOT NULL Status associated within the status group code.

    Prompt Table: %EDITTABLE16

    7 SSR_RS_PRI_SUPR Character(1) VARCHAR2(1) NOT NULL Primary Supervisor

    Y/N Table Edit