| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 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 Code
|
| 4 |
SAD_UC_CHOICENO |
Number(3,0) |
SMALLINT NOT NULL |
Choice Number
|
| 5 |
SAD_UC_LINE_NO |
Number(15,0) |
DECIMAL(15) NOT NULL |
Line Number
Default Value: 1
|
| 6 |
SAD_UC_TRAN_ID |
Number(8,0) |
INTEGER NOT NULL |
Transaction ID
Default Value: 0
|
| 7 |
SAD_UC_CREATION_DT |
DateTime(26) |
TIMESTAMP NOT NULL |
Created Date
Default Value: %DateTime
|
| 8 |
SAD_UC_SYSTEM |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
|
| 9 |
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:
%EDITTABLE3
|
| 10 |
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
|
| 11 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
Course
Prompt Table:
%EDITTABLE
|
| 12 |
SAD_UC_CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
Prompt Table:
%EDITTABLE2
|
| 13 |
SAD_UC_MODULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Modular
N=No
Y=Yes
Prompt Table:
SAD_UC_MODULVW
|
| 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
Prompt Table:
SAD_UC_PARTTMVW
|
| 15 |
SAD_UC_ENTRYYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Entry Year
|
| 16 |
SAD_UC_ENTRYMONTH |
Number(2,0) |
SMALLINT NOT NULL |
Entry Month
|
| 17 |
SAD_UC_ENTRY_POINT |
Number(1,0) |
SMALLINT NOT NULL |
UCAS Entry Point
|
| 18 |
SAD_UC_SOC |
Character(6) |
VARCHAR2(6) NOT NULL |
Summary of Conditions
|
| 19 |
SAD_UC_FREE_FORMAT |
Long Character(592) |
VARCHAR2(592) |
Transaction Code
Default Value: SAD_UC_DECISN.SAD_UC_TRANSACT_CD
|
| 20 |
SAD_UC_ERROR_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Error Code
Default Value: -1
|
| 21 |
SAD_UC_RETURN1 |
Number(5,0) |
INTEGER NOT NULL |
Error Position
|
| 22 |
SAD_UC_AUTO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto
Y/N Table Edit
Default Value: N
|
| 23 |
SAD_UC_HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
Y/N Table Edit
Default Value: N
|
| 24 |
SAD_UC_SENT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sent
Y/N Table Edit
Default Value: N
|
| 25 |
SAD_UC_OBSOLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Obsolete
Y/N Table Edit
Default Value: N
|
| 26 |
SAD_UC_ERRORMSG |
Character(250) |
VARCHAR2(250) NOT NULL |
Error message
|
| 27 |
SAD_UC_DC_REASON |
Character(50) |
VARCHAR2(50) NOT NULL |
Delayed Confirmation Reason
|
| 28 |
SAD_UC_DC_ACTION |
Long Character(500) |
VARCHAR2(500) |
Delayed Confirmation Action
|