SAD_UC_I_IVGSTK

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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 ID
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_CODEDATE DateTime(26) TIMESTAMP Coded Change Date
8 SAD_UC_RESCAT Character(1) VARCHAR2(1) NOT NULL Residential Category Code
9 SAD_UC_FEEPAYER Character(2) VARCHAR2(2) NOT NULL Fee Payer Code
10 SAD_UC_APR Character(4) VARCHAR2(4) NOT NULL Area Of Permanent Residency
11 SAD_UC_CNTRYBIRTH Character(3) VARCHAR2(3) NOT NULL Country of Birth

Prompt Table: SAD_UC_CNTRY

12 SAD_UC_NATIONALITY Character(4) VARCHAR2(4) NOT NULL Nationality
13 SAD_UC_WITHDRAWN Character(1) VARCHAR2(1) NOT NULL Withdrawn
C=Candidate Withdrew
N=Not Withdrawn
R=Reinstated
W=UF Withdrawal
Y=Candidate Withdraw
14 SAD_UC_WDRAWDATE Date(10) DATE Withdrawn Date
15 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
16 SAD_UC_DIS Character(2) VARCHAR2(2) NOT NULL Disability Code

Prompt Table: SAD_UC_APDIS_VW

17 SAD_UC_UKENTRYDT Date(10) DATE UK Entry Date
18 SAD_UC_ROUNDNO Number(2,0) SMALLINT NOT NULL Round Number
19 SAD_UC_PREVROUND Number(2,0) SMALLINT NOT NULL Previous Round Number
20 SAD_UC_REFSTATUS Character(10) VARCHAR2(10) NOT NULL Status
21 SAD_UC_FIRMNOW Number(2,0) SMALLINT NOT NULL Firm Now
22 SAD_UC_EXTSTATUS Character(1) VARCHAR2(1) NOT NULL No longer used
0=Not in Extra
1=Eligible for Extra
2=Under Consideration
3=Accepted in Extra
23 SAD_UC_CLRGSTATUS Character(1) VARCHAR2(1) NOT NULL No longer used
0=Not in Clearing
1=Eligible for Clearing
2=Under Consideration
3=Accepted in Clearing
24 SAD_UC_CRB Character(1) VARCHAR2(1) NOT NULL Criminal Records Bureau
25 SAD_UC_CRIMALCONV Character(1) VARCHAR2(1) NOT NULL Criminal Conviction
N=No
U=Unknown
Y=Yes
26 SAD_UC_EARLY_STRT Date(10) DATE Earliest Start Date
27 SAD_UC_UNAVAIL_DT Character(250) VARCHAR2(250) NOT NULL Unavailable
28 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)
29 SAD_UC_SPECIALNEED Long Character(500) VARCHAR2(500) Special Needs
30 SAD_UC_ISA Character(20) VARCHAR2(20) NOT NULL ISA Reference Number
31 SAD_UC_TOEFL Character(16) VARCHAR2(16) NOT NULL TOEFL Reference Number
32 SAD_UC_IELTS Character(20) VARCHAR2(20) NOT NULL IELTS Reference Number
33 SAD_UC_PREF_FNAME Character(35) VARCHAR2(35) NOT NULL Preferred First Name
34 SAD_UC_PSPRTNBR Character(35) VARCHAR2(35) NOT NULL Passport Number
35 DT_ISSUED Date(10) DATE Issue Date
36 EXPIRATN_DT Date(10) DATE Expiration Date
37 SAD_UC_CITYPASSPRT Character(30) VARCHAR2(30) NOT NULL Place Issued
38 SAD_UC_VISA_RQRD Character(1) VARCHAR2(1) NOT NULL Student Visa Required
N=No
U=Unknown
Y=Yes

Y/N Table Edit

39 SAD_UC_ETHNIC Character(3) VARCHAR2(3) NOT NULL Ethnic Code

Prompt Table: SAD_UC_APETH_VW

40 SAD_UC_QTSTESTREG Character(1) VARCHAR2(1) NOT NULL QTS Test Registration
41 SAD_UC_QTSTESTNUM Character(10) VARCHAR2(10) NOT NULL QTS Test Registration Number
42 SAD_UC_LITERACYTDT Date(10) DATE Literacy Test Date
43 SAD_UC_NUMERACYTDT Date(10) DATE Numeracy Test Date
44 SAD_UC_SYSTEM Character(4) VARCHAR2(4) NOT NULL UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
45 SAD_UC_DLNATION Character(3) VARCHAR2(3) NOT NULL Dual Nationality
46 SAD_UC_WDRW_RSN Long Character(1330) VARCHAR2(1330) Field for DFE API
47 SAD_UC_RESIDENCY Long Character(1330) VARCHAR2(1330) Field for DFE API
48 SAD_UC_REJECT_RSN Long Character(1330) VARCHAR2(1330) Field for DFE API
49 SAD_UC_INTV_PREF Long Character CLOB Field for DFE API
50 SAD_UC_ENG_QUALS Long Character CLOB Field for DFE API
51 SAD_UC_OTHER_LANGS Long Character CLOB Field for DFE API
52 SAD_UC_DIS_DISCL Long Character CLOB Field for DFE API
53 SAD_UC_MISS_GCSES Long Character CLOB Field for DFE API
54 SAD_UC_WORK_EXPL Long Character(10240) CLOB Field for DFE API
55 SAD_UC_ENG_MAIN Character(1) VARCHAR2(1) NOT NULL Field for DFE API

Y/N Table Edit

56 SAD_UC_NATIONAL3 Character(2) VARCHAR2(2) NOT NULL Apply nationality field 3
57 SAD_UC_NATIONAL4 Character(2) VARCHAR2(2) NOT NULL Apply nationality field 4
58 SAD_UC_NATIONAL5 Character(2) VARCHAR2(2) NOT NULL Apply Nationality field 5
59 SAD_UC_DOM_CTY Character(2) VARCHAR2(2) NOT NULL Domicile country
60 SAD_UC_SAFEG_STS Character(60) VARCHAR2(60) NOT NULL Safeguarding status
61 SAD_UC_SAFEG_DTL Character(254) VARCHAR2(254) NOT NULL Safeguarding details
62 SAD_UC_DIS2 Character(2) VARCHAR2(2) NOT NULL Disability field

Prompt Table: SAD_UC_APDIS_VW

63 SAD_UC_DIS3 Character(2) VARCHAR2(2) NOT NULL Disability field

Prompt Table: SAD_UC_APDIS_VW

64 SAD_UC_DIS4 Character(2) VARCHAR2(2) NOT NULL Disability field

Prompt Table: SAD_UC_APDIS_VW

65 SAD_UC_DIS5 Character(2) VARCHAR2(2) NOT NULL Disability field

Prompt Table: SAD_UC_APDIS_VW

66 SAD_UC_DIS6 Character(2) VARCHAR2(2) NOT NULL Disability field

Prompt Table: SAD_UC_APDIS_VW

67 SAD_UC_DIS7 Character(2) VARCHAR2(2) NOT NULL Disability field

Prompt Table: SAD_UC_APDIS_VW

68 SAD_UC_DIS8 Character(2) VARCHAR2(2) NOT NULL Disability field

Prompt Table: SAD_UC_APDIS_VW

69 SAD_UC_DIS_OTH Long Character(1330) VARCHAR2(1330) Other Disability
70 SAD_UC_ETHNIC_OTH Long Character(1330) VARCHAR2(1330) Other Ethnicity
71 SAD_UC_APP_URL Character(254) VARCHAR2(254) NOT NULL Application URL