ADM_APPL_PGPLVW

(SQL View)
 Index Back

Admission Applicant Plan View

This view is used in SFPBILGE.DMS

SELECT a.emplid , a.acad_career , a.stdnt_car_nbr , a.adm_appl_nbr , a.appl_prog_nbr , a.acad_plan , b.acad_prog , b.institution , b.prog_status FROM PS_ADM_APPL_PLAN a , ps_adm_appl_prog b WHERE a.emplid = b.emplid AND a.acad_career = b.acad_career AND a.stdnt_car_nbr = b.stdnt_car_nbr AND a.adm_appl_nbr = b.adm_appl_nbr AND a.appl_prog_nbr = b.appl_prog_nbr AND a.effdt = b.effdt AND a.effseq = b.effseq AND a.effdt = ( SELECT MAX(c.effdt) FROM PS_ADM_APPL_PLAN c WHERE c.emplid = a.emplid AND c.acad_career = a.acad_career AND c.stdnt_car_nbr = a.stdnt_car_nbr AND c.adm_appl_nbr = a.adm_appl_nbr AND c.appl_prog_nbr = a.appl_prog_nbr AND c.effdt <= %CurrentDateIn) AND b.effseq = ( SELECT MAX(d.effseq) FROM ps_adm_appl_prog d WHERE d.emplid = b.emplid AND d.acad_career = b.acad_career AND d.stdnt_car_nbr = b.stdnt_car_nbr AND d.adm_appl_nbr = b.adm_appl_nbr AND d.appl_prog_nbr = b.appl_prog_nbr AND d.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

Prompt Table: STDNT_CAREER

3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

Prompt Table: ADM_APPL_DATA

5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

Prompt Table: ADM_APP_CAR_SEQ

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

Prompt Table: ACAD_PLAN_TBLVW

7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
9 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted