SAD_PRS_PRG_VW2 (SQL View)	Index Back
Academic Program No Security This is a clone of SAD_PRS_PRG_VW / ACAD_PROG_SCTY2. Prompt view which does not enforce Academic Program operator security. It checks to see if the programs are valid for the Admit Term and the the Admit Term is greater than the Last Admit Term for a Program.

SAD_PRS_PRG_VW2

(SQL View)

Academic Program No Security

This is a clone of SAD_PRS_PRG_VW / ACAD_PROG_SCTY2. Prompt view which does not enforce Academic Program operator security. It checks to see if the programs are valid for the Admit Term and the the Admit Term is greater than the Last Admit Term for a Program.

SELECT a.institution ,a.acad_career ,a.acad_prog ,a.descr FROM PS_ACAD_PROG_TBL a WHERE (%CurrentDateIn <= a.SSR_LAST_PRS_DT OR a.SSR_LAST_PRS_DT IS NULL) AND a.effdt = ( SELECT MAX(effdt) FROM PS_ACAD_PROG_TBL a1 WHERE a.institution = a1.institution AND a.acad_prog = a1.acad_prog 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
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

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
Prompt Table: ACAD_CAR_TBL

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

4 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 Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
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 Prompt Table: ACAD_CAR_TBL
3	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_TBL
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description