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 | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Personalid - Unique personal identifier | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Application Code | |
4 | 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 |