SAD_UC_QSTRGVW(SQL View) |
Index Back |
---|---|
IvStarC Base RecordIvStarC 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 |