ADM_MC_VW

(SQL View)
 Index Back

Adm Appl Prog Vw for MC

ADM_AP_PRG_VW is used for SQR processing.

SELECT c.emplid ,c.acad_career ,c.stdnt_car_nbr ,c.adm_appl_nbr ,c.appl_prog_nbr ,c.effdt ,c.effseq ,c.institution ,c.acad_prog ,c.prog_status ,c.prog_action ,c.action_dt ,c.prog_reason ,c.admit_term ,c.exp_grad_term ,c.req_term ,c.acad_load_appr ,c.campus ,a.adm_appl_ctr ,a.admit_type ,a.fin_aid_interest ,a.housing_interest ,a.appl_fee_status ,a.appl_fee_dt ,a.notification_plan ,a.region ,a.recruiter_id ,a.last_sch_attend ,a.adm_creation_dt ,a.adm_creation_by ,a.adm_updated_dt ,a.adm_updated_by ,a.adm_appl_complete ,a.adm_appl_cmplt_dt ,a.adm_appl_dt ,a.graduation_dt ,a.academic_level ,a.override_deposit ,a.ext_adm_appl_nbr from PS_ADM_APPL_DATA a, ps_adm_appl_prog c where a.emplid = c.emplid and a.acad_career = c.acad_career and a.stdnt_car_nbr = c.stdnt_car_nbr and a.adm_appl_nbr = c.adm_appl_nbr

# 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
3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

Default Value: 0

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

Default Value: 0

6 EFFDT Date(10) DATE Effective Date

Default Value: %date

7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Prompt Table: ACAD_PROG_TBL

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

Prompt Table: ADM_ACTION_TBL

12 ACTION_DT Date(10) DATE Action Date
13 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason

Prompt Table: PROG_RSN_TBL

14 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

Prompt Table: TERM_TBL

15 EXP_GRAD_TERM Character(4) VARCHAR2(4) NOT NULL Expected Graduation Term

Prompt Table: TERM_TBL

16 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term

Prompt Table: TERM_TBL

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

Prompt Table: CAMPUS_TBL

19 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center

Default Value: UG

Prompt Table: ADM_APPLCTR_TBL

20 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

Default Value: FYR

Prompt Table: ADMIT_TYPE_VW

21 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest

Y/N Table Edit

22 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing Interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing
23 APPL_FEE_STATUS Character(3) VARCHAR2(3) NOT NULL Application Fee Status
DEF=Deferred Payment
PEN=Pending
REC=Received
WRQ=Waiver Request
WVD=Waived
24 APPL_FEE_DT Date(10) DATE Application Fee Date
25 NOTIFICATION_PLAN Character(4) VARCHAR2(4) NOT NULL Notification Plan
ERLY=Early Admission Decision
REG=Regular Admission Decision
ROLL=Rolling Admission
26 REGION Character(10) VARCHAR2(10) NOT NULL Region

Prompt Table: REGION_TBL

27 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID

Prompt Table: RECRUITER_SRCH

28 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last School Attended

Prompt Table: SCHOOL_TBL

29 ADM_CREATION_DT Date(10) DATE Admission Data Creation Date
30 ADM_CREATION_BY Character(30) VARCHAR2(30) NOT NULL Admission Data Created By
31 ADM_UPDATED_DT Date(10) DATE Last Updated On
32 ADM_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL Last Updated By
33 ADM_APPL_COMPLETE Character(1) VARCHAR2(1) NOT NULL Application Complete

Y/N Table Edit

34 ADM_APPL_CMPLT_DT Date(10) DATE Completed Date
35 ADM_APPL_DT Date(10) DATE Application Date
36 GRADUATION_DT Date(10) DATE Graduation Date
37 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
38 OVERRIDE_DEPOSIT Character(1) VARCHAR2(1) NOT NULL Override Deposit
39 EXT_ADM_APPL_NBR Character(15) VARCHAR2(15) NOT NULL External Application Nbr