ACAD_SUBPLN_VW

(SQL View)
 Index Back

Academic Subplan Table View

This is an F4 view of the ACAD_SUBPLAN table used to search for Acad_Sub_Plan given Academic Unit, Academic Program and Academic Plan.

Select a.EMPLID, a.ACAD_CAREER, a.EFFDT, b.INSTITUTION, b.ACAD_PROG, a.ACAD_PLAN, a.ACAD_SUB_PLAN from PS_ACAD_SUBPLAN a,PS_ACAD_PROG b where b.EMPLID = a.EMPLID and b.ACAD_CAREER = a.ACAD_CAREER and b.STDNT_CAR_NBR = a.STDNT_CAR_NBR and b.Effdt = a.Effdt and b.Effseq = a.Effseq and b.Effseq = (select max(c.Effseq) from PS_ACAD_PROG c where c.EMPLID = b.EMPLID and c.ACAD_CAREER = b.ACAD_CAREER and c.STDNT_CAR_NBR = b.STDNT_CAR_NBR and c.EFFDT = b.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

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 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: ACAD_PROG

6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

Prompt Table: ACAD_PLAN

7 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

Prompt Table: ACAD_SUBPLN_TBL