ACAD_PLOVW_LNG (SQL View)	Index Back
Academic Plan Table View This view is used as a prompt table that selects all plans associated with an Academic Program. It is used as a prompt in the Transcript Request panel (when a What-If advisement report is also included) to override the current academic plan.

ACAD_PLOVW_LNG

(SQL View)

Academic Plan Table View

This view is used as a prompt table that selects all plans associated with an Academic Program. It is used as a prompt in the Transcript Request panel (when a What-If advisement report is also included) to override the current academic plan.

SELECT DISTINCT a.institution , b.acad_career , b.acad_prog , a.acad_plan , al.language_cd , a.effdt , al.descr FROM PS_ACAD_PLAN_TBL a , ps_acad_plan_lang al , 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) OR A.ACAD_CAREER=' ') AND a.institution = al.institution AND a.acad_plan = al.acad_plan AND a.effdt = al.effdt

# 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_CAREER_OVRD Character(4) VARCHAR2(4) NOT NULL In What-If Requirements Analysis, the target Career for the model.
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VETM=Veterinary Medicine

3 ACAD_PROG_OVRD Character(5) VARCHAR2(5) NOT NULL In What-If Requirements Analysis, the target Program for the model.

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

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

#	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_CAREER_OVRD	Character(4)	VARCHAR2(4) NOT NULL	In What-If Requirements Analysis, the target Career for the model. BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VETM=Veterinary Medicine
3	ACAD_PROG_OVRD	Character(5)	VARCHAR2(5) NOT NULL	In What-If Requirements Analysis, the target Program for the model.
4	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan Prompt Table: ACAD_PLAN_TBL
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description