SSR_BR_BND_DIP

(SQL View)
 Index Back

Pop Select Bind Diploma Rec

Send BRON Messages Pop select Bind Diploma Record

SELECT ES.INSTITUTION , ES.SCC_BRINCD_NLD , ES.EMPLID , ES.ACAD_CAREER , ES.STDNT_CAR_NBR , APT.HEGIS_CODE FROM PS_SSR_BR_ENRVWNLD ES JOIN PS_ACAD_PROG AP ON ES.INSTITUTION = AP.INSTITUTION AND ES.EMPLID = AP.EMPLID AND ES.ACAD_CAREER =AP.ACAD_CAREER AND ES.STDNT_CAR_NBR = AP.STDNT_CAR_NBR JOIN PS_ACAD_PROG_TBL APT ON AP.ACAD_PROG = APT.ACAD_PROG AND AP.EFFDT = ( SELECT MAX(APT1_ED.EFFDT) FROM PS_ACAD_PROG APT1_ED WHERE APT1_ED.EMPLID = AP.EMPLID AND APT1_ED.ACAD_CAREER = AP.ACAD_CAREER AND APT1_ED.STDNT_CAR_NBR =AP.STDNT_CAR_NBR AND APT1_ED.EFFDT <= %CurrentDateIn) AND AP.EFFSEQ = ( SELECT MAX(APT2_ED.EFFSEQ) FROM PS_ACAD_PROG APT2_ED WHERE APT2_ED.EMPLID = AP.EMPLID AND APT2_ED.ACAD_CAREER = AP.ACAD_CAREER AND APT2_ED.STDNT_CAR_NBR =AP.STDNT_CAR_NBR AND APT2_ED.EFFDT = AP.EFFDT) AND APT.EFFDT = ( SELECT MAX(APT_ED.EFFDT) FROM PS_ACAD_PROG_TBL APT_ED WHERE APT_ED.ACAD_PROG = APT.ACAD_PROG AND APT_ED.EFFDT <= AP.EFFDT)

# 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 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
5 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
6 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code