| # |
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 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 6 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 7 |
SAD_UC_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Timestamp
|
| 8 |
SAD_UC_LASTCHANGE |
DateTime(26) |
TIMESTAMP |
Last Change
|
| 9 |
SAD_UC_REFERRAL_DT |
DateTime(26) |
TIMESTAMP |
Referral Date
|
| 10 |
SAD_UC_INST |
Character(3) |
VARCHAR2(3) NOT NULL |
UCAS Institution Code
|
| 11 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS Course Code
|
| 12 |
SAD_UC_CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 13 |
SAD_UC_MODULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Modular
N=No
Y=Yes
|
| 14 |
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
|
| 15 |
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
|
| 16 |
SAD_UC_DECISION_DT |
DateTime(26) |
TIMESTAMP |
Decision Date/Time
|
| 17 |
SAD_UC_DECISIONNBR |
Number(2,0) |
SMALLINT NOT NULL |
Decision Number
|
| 18 |
SAD_UC_GT_REPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reply
D=Declined
F=Firm Acceptance
|
| 19 |
SAD_UC_ENTRYMONTH |
Number(2,0) |
SMALLINT NOT NULL |
Entry Month
|
| 20 |
SAD_UC_ENTRYYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Entry Year
|
| 21 |
SAD_UC_CHOICE_CNCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Choice Cancelled
Y/N Table Edit
|
| 22 |
SAD_UC_GT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Action
D=Decline by Default
R=Reject by Default
|
| 23 |
SAD_UC_RBDSTOP |
Character(1) |
VARCHAR2(1) NOT NULL |
RBD Stop
|
| 24 |
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
|
| 25 |
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
|
| 26 |
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
|
| 27 |
SAD_UC_DEGREESTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Degree Status
H=Has obtained a degree
T=Degree to be taken
|
| 28 |
SAD_UC_DEGREESUBJ |
Character(2) |
VARCHAR2(2) NOT NULL |
Degree Subject
|
| 29 |
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
|
| 30 |
SAD_UC_INTRVW_DATE |
DateTime(26) |
TIMESTAMP |
Interview Date/Time
|
| 31 |
SAD_UC_LATE_APPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Application
|
| 32 |
SAD_UC_RBDDATE |
Date(10) |
DATE |
RBD Date
|
| 33 |
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
|
| 34 |
SAD_UC_PREVRPLY_GT |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Reply
D=Declined
F=Firm Acceptance
|
| 35 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 36 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
|
| 37 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
|
| 38 |
ADM_APPL_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Application Nbr
|
| 39 |
SAD_UC_CRMREC_DECL |
Character(1) |
VARCHAR2(1) NOT NULL |
Criminal Records Declared
D=Declared
U=Undeclared
X=Not Presented
|
| 40 |
SAD_UC_CLRG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clearing Status
Y/N Table Edit
Default Value: N
|
| 41 |
SAD_UC_DEGREETYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Highest Expected Qualification
|
| 42 |
SAD_UC_ACCR_PROV |
Character(3) |
VARCHAR2(3) NOT NULL |
Accrediting Provider
|
| 43 |
SAD_UC_SYSTEM |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
|
| 44 |
SAD_UC_APP_PHASE |
Character(30) |
VARCHAR2(30) NOT NULL |
Field for DFE API
|
| 45 |
SAD_UC_APP_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Status
|
| 46 |
SAD_UC_STUDY_MODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Study Mode
|
| 47 |
SAD_UC_REJECT_RSN |
Long Character(1330) |
VARCHAR2(1330) |
Field for DFE API
|
| 48 |
SAD_UC_REJECT_DT |
Date(10) |
DATE |
Field for DFE API
|
| 49 |
SAD_UC_RECRUIT_DT |
Date(10) |
DATE |
Recruited Date
|
| 50 |
SAD_UC_OFFER_DT |
Date(10) |
DATE |
Offer Date
|
| 51 |
SAD_UC_ACCEPT_DT |
Date(10) |
DATE |
Offer Accepted Date
|
| 52 |
SAD_UC_DECLINE_DT |
Date(10) |
DATE |
Offer Declined Date
|
| 53 |
SAD_UC_APP_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Application status update
E=Error
N=No update required
U=Updated
|
| 54 |
SAD_UC_DEFER_DT |
Date(10) |
DATE |
Offer Deferred Date
|
| 55 |
SAD_UC_PREV_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
Status Before Deferral
|
| 56 |
SAD_UC_DEFER_CYCLE |
Number(4,0) |
SMALLINT NOT NULL |
Deferred To Cycle
|