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 <> ' '
|