SSR_BR_RESTA_VW

(SQL View)
 Index Back

BRON HO Result Current View

BRON HO Results Data Selection Current View

SELECT DISTINCT SP1.EMPLID ,SP1.SSR_BRHO_RESEQ_NLD FROM PS_SSR_STD_PRG_NLD SP1 WHERE SP1.effdt = ( SELECT MAX(SP1_1.EFFDT) FROM PS_SSR_STD_PRG_NLD SP1_1 WHERE SP1.emplid = SP1_1.EMPLID AND SP1.SSR_BRHO_RESEQ_NLD = SP1_1.SSR_BRHO_RESEQ_NLD AND SP1.EFFSEQ = ( SELECT MAX(SP1_2.EFFSEQ) FROM PS_SSR_STD_PRG_NLD SP1_2 WHERE SP1.emplid = SP1_2.EMPLID AND SP1.SSR_BRHO_RESEQ_NLD = SP1_2.SSR_BRHO_RESEQ_NLD AND SP1_2.EFFDT = SP1.effdt) AND SP1_1.ssr_prg_action_nld IN ( SELECT RT.ssr_prg_action_nld FROM PS_SSR_BR_RTRG_NLD RT))

  • Parent record: SSR_BR_TRIN_NLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number
    2 SSR_BRHO_RESEQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Result Seq Nbr