| # |
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 |
SAD_UC_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Timestamp
|
| 6 |
SAD_UC_LASTCHANGE |
DateTime(26) |
TIMESTAMP |
Last Change
|
| 7 |
SAD_UC_REFERRAL_DT |
DateTime(26) |
TIMESTAMP |
Referral Date
|
| 8 |
SAD_UC_INST |
Character(3) |
VARCHAR2(3) NOT NULL |
UCAS Institution Code
|
| 9 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS Course Code
|
| 10 |
SAD_UC_CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 11 |
SAD_UC_MODULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Modular
N=No
Y=Yes
|
| 12 |
SAD_UC_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Part Time
|
| 13 |
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
|
| 14 |
SAD_UC_DECISION_DT |
DateTime(26) |
TIMESTAMP |
Decision Date/Time
|
| 15 |
SAD_UC_DECISIONNBR |
Number(2,0) |
SMALLINT NOT NULL |
Decision Number
|
| 16 |
SAD_UC_GT_REPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reply
D=Declined
F=Firm Acceptance
|
| 17 |
SAD_UC_ENTRYMONTH |
Number(2,0) |
SMALLINT NOT NULL |
Entry Month
|
| 18 |
SAD_UC_ENTRYYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Entry Year
|
| 19 |
SAD_UC_CHOICE_CNCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Choice Cancelled
Y/N Table Edit
|
| 20 |
SAD_UC_GT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Action
D=Decline by Default
R=Reject by Default
|
| 21 |
SAD_UC_RBDSTOP |
Character(1) |
VARCHAR2(1) NOT NULL |
RBD Stop
|
| 22 |
SAD_UC_ENGLISH |
Character(1) |
VARCHAR2(1) NOT NULL |
GCSE English
1=Obtained GCSE or equivalent
2=Taking GCSE in the coming year
3=Wishes to take special test
9=Only applying for FE courses
|
| 23 |
SAD_UC_MATHS |
Character(1) |
VARCHAR2(1) NOT NULL |
GCSE Mathematics
1=Obtained GCSE or equivalent
2=Taking GCSE in the coming year
3=Wishes to take special test
9=Only applying for FE courses
|
| 24 |
SAD_UC_SCIENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Science
0=Not required
1=Obtained GCSE or equivalent
2=Taking GCSE in the coming year
3=Wishes to take special test
9=Only applying for FE courses
|
| 25 |
SAD_UC_DEGREESTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Degree Status
H=Has obtained a degree
T=Degree to be taken
|
| 26 |
SAD_UC_DEGREESUBJ |
Character(2) |
VARCHAR2(2) NOT NULL |
Degree Subject
|
| 27 |
SAD_UC_DEGREECLASS |
Character(2) |
VARCHAR2(2) NOT NULL |
Degree Class
1=1st Class Honours
21=2.1
22=2.2
3=3rd Class
O=Other
P=Pass
|
| 28 |
SAD_UC_INTRVW_DATE |
DateTime(26) |
TIMESTAMP |
Interview Date/Time
|
| 29 |
SAD_UC_LATE_APPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Application
|
| 30 |
SAD_UC_RBDDATE |
Date(10) |
DATE |
RBD Date
|
| 31 |
SAD_UC_PREVDCSN_GT |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Decision
A=Accept
C=Conditional Offer
D=Delayed Conditional
E=Not qualified in English
G=Course Closed
I=Interview
M=Not qualified in Mathematics
R=Rejection
S=Not qualified in Science
U=Unconditional Offer
W=Withdrawal
|
| 32 |
SAD_UC_PREVRPLY_GT |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Reply
D=Declined
F=Firm Acceptance
|
| 33 |
SAD_UC_CLRG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clearing Status
Y/N Table Edit
Default Value: N
|