FA_APPL_PROG_VW

(SQL View)
 Index Back

FA Admission Applicant Prog VW

This Admission Applicant Program Table view is used to display Application data as part of Early Financial Aid Offer

select a.emplid, a.acad_career, a.stdnt_car_nbr, a.adm_appl_nbr, a.appl_prog_nbr, a.effdt, a.effseq, a.institution, a.acad_prog, a.prog_status, a.prog_action, a.prog_reason, a.action_dt, a.admit_term, a.exp_grad_term, a.req_term, a.acad_load_appr, a.campus, a.acad_prog_dual, a.joint_prog_appr from ps_adm_appl_prog a, ps_adm_app_car_seq b, PS_ADM_APPL_DATA c where a.emplid = b.emplid and b.emplid = c.emplid and a.acad_career = b.acad_career and b.acad_career = c.acad_career and a.stdnt_car_nbr = b.stdnt_car_nbr and b.stdnt_car_nbr = c.stdnt_car_nbr and a.adm_appl_nbr = b.adm_appl_nbr and b.adm_appl_nbr = c.adm_appl_nbr and a.appl_prog_nbr = b.appl_prog_nbr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
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
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
5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
6 EFFDT Date(10) DATE NOT NULL Effective Date
7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
9 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
10 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
11 PROG_ACTION Character(4) VARCHAR2(4) NOT NULL Program Action
ACTV=Activate
ADMT=Admit
ADRV=Admission Revocation
APPL=Application
COMP=Completion of Program
COND=Conditional Admit
DATA=Data Change
DDEF=Defer Decision
DEFR=Defer Enrollment
DEIN=Intention to Matriculate
DENY=Deny
DISC=Discontinuation
DISM=Dismissal
LEAV=Leave of Absence
MATR=Matriculation
PLNC=Plan Change
PRGC=Program Change
RADM=Readmit
RAPP=Readmit Application
RECN=Reconsideration
REVK=Revoke Degree
RLOA=Return from Leave of Absence
SPND=Suspension
TRAN=Transfer to Other Career
VDIS=Voluntarily Discontinued
WADM=Administrative Withdrawal
WAIT=Waitlist
WAOF=Waitlist Offer
WAPP=Applicant Withdrawal
12 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason
13 ACTION_DT Date(10) DATE Action Date
14 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
15 EXP_GRAD_TERM Character(4) VARCHAR2(4) NOT NULL Expected Graduation Term
16 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term
17 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
18 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
19 ACAD_PROG_DUAL Character(5) VARCHAR2(5) NOT NULL Dual Academic Program
20 JOINT_PROG_APPR Character(1) VARCHAR2(1) NOT NULL Joint Program Approved

Y/N Table Edit