SSR_VB_ACDTLVW

(SQL View)
 Index Back

SELECT prg.EMPLID , prg.INSTITUTION , prg.ADMIT_TERM , prg.ACAD_CAREER , prg.STDNT_CAR_NBR , prg.EFFDT , prg.EFFSEQ , prg.ACAD_PROG ,prg.PROG_STATUS , prg.ACAD_LOAD_APPR , pln.ACAD_PLAN , sp.ACAD_SUB_PLAN FROM %Table(ACAD_PROG) prg LEFT OUTER JOIN %Table(ACAD_PLAN) pln ON prg.EMPLID = pln.EMPLID AND prg.ACAD_CAREER = pln.ACAD_CAREER AND prg.STDNT_CAR_NBR = pln.STDNT_CAR_NBR AND prg.EFFDT = pln.EFFDT AND prg.EFFSEQ = pln.EFFSEQ LEFT OUTER JOIN %Table(ACAD_SUBPLAN) sp ON pln.EMPLID = sp.EMPLID AND pln.ACAD_CAREER = sp.ACAD_CAREER AND pln.STDNT_CAR_NBR = sp.STDNT_CAR_NBR AND pln.EFFDT = sp.EFFDT AND pln.EFFSEQ = sp.EFFSEQ AND pln.ACAD_PLAN = sp.ACAD_PLAN WHERE prg.effdt = ( SELECT MAX(prg2.effdt) FROM %Table(ACAD_PROG) prg2 WHERE prg.EMPLID = prg2.EMPLID AND prg.ACAD_CAREER = prg2.ACAD_CAREER AND prg.STDNT_CAR_NBR = prg2.STDNT_CAR_NBR AND prg2.effseq=( SELECT MAX(prg3.effseq) FROM %Table(ACAD_PROG) prg3 WHERE prg3.EMPLID = prg2.EMPLID AND prg3.ACAD_CAREER = prg2.ACAD_CAREER AND prg3.STDNT_CAR_NBR = prg2.STDNT_CAR_NBR AND prg3.effdt = prg2.effdt))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
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 EFFDT Date(10) DATE Effective Date
7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
8 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
9 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted
10 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
11 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
12 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan