SSR_BR_ENSTA_VW

(SQL View)
 Index Back

Enrol Seq nbr for status page


SELECT DISTINCT SP1.EMPLID ,SP1.SSR_BRHO_ENRSQ_NLD FROM PS_SSR_STD_PRG_NLD SP , PS_SSR_STD_PRG_NLD SP1 WHERE SP.ssr_prg_action_nld = ( SELECT ssr_prg_action_nld FROM ps_ssr_br_ecnf_nld) AND SP.SSR_BRHO_ENRSQ_NLD = sp1.SSR_BRHO_ENRSQ_NLD AND SP1.EMPLID = SP.EMPLID AND SP1.ACAD_CAREER = SP.ACAD_CAREER AND SP1.STDNT_CAR_NBR = SP.STDNT_CAR_NBR AND 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_ENRSQ_NLD = SP1_1.SSR_BRHO_ENRSQ_NLD AND (SP1_1.ssr_prg_action_nld IN ( SELECT ET.ssr_prg_action_nld FROM ps_SSR_BR_ETRG_NLD ET) OR SP1_1.ssr_prg_action_nld = 'MATR')) 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_ENRSQ_NLD = SP1_2.SSR_BRHO_ENRSQ_NLD AND SP1_2.EFFDT = SP1.effdt)

# 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_ENRSQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Enrolment Seq Nbr