| # |
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_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_CHOICENO |
Number(3,0) |
SMALLINT NOT NULL |
Round 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 |
Institution Code
|
| 9 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
Course
|
| 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_PARTTIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Part Time
B=Both Full time and Part time
F=Full time Only
P=Part Time only
|
| 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_ENTRYYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Entry Year
|
| 18 |
SAD_UC_ENTRYMONTH |
Number(2,0) |
SMALLINT NOT NULL |
Entry Month
|
| 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
Prompt Table:
SAD_UC_DGSUB_VW
|
| 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_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)
|
| 34 |
SAD_UC_CRMREC_DECL |
Character(1) |
VARCHAR2(1) NOT NULL |
Criminal Records Declared
D=Declared
U=Undeclared
X=Not Presented
|
| 35 |
SAD_UC_DEGREETYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Highest Expected Qualification
Prompt Table:
SAD_UC_DGTYP_VW
|
| 36 |
SAD_UC_ACCR_PROV |
Character(3) |
VARCHAR2(3) NOT NULL |
Accrediting Provider
|
| 37 |
SAD_UC_APP_PHASE |
Character(30) |
VARCHAR2(30) NOT NULL |
Field for DFE API
|
| 38 |
SAD_UC_APP_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Status
Prompt Table:
SAD_UC_APST2_VW
|
| 39 |
SAD_UC_SYSTEM |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
|
| 40 |
SAD_UC_STUDY_MODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Study Mode
|
| 41 |
SAD_UC_REJECT_RSN |
Long Character(1330) |
VARCHAR2(1330) |
Field for DFE API
|
| 42 |
SAD_UC_REJECT_DT |
Date(10) |
DATE |
Field for DFE API
|
| 43 |
SAD_UC_RECRUIT_DT |
Date(10) |
DATE |
Recruited Date
|
| 44 |
SAD_UC_OFFER_DT |
Date(10) |
DATE |
Offer Date
|
| 45 |
SAD_UC_ACCEPT_DT |
Date(10) |
DATE |
Offer Accepted Date
|
| 46 |
SAD_UC_DECLINE_DT |
Date(10) |
DATE |
Offer Declined Date
|
| 47 |
SAD_UC_DEFER_DT |
Date(10) |
DATE |
Offer Deferred Date
|
| 48 |
SAD_UC_PREV_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
Status Before Deferral
|
| 49 |
SAD_UC_DEFER_CYCLE |
Number(4,0) |
SMALLINT NOT NULL |
Deferred To Cycle
|