SAD_UC_QSTRGVW

(SQL View)
Index Back

IvStarC Base Record

IvStarC Base Record

SELECT scr.oprid , ch.institution , ch.sad_uc_appcode , ch.sad_uc_pers_id , ch.sad_uc_choiceno , ( SELECT MIN(ch1.effdt) FROM PS_SAD_UC_IVSTARG ch1 WHERE ch.institution = ch1.institution AND ch.sad_uc_appcode = ch1.sad_uc_appcode AND ch.sad_uc_pers_id = ch1.sad_uc_pers_id AND ch.sad_uc_choiceno = ch1.sad_uc_choiceno) sad_uc_date1 ,ch.sad_uc_course, ch.sad_uc_campus,ch.sad_uc_entryyear, ch.sad_uc_entrymonth, ch.sad_uc_GT_decision, ch.sad_uc_GT_reply, ch.emplid , b.last_name , b.first_name , ch.acad_career, ch.stdnt_car_nbr, ch.adm_appl_nbr ,decsn.sad_uc_decision , decsn.sad_uc_date , decsn.sad_uc_appr_status , apl.ADM_APPL_CTR FROM PS_SAD_UC_IVSTARG ch JOIN PS_PERSON_NAME B ON ch.emplid = b.emplid LEFT OUTER JOIN PS_SAD_UC_DECISN decsn ON ch.institution=decsn.institution AND ch.sad_uc_appcode=decsn.sad_uc_appcode AND ch.sad_uc_pers_id = decsn.sad_uc_pers_id AND ch.sad_uc_choiceno= decsn.sad_uc_choiceno LEFT OUTER JOIN PS_adm_appl_data apl ON ch.institution = apl.institution AND ch.emplid=apl.emplid AND ch.acad_career=apl.acad_career AND ch.stdnt_car_nbr=apl.stdnt_car_nbr AND ch.adm_appl_nbr = apl.adm_appl_nbr LEFT OUTER JOIN PS_scrty_appl_ctr scr ON apl.institution = scr.institution JOIN PS_SAD_UC_IVGSTK stk ON stk.institution= ch.institution AND stk.sad_uc_appcode= ch.saD_uc_appcode AND stk.sad_uc_pers_id = ch.sad_uc_pers_id WHERE %EffdtCheck(SAD_UC_IVSTARG EFF3, ch,%CurrentDateIn) AND ch.sad_uc_GT_decision <> 'W' AND stk.SAD_UC_WITHDRAWN NOT IN ('C','W') AND scr.access_cd = 'Y' AND ( apl.adm_appl_ctr = scr.adm_appl_ctr OR scr.adm_appl_ctr = 'ALL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code
4 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
5 SAD_UC_CHOICENO Number(3,0) SMALLINT NOT NULL Choice Number
6 SAD_UC_DATE1 Date(10) DATE Created Date
7 SAD_UC_COURSE Character(4) VARCHAR2(4) NOT NULL UCAS Course Code
8 SAD_UC_CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
9 SAD_UC_ENTRYYEAR Number(4,0) SMALLINT NOT NULL Entry Year
10 SAD_UC_ENTRYMONTH Number(2,0) SMALLINT NOT NULL Entry Month
11 SAD_UC_GT_DECISION Character(1) VARCHAR2(1) NOT NULL Decision
A=Accept
C=Conditional Offer
D=Delayed Conditional
E=Not qualified in English
G=Course Closed
I=Interview
M=Not qualified in Mathematics
N=None
R=Rejection
S=Not qualified in Science
U=Unconditional Offer
W=Withdrawal
12 SAD_UC_GT_REPLY Character(1) VARCHAR2(1) NOT NULL Reply
D=Declined
F=Firm Acceptance
13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
15 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
16 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
17 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
18 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
19 SAD_UC_DECISION1 Character(1) VARCHAR2(1) NOT NULL Institution Decision
20 SAD_UC_DATE Date(10) DATE Interview Date
21 SAD_UC_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
D=Approval Denied
N=Not Required
P=Awaiting Approval
22 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center