SSR_HM_AOP_BND

(SQL View)
 Index Back

Apps bind record

Pop select bind record in Apps/Offers/Preferences process

SELECT DISTINCT A.EMPLID , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.ADM_APPL_NBR FROM PS_ADM_APPL_DATA A , PS_ADM_APPL_PROG B , PS_SAD_APL_PRG_AUS C , PS_SSR_ACD_PRG_AUS PRG_AUS , PS_SCC_CITIZ_HIST CIT , PS_SSR_MAP_358 MAPCIT WHERE A.EMPLID = B.EMPLID AND A.ADM_APPL_NBR = B.ADM_APPL_NBR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND B.EFFDT = ( SELECT MAX(B3.EFFDT) FROM PS_ADM_APPL_PROG B3 WHERE B3.EMPLID = B.EMPLID AND B3.ACAD_CAREER = B.ACAD_CAREER AND B3.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND B3.ADM_APPL_NBR = B.ADM_APPL_NBR AND B3.APPL_PROG_NBR = B.APPL_PROG_NBR AND B3.EFFDT <= %CurrentDateIn) AND B.EFFSEQ = ( SELECT MAX(B1.EFFSEQ) FROM PS_ADM_APPL_PROG B1 WHERE B1.EMPLID = B.EMPLID AND B1.ACAD_CAREER = B.ACAD_CAREER AND B1.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND B1.ADM_APPL_NBR = B.ADM_APPL_NBR AND B1.APPL_PROG_NBR = B.APPL_PROG_NBR AND B1.EFFDT = B.EFFDT) AND C.EMPLID = B.EMPLID AND C.ACAD_CAREER = B.ACAD_CAREER AND C.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND C.ADM_APPL_NBR = B.ADM_APPL_NBR AND C.APPL_PROG_NBR = B.APPL_PROG_NBR AND C.EFFDT = B.EFFDT AND C.EFFSEQ = B.EFFSEQ AND PRG_AUS.ACAD_PROG = B.ACAD_PROG AND PRG_AUS.INSTITUTION = B.INSTITUTION AND PRG_AUS.EFFDT=( SELECT MAX(PRG_AUS1.EFFDT) FROM PS_SSR_ACD_PRG_AUS PRG_AUS1 WHERE PRG_AUS.ACAD_PROG = PRG_AUS1.ACAD_PROG AND PRG_AUS.INSTITUTION = PRG_AUS1.INSTITUTION AND PRG_AUS1.EFFDT <= %CurrentDateIn) AND CIT.EMPLID = B.EMPLID AND CIT.COUNTRY = 'AUS' AND CIT.EFFDT=( SELECT MAX(CIT1.EFFDT) FROM PS_SCC_CITIZ_HIST CIT1 WHERE CIT.EMPLID = CIT1.EMPLID AND CIT1.COUNTRY = CIT.COUNTRY AND CIT1.EFFDT <= A.ADM_APPL_DT) AND MAPCIT.CITIZENSHIP_STATUS = CIT.CITIZENSHIP_STATUS AND MAPCIT.EFFDT =( SELECT MAX(MAPCIT2.EFFDT) FROM PS_SSR_MAP_358 MAPCIT2 WHERE MAPCIT2.CITIZENSHIP_STATUS = MAPCIT.CITIZENSHIP_STATUS AND MAPCIT2.SSR_ELEM_358 = MAPCIT.SSR_ELEM_358 AND MAPCIT2.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr