SAD_APPLSUMM_VW(SQL View) |
Index Back |
|---|---|
Application Summary ViewReturns summary of applicant's applications joined with a security view |
| SELECT A.EMPLID , D.OPRID , A.INSTITUTION , A.ADM_APPL_NBR , A.ACAD_CAREER , A.adm_appl_dt , A.ADMIT_TYPE , B.admit_term , A.appl_fee_status ,A.fin_aid_interest , A.housing_interest , A.notification_plan , A.region , A.last_sch_attend , A.graduation_dt , A.ACADEMIC_LEVEL , B.ACAD_PROG , B.PROG_STATUS , B.action_dt , B.prog_action , B.acad_load_appr , B.campus , B.exp_grad_term , B.prog_REASON , C.EVALUATN_STATUS FROM PS_ADM_APPL_DATA A , PS_ADM_APPL_PROG B , PS_ADM_APP_CAR_SEQ C , PS_SCRTY_APPL_CTR D WHERE D.ACCESS_CD = 'Y' AND A.INSTITUTION = D.INSTITUTION AND (D.ADM_APPL_CTR = A.ADM_APPL_CTR OR D.ADM_APPL_CTR = 'ALL') AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ADM_APPL_PROG WHERE B.EMPLID = EMPLID AND B.ACAD_CAREER = ACAD_CAREER AND B.STDNT_CAR_NBR = STDNT_CAR_NBR AND B.ADM_APPL_NBR = ADM_APPL_NBR AND B.APPL_PROG_NBR = APPL_PROG_NBR AND EFFDT <= %CurrentDateIn ) AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_ADM_APPL_PROG WHERE B.EMPLID = EMPLID AND B.ACAD_CAREER = ACAD_CAREER AND B.STDNT_CAR_NBR = STDNT_CAR_NBR AND B.ADM_APPL_NBR = ADM_APPL_NBR AND B.APPL_PROG_NBR = APPL_PROG_NBR AND B.EFFDT = EFFDT ) AND 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 B.EMPLID = C.EMPLID AND B.ACAD_CAREER = C.ACAD_CAREER AND B.STDNT_CAR_NBR = C.STDNT_CAR_NBR AND B.ADM_APPL_NBR = C.ADM_APPL_NBR AND B.APPL_PROG_NBR = C.APPL_PROG_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 4 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL | Application Nbr |
| 5 | 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 |
| 6 | ADM_APPL_DT | Date(10) | DATE | Application Date |
| 7 | ADMIT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Admit Type |
| 8 | ADMIT_TERM | Character(4) | VARCHAR2(4) NOT NULL | Admit Term |
| 9 | APPL_FEE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Application Fee Status
DEF=Deferred Payment PEN=Pending REC=Received WRQ=Waiver Request WVD=Waived |
| 10 | FIN_AID_INTEREST | Character(1) | VARCHAR2(1) NOT NULL | Financial Aid Interest |
| 11 | HOUSING_INTEREST | Character(1) | VARCHAR2(1) NOT NULL |
Housing Interest
C=Commuter F=Off Campus Housing H=On Campus Housing |
| 12 | NOTIFICATION_PLAN | Character(4) | VARCHAR2(4) NOT NULL |
Notification Plan
ERLY=Early Admission Decision REG=Regular Admission Decision ROLL=Rolling Admission |
| 13 | REGION | Character(10) | VARCHAR2(10) NOT NULL | Region |
| 14 | LAST_SCH_ATTEND | Character(11) | VARCHAR2(11) NOT NULL | Last School Attended |
| 15 | GRADUATION_DT | Date(10) | DATE | Graduation Date |
| 16 | ACADEMIC_LEVEL | Character(3) | VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set 01=First Year 02=Second Year 03=Third Year 04=Fourth Year 05=Fifth Year 06=Sixth Year 10=Freshman 20=Sophomore 30=Junior 40=Senior 50=Post-Bacc Undergraduate GR=Graduate GRA=Graduate AUS HON=Honours IE=Industrial Experience MAS=Masters P1=Professional Year 1 P2=Professional Year 2 P3=Professional Year 3 P4=Professional Year 4 PHD=PhD |
| 17 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 18 | 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 |
| 19 | ACTION_DT | Date(10) | DATE | Action Date |
| 20 | 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 |
| 21 | 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 |
| 22 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
| 23 | EXP_GRAD_TERM | Character(4) | VARCHAR2(4) NOT NULL | Expected Graduation Term |
| 24 | PROG_REASON | Character(4) | VARCHAR2(4) NOT NULL | Action Reason |
| 25 | EVALUATN_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Evaluation Status
CM=Complete IP=In Progress |