SAD_PRS_PLN_VW2 (SQL View)	Index Back
Academic Plan No Security View This view is a clone of SAD_PRS_PLN_VW / ACAD_PLAN_SVW. By using this view as a prompt table you will be able to selects all plans that are associated with an Academic Program or a career within an Institution and plan that are valid for the Admit Term and the Admit Term is either less than or equal to the Last Admit Term or the Last Admit Term is blank.

SAD_PRS_PLN_VW2

(SQL View)

Academic Plan No Security View

This view is a clone of SAD_PRS_PLN_VW / ACAD_PLAN_SVW. By using this view as a prompt table you will be able to selects all plans that are associated with an Academic Program or a career within an Institution and plan that are valid for the Admit Term and the Admit Term is either less than or equal to the Last Admit Term or the Last Admit Term is blank.

SELECT DISTINCT a.institution , b.acad_prog , a.acad_plan , a.descr , a.acad_career , a.acad_plan_type , a.degree FROM PS_ACAD_PLAN_TBL a , ps_acad_prog_tbl b WHERE a.institution = b.institution AND (a.acad_prog = b.acad_prog OR (a.acad_prog = ' ' AND a.acad_career = b.acad_career)) AND (%CurrentDateIn <= a.SSR_LAST_PRS_DT OR a.SSR_LAST_PRS_DT IS NULL) AND a.effdt = ( SELECT MAX(effdt) FROM PS_ACAD_PLAN_TBL a1 WHERE a.institution = a1.institution AND a.acad_plan = a1.acad_plan AND a1.effdt <= %CurrentDateIn) AND a.eff_status <> 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Prompt Table: ACAD_PROG_TBL

3 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
Prompt Table: ACAD_PLAN_TBL

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 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

6 ACAD_PLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Plan Type
CON=Concentration
COS=Course of Study
HON=Honors
MAJ=Major
MIN=Minor
PRP=Preparation
RTC=ROTC
SP=Specialization

7 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_TBL
3	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan Prompt Table: ACAD_PLAN_TBL
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	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
6	ACAD_PLAN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Academic Plan Type CON=Concentration COS=Course of Study HON=Honors MAJ=Major MIN=Minor PRP=Preparation RTC=ROTC SP=Specialization
7	DEGREE	Character(8)	VARCHAR2(8) NOT NULL	Degree