| # |
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_SYSTEM |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
|
| 6 |
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
|
| 7 |
SAD_UC_DEC_MAKER |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%EDITTABLE3
|
| 8 |
SAD_UC_DECISION_DT |
DateTime(26) |
TIMESTAMP NOT NULL |
Decision Date/Time
Default Value: %Datetime
|
| 9 |
SAD_UC_APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved
D=Approval Denied
N=Not Required
P=Awaiting Approval
Prompt Table:
SAD_UC_APRSTVW
|
| 10 |
SAD_UC_APPROVER |
Character(11) |
VARCHAR2(11) NOT NULL |
Approver
Prompt Table:
%EDITTABLE3
|
| 11 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Change
Prompt Table:
%EDITTABLE
|
| 12 |
SAD_UC_CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus Change
Prompt Table:
%EDITTABLE2
|
| 13 |
SAD_UC_ENTRYYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Entry Year Change
|
| 14 |
SAD_UC_ENTRYMONTH |
Number(2,0) |
SMALLINT NOT NULL |
Entry Month Change
|
| 15 |
SAD_UC_ENTRY_POINT |
Number(1,0) |
SMALLINT NOT NULL |
Entry Point Change
|
| 16 |
SAD_UC_MODULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Modular Change
N=No
Y=Yes
Prompt Table:
SAD_UC_MODULVW
|
| 17 |
SAD_UC_PARTTIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Part-Time Change
B=Both Full time and Part time
F=Full time Only
P=Part Time only
Prompt Table:
SAD_UC_PARTTMVW
|
| 18 |
SAD_UC_OFFER_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Offer Code
Prompt Table:
SAD_UC_STDOFFVW
|
| 19 |
SAD_UC_COMMENT |
Character(20) |
VARCHAR2(20) NOT NULL |
Comment
|
| 20 |
SAD_UC_FREE_FORMAT |
Long Character(592) |
VARCHAR2(592) |
Free Format
|
| 21 |
SAD_UC_LETTER_TEXT |
Long Character(2000) |
VARCHAR2(2000) |
Letter Text
|
| 22 |
SAD_UC_TRANSACT_CD |
Long Character(592) |
VARCHAR2(592) |
Transaction Code
|
| 23 |
SAD_UC_SOC |
Character(6) |
VARCHAR2(6) NOT NULL |
Summary of Conditions
|
| 24 |
SAD_UC_MAN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Matching Required
Y/N Table Edit
Default Value: N
|
| 25 |
SAD_UC_TRANS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Required
Y/N Table Edit
Default Value: Y
|
| 26 |
SAD_UC_FULF_COND |
Character(1) |
VARCHAR2(1) NOT NULL |
Results Matching
E=Not Evaluated
N=Not Satisfied
P=Partially Evaluated
Y=Satisfied
|
| 27 |
SAD_UC_REL_CLR |
Character(1) |
VARCHAR2(1) NOT NULL |
Release to Clearing
Y/N Table Edit
Default Value: N
|
| 28 |
SAD_UC_CNFRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmation Decision
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 29 |
SAD_UC_ABBREVCODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Abbreviation Code
Prompt Table:
SAD_UC_RELABBVW
|
| 30 |
SAD_UC_DATE |
Date(10) |
DATE |
Interview Date
|
| 31 |
SAD_UC_TIME |
Time(15) |
TIMESTAMP |
Interview Time
|
| 32 |
SAD_UC_DCR_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Delayed Confirmation Reason
Prompt Table:
SAD_UC_DCR_VW
|
| 33 |
SAD_UC_DC_ACTION |
Long Character(500) |
VARCHAR2(500) |
Delayed Confirmation Action
|