SAD_UC_OTH_CHVW

(SQL View)
Index Back

other choices grid record


SELECT otch.INSTITUTION , otch.SAD_UC_PERS_ID , otch.SAD_UC_APPCODE , otch.SAD_UC_CHOICENO , otch.SAD_UC_INST , otch.SAD_UC_COURSE , otch.SAD_UC_CAMPUS , otch.SAD_UC_ENTRYYEAR , otch.SAD_UC_ENTRYMONTH , otch.SAD_UC_ENTRY_POINT , otch.SAD_UC_DECISION , otch.SAD_UC_REPLY , otch.SAD_UC_SUMMRY_COND FROM %Table(SAD_UC_OTH_CH) Otch UNION SELECT ch.INSTITUTION , ch.SAD_UC_PERS_ID , ch.SAD_UC_APPCODE , ch.SAD_UC_CHOICENO , ch.SAD_UC_INST , ch.SAD_UC_COURSE , ch.SAD_UC_CAMPUS , ch.SAD_UC_ENTRYYEAR , ch.SAD_UC_ENTRYMONTH , ch.SAD_UC_ENTRY_POINT , ch.SAD_UC_DECISION , ch.SAD_UC_REPLY , ch.SAD_UC_SUMMRY_COND FROM %Table(SAD_UC_IVSTARC) ch WHERE %EffdtCheck(SAD_UC_IVSTARC EFF1, ch,%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
3 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code
4 SAD_UC_CHOICENO Number(3,0) SMALLINT NOT NULL Choice Number
5 SAD_UC_INST Character(3) VARCHAR2(3) NOT NULL UCAS Institution Code
6 SAD_UC_COURSE Character(4) VARCHAR2(4) NOT NULL UCAS Course Code
7 SAD_UC_CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
8 SAD_UC_ENTRYYEAR Number(4,0) SMALLINT NOT NULL Entry Year
9 SAD_UC_ENTRYMONTH Number(2,0) SMALLINT NOT NULL Entry Month
10 SAD_UC_ENTRY_POINT Number(1,0) SMALLINT NOT NULL UCAS Entry Point
11 SAD_UC_DECISION Character(1) VARCHAR2(1) NOT NULL Decision
A=Accept
C=Conditional Offer
D=Delayed Confirmation
F=Full Course
I=Interview
N=None
R=Rejection
U=Unconditional Offer
W=Withdrawal
12 SAD_UC_REPLY Character(1) VARCHAR2(1) NOT NULL Reply
D=Declined
F=Firm Acceptance
I=Insurance Acceptance
13 SAD_UC_SUMMRY_COND Character(6) VARCHAR2(6) NOT NULL Summary Condition