SAD_UC_STRGK_VW

(SQL View)
 Index Back

IvgStarG Base Record

IvgStarG Base Record

SELECT A.INSTITUTION , A.SAD_UC_APPCODE , A.SAD_UC_PERS_ID , G.SAD_UC_CHOICENO , G.EFFDT , G.SAD_UC_APP_STATUS , G.SAD_UC_INST , G.SAD_UC_COURSE , G.SAD_UC_STUDY_MODE , G.SAD_UC_APP_PHASE , G.SAD_UC_CAMPUS , G.SAD_UC_ENTRYYEAR , G.SAD_UC_ENTRYMONTH , G.ADM_APPL_NBR , G.SAD_UC_RBDDATE , K.SAD_UC_APPDATE , K.SAD_UC_WDRW_RSN , K.SAD_UC_WDRAWDATE , G.SAD_UC_REJECT_RSN , G.EMPLID , G.ACAD_CAREER , G.STDNT_CAR_NBR , G.SAD_UC_TIMESTAMP , G.SAD_UC_REJECT_DT , G.SAD_UC_OFFER_DT , G.SAD_UC_DECLINE_DT , G.SAD_UC_ACCEPT_DT , G.SAD_UC_RECRUIT_DT , K.SAD_UC_WITHDRAWN , K.SAD_UC_APP_URL , G.SAD_UC_DEFER_DT , G.SAD_UC_DEFER_CYCLE , G.SAD_UC_PREV_STATUS FROM PS_SAD_UC_APPLREC A LEFT OUTER JOIN PS_SAD_UC_IVSTARG G ON A.INSTITUTION = G.INSTITUTION AND A.SAD_UC_APPCODE = G.SAD_UC_APPCODE AND A.SAD_UC_PERS_ID = G.SAD_UC_PERS_ID AND G.SAD_UC_SYSTEM = 'APPL' LEFT OUTER JOIN PS_SAD_UC_IVGSTK K ON A.INSTITUTION = K.INSTITUTION AND A.SAD_UC_APPCODE = K.SAD_UC_APPCODE AND A.SAD_UC_PERS_ID = K.SAD_UC_PERS_ID AND K.SAD_UC_SYSTEM = 'APPL' WHERE A.SAD_UC_SYSTEM = 'APPL' AND A.SAD_UC_TIMESTAMP = ( SELECT MAX(A1.SAD_UC_TIMESTAMP) FROM PS_SAD_UC_APPLREC A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SAD_UC_APPCODE = A.SAD_UC_APPCODE AND A1.SAD_UC_PERS_ID = A.SAD_UC_PERS_ID AND A1.EMPLID = A.EMPLID AND A1.SAD_UC_SYSTEM = A.SAD_UC_SYSTEM) AND K.SAD_UC_TIMESTAMP = ( SELECT MAX(K1.SAD_UC_TIMESTAMP) FROM PS_SAD_UC_IVGSTK K1 WHERE K1.INSTITUTION = K.INSTITUTION AND K1.SAD_UC_APPCODE = K.SAD_UC_APPCODE AND K1.SAD_UC_PERS_ID = K.SAD_UC_PERS_ID AND K1.SAD_UC_SYSTEM = K.SAD_UC_SYSTEM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code
3 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
4 SAD_UC_CHOICENO Number(3,0) SMALLINT NOT NULL Choice Number
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 SAD_UC_APP_STATUS Character(30) VARCHAR2(30) NOT NULL Application Status
7 SAD_UC_INST Character(3) VARCHAR2(3) NOT NULL UCAS Institution Code
8 SAD_UC_COURSE Character(4) VARCHAR2(4) NOT NULL UCAS Course Code
9 SAD_UC_STUDY_MODE Character(10) VARCHAR2(10) NOT NULL Study Mode
10 SAD_UC_APP_PHASE Character(30) VARCHAR2(30) NOT NULL Field for DFE API
11 SAD_UC_CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
12 SAD_UC_ENTRYYEAR Number(4,0) SMALLINT NOT NULL Entry Year
13 SAD_UC_ENTRYMONTH Number(2,0) SMALLINT NOT NULL Entry Month
14 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
15 SAD_UC_RBDDATE Date(10) DATE RBD Date
16 SAD_UC_APPDATE Date(10) DATE Application Date
17 SAD_UC_WDRW_RSN Long Character(1330) VARCHAR2(1330) Field for DFE API
18 SAD_UC_WDRAWDATE Date(10) DATE Withdrawn Date
19 SAD_UC_REJECT_RSN Long Character(1330) VARCHAR2(1330) Field for DFE API
20 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
21 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
22 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
23 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
24 SAD_UC_REJECT_DT Date(10) DATE Field for DFE API
25 SAD_UC_OFFER_DT Date(10) DATE Offer Date
26 SAD_UC_DECLINE_DT Date(10) DATE Offer Declined Date
27 SAD_UC_ACCEPT_DT Date(10) DATE Offer Accepted Date
28 SAD_UC_RECRUIT_DT Date(10) DATE Recruited Date
29 SAD_UC_WITHDRAWN Character(1) VARCHAR2(1) NOT NULL Withdrawn
C=Candidate Withdrew
N=Not Withdrawn
R=Reinstated
W=UF Withdrawal
Y=Candidate Withdraw
30 SAD_UC_APP_URL Character(254) VARCHAR2(254) NOT NULL Application URL
31 SAD_UC_DEFER_DT Date(10) DATE Offer Deferred Date
32 SAD_UC_DEFER_CYCLE Number(4,0) SMALLINT NOT NULL Deferred To Cycle
33 SAD_UC_PREV_STATUS Character(30) VARCHAR2(30) NOT NULL Status Before Deferral