SAD_APP_PRG_VW3

(SQL View)
 Index Back

Academic Program No Security

This is a clone of SAD_APP_PRG_VW. 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 ,d.strm ,a.acad_prog ,a.descr ,a.descrshort FROM PS_ACAD_PROG_TBL a ,ps_term_tbl d WHERE (d.strm <= a.SSR_LAST_ADM_TERM OR a.SSR_LAST_ADM_TERM = ' ') AND a.institution = d.institution AND a.acad_career = d.acad_career 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 <= d.term_begin_dt) AND a.eff_status <> 'I' AND a.institution = d.institution

# 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 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

Prompt Table: ACAD_PROG_TBL

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

Prompt Table: ACAD_PROG_TBL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description