| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 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_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Timestamp
|
| 5 |
SAD_UC_APPDATE |
Date(10) |
DATE |
Application Date
|
| 6 |
SAD_UC_DTINTOPAZ |
DateTime(26) |
TIMESTAMP |
Date Into Topaz
|
| 7 |
SAD_UC_LATEAPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Application
|
| 8 |
SAD_UC_RUNSENT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Run Number When Sent
|
| 9 |
SAD_UC_CODEDATE |
DateTime(26) |
TIMESTAMP |
Coded Change Date
|
| 10 |
SAD_UC_SCHOOL |
Character(10) |
VARCHAR2(10) NOT NULL |
UCAS School
Prompt Table:
SAD_UC_SCHOOLVW
|
| 11 |
SAD_UC_RESCAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Residential Category Code
Prompt Table:
SAD_UC_RESCAT
|
| 12 |
SAD_UC_FEELEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Fee Level
F=Full Fee
M=Multiple Fee
S=Single Entry Fee
|
| 13 |
SAD_UC_FEEPAYER |
Character(2) |
VARCHAR2(2) NOT NULL |
Fee Payer Code
Prompt Table:
SAD_UC_FEE
|
| 14 |
SAD_UC_APR |
Character(4) |
VARCHAR2(4) NOT NULL |
Area Of Permanent Residency
|
| 15 |
SAD_UC_CNTRYBIRTH |
Character(3) |
VARCHAR2(3) NOT NULL |
Country of Birth
Prompt Table:
SAD_UC_CNTRY
|
| 16 |
SAD_UC_NATIONALITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Nationality
Prompt Table:
SAD_UC_NATION
|
| 17 |
SAD_UC_DLNATION |
Character(3) |
VARCHAR2(3) NOT NULL |
Dual Nationality
Prompt Table:
SAD_UC_NATION
|
| 18 |
SAD_UC_WITHDRAWN |
Character(1) |
VARCHAR2(1) NOT NULL |
Withdrawn
C=Candidate Withdrew
N=Not Withdrawn
R=Reinstated
W=UF Withdrawal
Y=Candidate Withdraw
|
| 19 |
SAD_UC_WDRAWDATE |
Date(10) |
DATE |
Withdrawn Date
|
| 20 |
SAD_UC_ROUTEB |
Character(1) |
VARCHAR2(1) NOT NULL |
Route B
|
| 21 |
SAD_UC_EXAMCHGDT |
DateTime(26) |
TIMESTAMP |
Exam Change Date
|
| 22 |
SAD_UC_GCE |
Number(3,0) |
SMALLINT NOT NULL |
GCE Expected
|
| 23 |
SAD_UC_VCE |
Number(1,0) |
SMALLINT NOT NULL |
VCE Expected
|
| 24 |
SAD_UC_SQA |
Character(1) |
VARCHAR2(1) NOT NULL |
SQA Candidate
0=SQA Not Expected
1=This Year
2=Previous Year
3=Both
|
| 25 |
SAD_UC_WINTERA |
Number(3,0) |
SMALLINT NOT NULL |
Winter A Levels
|
| 26 |
SAD_UC_PREVIOUSA |
Number(3,0) |
SMALLINT NOT NULL |
Previous A Levels
|
| 27 |
SAD_UC_PREVIOUSAS |
Number(3,0) |
SMALLINT NOT NULL |
Previous AS Levels
|
| 28 |
SAD_UC_KEYSKILLS |
Character(1) |
VARCHAR2(1) NOT NULL |
Key Skills
|
| 29 |
SAD_UC_VOCATIONAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Vocational
0=No Vocational Exams
1=Higher BTEC
2=Lower BTEC
3=Foundation and Design Course
4=BTEC National Award
5=BTEC Certificate
6=BTEC Award
7=OCR National Extended Diploma
C=OCR National Certificate
D=OCR National Diploma
E=OCR National Extended Diploma
P=iPRO
S=SII Level 3 Certificate
V=ASDAN Level 3 Award
|
| 30 |
SAD_UC_BTEC |
Character(1) |
VARCHAR2(1) NOT NULL |
BTEC
|
| 31 |
SAD_UC_ILC |
Character(1) |
VARCHAR2(1) NOT NULL |
Irish Leaving Certificate
|
| 32 |
SAD_UC_AICE |
Character(1) |
VARCHAR2(1) NOT NULL |
AICE Indicator
|
| 33 |
SAD_UC_IB |
Character(1) |
VARCHAR2(1) NOT NULL |
International Baccalaurette
|
| 34 |
SAD_UC_MANUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Investigation Required
|
| 35 |
SAD_UC_REGNO |
Character(7) |
VARCHAR2(7) NOT NULL |
BTEC Registration Number
|
| 36 |
SAD_UC_SCN |
Character(9) |
VARCHAR2(9) NOT NULL |
Scottish Candidate Number
|
| 37 |
SAD_UC_OEQ |
Character(10) |
VARCHAR2(10) NOT NULL |
OEQ Code
|
| 38 |
SAD_UC_PREVOEQ |
Character(10) |
VARCHAR2(10) NOT NULL |
Previous Other Exam Qual
|
| 39 |
SAD_UC_OQ1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Qualifications 1
A=Cache
S=CFSP
|
| 40 |
SAD_UC_OQ2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Qualifications 2
M=Music
|
| 41 |
SAD_UC_EAS |
Character(1) |
VARCHAR2(1) NOT NULL |
EAS
A=Applied through Apply
D=Deferred Applicant
E=Applied through EAS
I=International Apply
O=OPF
P=Paper Application
R=RPA
S=School Apply
T=International Independent Appl
U=UK Home Apply
|
| 42 |
SAD_UC_ROA |
Character(1) |
VARCHAR2(1) NOT NULL |
ROA
|
| 43 |
SAD_UC_DIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Disability Code
Prompt Table:
SAD_UC_DIS
|
| 44 |
SAD_UC_CRIMALCONV |
Character(1) |
VARCHAR2(1) NOT NULL |
Criminal Conviction
N=No
U=Unknown
Y=Yes
|
| 45 |
SAD_UC_UKENTRYDT |
Date(10) |
DATE |
UK Entry Date
|
| 46 |
SAD_UC_REFSTATUS |
Character(10) |
VARCHAR2(10) NOT NULL |
Status
|
| 47 |
SAD_UC_FIRMNOW |
Number(2,0) |
SMALLINT NOT NULL |
Firm Now
|
| 48 |
SAD_UC_INSREPLY |
Number(1,0) |
SMALLINT NOT NULL |
Insurance Reply
|
| 49 |
SAD_UC_CHOICTRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Choices All Transparent
|
| 50 |
SAD_UC_EXTSTATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Extra Status
0=Not in Extra
1=Eligible for Extra
2=Under Consideration
3=Accepted in Extra
|
| 51 |
SAD_UC_NATIONALID |
Character(1) |
VARCHAR2(1) NOT NULL |
National Identity 1
B=British
E=English
I=Irish
O=Other
R=Information Refused
S=Scottish
U=Unknown
W=Welsh
X=Not Applicable
|
| 52 |
SAD_UC_NATIONALID2 |
Character(1) |
VARCHAR2(1) NOT NULL |
National Identity 2
B=British
E=English
I=Irish
O=Other
R=Information Refused
S=Scottish
U=Unknown
W=Welsh
X=Not Applicable
|
| 53 |
SAD_UC_SUPTARRANGE |
Character(50) |
VARCHAR2(50) NOT NULL |
Support Arrangements
|
| 54 |
SAD_UC_UNAVAIL_DT |
Character(250) |
VARCHAR2(250) NOT NULL |
Unavailable
|
| 55 |
SAD_UC_CARE |
Character(10) |
VARCHAR2(10) NOT NULL |
Care Code
Prompt Table:
SAD_UC_CARE
|
| 56 |
SAD_UC_CAREDUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Care Duration
Prompt Table:
SAD_UC_CAREDUR
|
| 57 |
SAD_UC_LASTSCHATTD |
Character(10) |
VARCHAR2(10) NOT NULL |
Last School Attended
Prompt Table:
SAD_UC_SCHOOLVW
|
| 58 |
SAD_UC_PARENTINHE |
Character(10) |
VARCHAR2(10) NOT NULL |
Parent in HE
Prompt Table:
SAD_UC_PARHE
|
| 59 |
SAD_UC_IMP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Status
E=Error (E)
I=Imported (I)
N=New (N)
P=Pending (P)
R=Pending (R)
T=Error (T)
|
| 60 |
SAD_UC_SPECIALNEED |
Long Character(500) |
VARCHAR2(500) |
Special Needs
|
| 61 |
SAD_UC_ADJ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Status
E=Adjustment period has Expired
L=Eligible for Adjustment
P=Placed through Adjustment
R=Registered for Adjustment
|
| 62 |
SAD_UC_ADJ_REG_DT |
Date(10) |
DATE |
Registration Date
|
| 63 |
SAD_UC_ADJ_EXP_DT |
Date(10) |
DATE |
Expiry Date
|
| 64 |
SAD_UC_NIN |
Character(9) |
VARCHAR2(9) NOT NULL |
National Insurance Number
|
| 65 |
SAD_UC_NMCPIN |
Character(8) |
VARCHAR2(8) NOT NULL |
Nursing & Midwifery PIN Number
|
| 66 |
SAD_UC_ISA |
Character(20) |
VARCHAR2(20) NOT NULL |
ISA Reference Number
|
| 67 |
SAD_UC_TOEFL |
Character(16) |
VARCHAR2(16) NOT NULL |
TOEFL Reference Number
|
| 68 |
SAD_UC_IELTS |
Character(20) |
VARCHAR2(20) NOT NULL |
IELTS Reference Number
|
| 69 |
SAD_UC_PREF_FNAME |
Character(35) |
VARCHAR2(35) NOT NULL |
Preferred First Name
|
| 70 |
SAD_UC_PSPRTNBR |
Character(35) |
VARCHAR2(35) NOT NULL |
Passport Number
|
| 71 |
DT_ISSUED |
Date(10) |
DATE |
Issue Date
|
| 72 |
EXPIRATN_DT |
Date(10) |
DATE |
Expiration Date
|
| 73 |
SAD_UC_CITYPASSPRT |
Character(30) |
VARCHAR2(30) NOT NULL |
Place Issued
|
| 74 |
SAD_UC_VISA_RQRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Visa Required
N=No
U=Unknown
Y=Yes
|
| 75 |
SAD_UC_DIPLOMA |
Character(1) |
VARCHAR2(1) NOT NULL |
Diploma
1=Taking Progression Diploma
2=Taking Advanced Diploma
3=Taking Extended Diploma
|
| 76 |
SAD_UC_PREU |
Character(1) |
VARCHAR2(1) NOT NULL |
Cambridge PreU
1=Taking Pre-U Certificate
2=Taking Pre-U Diploma
|
| 77 |
SAD_UC_PRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Principal Learning
1=Taking Principal Learning
|
| 78 |
SAD_UC_EXP_QUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Expected Qual Level
B=Below degree level
D=Degree level or above
N=No formal qualifications
|
| 79 |
SAD_UC_EXP_QUAL3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Expected Qual Code
Prompt Table:
SAD_UC_QUALCDVW
|
| 80 |
SAD_UC_ATT_QUAL3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Attained Qual Code
Prompt Table:
SAD_UC_QUALCDVW
|
| 81 |
SAD_UC_POLAR2 |
Number(1,0) |
SMALLINT NOT NULL |
Polar2
|
| 82 |
SAD_UC_WRK_LIVE_EU |
Character(1) |
VARCHAR2(1) NOT NULL |
Worked/Lived in EU
D=Don't know
N=No
P=Prefer not to say
Y=Yes
|
| 83 |
SAD_UC_PAR_SPSE_EU |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent/Spouse EU National
D=Don't know
N=No
P=Prefer not to say
Y=Yes
|
| 84 |
SAD_UC_VISASTUDY |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Visa Study
N=No
Y=Yes
|
| 85 |
SAD_UC_SMD_INDEX |
Number(1,0) |
SMALLINT NOT NULL |
SMD Index
|
| 86 |
SAD_UC_POLAR3 |
Number(1,0) |
SMALLINT NOT NULL |
Polar3
|
| 87 |
SAD_UC_WCF |
Number(1,0) |
SMALLINT NOT NULL |
Wales Communities First
|
| 88 |
SAD_UC_POLAR4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Polar4
|
| 89 |
SAD_UC_SETTLED |
Character(2) |
VARCHAR2(2) NOT NULL |
Settled or Pre-Settled
N=No
Y=Yes
|
| 90 |
SAD_UC_PSTDY_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Previous Study Level
Prompt Table:
SAD_UC_PRVSTLVL
|
| 91 |
SAD_UC_PSTDY_START |
Date(10) |
DATE |
Previous Study Start Date
|
| 92 |
SAD_UC_PSTDY_END |
Date(10) |
DATE |
Previous Study End Date
|
| 93 |
SAD_UC_NOVISA_OTH |
Character(150) |
VARCHAR2(150) NOT NULL |
Other No Visa Reason
|
| 94 |
SAD_UC_NOVISA_RSN |
Character(3) |
VARCHAR2(3) NOT NULL |
No Visa Reason
Prompt Table:
SAD_UC_NOVISRSN
|
| 95 |
SAD_UC_SETT_EXP_DT |
Date(10) |
DATE |
Settled Expiry Date
|
| 96 |
SAD_UC_VISA_STS |
Character(3) |
VARCHAR2(3) NOT NULL |
Visa/Immigration Status
Prompt Table:
SAD_UC_VISIMGST
|
| 97 |
SAD_UC_VISA_OT_STS |
Character(150) |
VARCHAR2(150) NOT NULL |
Other Visa Status
|
| 98 |
SAD_UC_VISA_START |
Date(10) |
DATE |
Visa Start Date
|
| 99 |
SAD_UC_VISA_END |
Date(10) |
DATE |
Visa End Date
|