SSR_BR_BND_PRIO

(SQL View)
 Index Back

Pop Select Bind Prior Ed Rec

Send BRON Messages Pop select Bind Prior Ed Record

SELECT DISTINCT A.INSTITUTION , B.SCC_BRINCD_NLD , A.EMPLID ,A.ADM_APPL_NBR FROM PS_ADM_APPL_PROG A , PS_SCC_BRINCD_NLD B , PS_SSR_BR_XLSE_NLD C WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ADM_APPL_PROG A1 WHERE A.EMPLID = A1.EMPLID AND A.ACAD_CAREER = A1.ACAD_CAREER AND A.STDNT_CAR_NBR = A1.STDNT_CAR_NBR AND A.ADM_APPL_NBR =A1.ADM_APPL_NBR AND A.APPL_PROG_NBR = A1.APPL_PROG_NBR AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ= ( SELECT MAX(A2.EFFSEQ) FROM PS_ADM_APPL_PROG A2 WHERE A.EMPLID = A2.EMPLID AND A.ACAD_CAREER = A2.ACAD_CAREER AND A.STDNT_CAR_NBR = A2.STDNT_CAR_NBR AND A.ADM_APPL_NBR =A2.ADM_APPL_NBR AND A.APPL_PROG_NBR = A2.APPL_PROG_NBR AND A.EFFDT = A2.EFFDT) AND B.SCC_BRINTP_NLD = 'I' AND B.EFF_STATUS = 'A' AND %EffdtCheck(SCC_BRINCD_NLD B_ED, B, %CurrentDateIn) AND C.INSTITUTION = A.INSTITUTION AND C.SCC_BRINCD_NLD = B.SCC_BRINCD_NLD AND C.ACAD_CAREER = A.ACAD_CAREER AND %EffdtCheck(SSR_BR_XLSE_NLD C_ED, C, %CurrentDateIn) AND A.ACAD_PROG NOT IN (%Sql(SSR_BR_GET_ACPR_NOT_SEND_SQL, A.INSTITUTION, B.SCC_BRINCD_NLD)) AND A.ACAD_LOAD_APPR NOT IN ( SELECT DISTINCT ACAD_LOAD_APPR FROM PS_SSR_BR_N_LD_NLD LDEX WHERE LDEX.INSTITUTION = A.INSTITUTION AND LDEX.SCC_BRINCD_NLD = B.SCC_BRINCD_NLD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr