SSR_BR_AUD_SEL

(SQL View)
Index Back

BRON HO Audit selection


SELECT DISTINCT SP.EMPLID ,SP.SSR_BRHO_ENRSQ_NLD ,' ' FROM PS_SSR_STD_PRG_NLD SP ,PS_SSR_BR_PRCO_NLD PRCOPT ,PS_ACAD_PROG AP WHERE (SP.SCC_ROW_UPD_DTTM >= PRCOPT.SSR_BR_LSTBRDT_NLD OR AP.SCC_ROW_UPD_DTTM >= PRCOPT.SSR_BR_LSTBRDT_NLD) AND AP.EMPLID = SP.EMPLID AND AP.ACAD_CAREER = SP.ACAD_CAREER AND AP.STDNT_CAR_NBR = SP.STDNT_CAR_NBR AND SP.SSR_BRHO_ENRSQ_NLD <> ' ' UNION ALL SELECT DISTINCT SP.EMPLID ,' ' ,SP.SSR_BRHO_RESEQ_NLD FROM PS_SSR_STD_PRG_NLD SP ,PS_SSR_BR_PRCO_NLD PRCOPT ,PS_ACAD_PROG AP WHERE (SP.SCC_ROW_UPD_DTTM >= PRCOPT.SSR_BR_LSTBRDT_NLD OR AP.SCC_ROW_UPD_DTTM >= PRCOPT.SSR_BR_LSTBRDT_NLD) AND AP.EMPLID = SP.EMPLID AND AP.ACAD_CAREER = SP.ACAD_CAREER AND AP.STDNT_CAR_NBR = SP.STDNT_CAR_NBR AND SP.SSR_BRHO_RESEQ_NLD <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SSR_BRHO_ENRSQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Enrolment Seq Nbr
3 SSR_BRHO_RESEQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Result Seq Nbr