| # |
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_CLEARING_ID |
Number(9,0) |
DECIMAL(9) NOT NULL |
Enquiry ID
|
| 3 |
SAD_UC_ADJ_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment
Y/N Table Edit
Default Value: Y
|
| 4 |
SAD_UC_SYSTEM |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
|
| 5 |
SAD_UC_APPYEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS Admissions Cycle
Default Value: SAD_UC_CONFIG.SAD_UC_CYCLE
|
| 6 |
PERSONALID |
Character(10) |
VARCHAR2(10) NOT NULL |
Personal ID
|
| 7 |
APPNO |
Character(9) |
VARCHAR2(9) NOT NULL |
Application Code
|
| 8 |
SAD_UC_PREFIXTITLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Prefix Title
|
| 9 |
SAD_UC_SURNAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Surname
|
| 10 |
SAD_UC_FORENAMES |
Character(60) |
VARCHAR2(60) NOT NULL |
Forenames
|
| 11 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 12 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 13 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS Course Code
Prompt Table:
%EDITTABLE
|
| 14 |
SAD_UC_CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
UCAS Campus
Prompt Table:
%EDITTABLE2
|
| 15 |
SAD_UC_ENTRYYEAR |
Number(4,0) |
SMALLINT NOT NULL |
UCAS Entry Year
|
| 16 |
SAD_UC_ENTRYMONTH |
Number(2,0) |
SMALLINT NOT NULL |
UCAS Entry Month
|
| 17 |
SAD_UC_ENTRY_POINT |
Number(1,0) |
SMALLINT NOT NULL |
UCAS Entry Point
|
| 18 |
SAD_UC_CEFNO |
Number(6,0) |
INTEGER NOT NULL |
CEF Number
|
| 19 |
SAD_UC_MODULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Modular
N=No
Y=Yes
Y/N Table Edit
|
| 20 |
SAD_UC_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Part Time
Prompt Table:
SAD_UC_PARTTMVW
|
| 21 |
SAD_UC_FREE_FORMAT |
Long Character(592) |
VARCHAR2(592) |
Free Format
|
| 22 |
SAD_UC_TRAN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Type
AD=Adjustment Offer
AD=Adjustment Offer
LA=Amended Decision
LC=Course Correction
LD=Decision
PE=Enquiry
RA=UF Amendment
RD=Confirmation Decision
RQ=Clearing Form Request
RR=Release Into Clearing
RW=UF Withdrawal
RX=Clearing Decision
Prompt Table:
SAD_UC_CLRTRNVW
|
| 23 |
SAD_UC_DECISION |
Character(1) |
VARCHAR2(1) NOT NULL |
Decision
A=Accept
C=Conditional Offer
D=Delayed Confirmation
F=Full Course
I=Interview
N=None
R=Rejection
U=Unconditional Offer
W=Withdrawal
Prompt Table:
SAD_UC_DECSNVW
|
| 24 |
SAD_UC_DEC_MAKER |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%EDITTABLE3
|
| 25 |
SAD_UC_DECISION_DT |
DateTime(26) |
TIMESTAMP |
Decision Date/Time
|
| 26 |
SAD_UC_TRANS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Required
Y/N Table Edit
|
| 27 |
SAD_UC_ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 1
|
| 28 |
SAD_UC_ADDRESS2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Address Line 2
|
| 29 |
SAD_UC_ADDRESS3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Address Line 3
|
| 30 |
SAD_UC_ADDRESS4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Address Line 4
|
| 31 |
SAD_UC_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
Prompt Table:
SAD_UC_CNTRY_VW
|
| 32 |
SAD_UC_POSTCODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Postcode
|
| 33 |
SAD_UC_TELEPHONE1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Telephone Number
|
| 34 |
SAD_UC_EMAILID |
Character(100) |
VARCHAR2(100) NOT NULL |
Email ID
|
| 35 |
SAD_UC_NOTES |
Long Character(2000) |
VARCHAR2(2000) |
Notes
|