| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 5 |
SAD_UC_EXP_TRN1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Transactions to UCAS
|
| 6 |
SAD_UC_EXP_TRN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Transactions to UTT
|
| 7 |
SAD_UC_GEN_TRN1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Transactions
|
| 8 |
SAD_UC_GEN_TRN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Transactions
|
| 9 |
SAD_UC_UPD_TRN1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Transactions from UCAS
|
| 10 |
SAD_UC_UPD_TRN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Transactions from UTT
|
| 11 |
SAD_UC_COUNT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count
|
| 12 |
SAD_UC_LINE_NO |
Number(15,0) |
DECIMAL(15) NOT NULL |
Line Number
|
| 13 |
SAD_UC_IMPORT_LIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Live
|
| 14 |
SAD_UC_UCAS |
Character(1) |
VARCHAR2(1) NOT NULL |
UCAS
N=No
Y=Yes
|
| 15 |
SAD_UC_GTTR |
Character(1) |
VARCHAR2(1) NOT NULL |
UTT
N=No
Y=Yes
|
| 16 |
SAD_UC_DB_LINK |
Character(30) |
VARCHAR2(30) NOT NULL |
UCAS Database Link
|
| 17 |
SAD_UC_SYSTEM |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
|
| 18 |
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
|
| 19 |
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
|
| 20 |
SAD_UC_PERS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Personalid - Unique personal identifier
|
| 21 |
SAD_UC_ROUNDNO |
Number(2,0) |
SMALLINT NOT NULL |
Round Number
|
| 22 |
SAD_UC_APPCODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Application Code
|
| 23 |
SAD_UC_CHOICENO |
Number(3,0) |
SMALLINT NOT NULL |
Choice Number
|
| 24 |
SAD_UC_CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 25 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS Course Code
|
| 26 |
SAD_UC_MODULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Modular
N=No
Y=Yes
|
| 27 |
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
|
| 28 |
SAD_UC_ENTRYMONTH |
Number(2,0) |
SMALLINT NOT NULL |
Entry Month
|
| 29 |
SAD_UC_ENTRYYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Entry Year
|
| 30 |
SAD_UC_ENTRY_POINT |
Number(1,0) |
SMALLINT NOT NULL |
UCAS Entry Point
|
| 31 |
SAD_UC_SOC |
Character(6) |
VARCHAR2(6) NOT NULL |
Summary of Conditions
|
| 32 |
SAD_UC_FREE_FORMAT |
Long Character(592) |
VARCHAR2(592) |
Free Format
|
| 33 |
SAD_UC_APPNO |
Number(9,0) |
DECIMAL(9) NOT NULL |
Application Number
|
| 34 |
SAD_UC_APPSCHCODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Code
|
| 35 |
CHOICENO |
Number(3,0) |
SMALLINT NOT NULL |
Choice No
|
| 36 |
ROUNDNO |
Number(3,0) |
SMALLINT NOT NULL |
Round No
|
| 37 |
SAD_UC_UCDCXML |
Character(1) |
VARCHAR2(1) NOT NULL |
Use XML for Decisions
|
| 38 |
SAD_UC_UCIDXML |
Character(100) |
VARCHAR2(100) NOT NULL |
XML-Link User ID
|
| 39 |
SAD_UC_UCPWXML |
Character(50) |
VARCHAR2(50) NOT NULL |
XML-Link Password
|
| 40 |
SAD_UC_DC_REASON |
Character(50) |
VARCHAR2(50) NOT NULL |
Delayed Confirmation Reason
|
| 41 |
SAD_UC_DC_ACTION |
Long Character(500) |
VARCHAR2(500) |
Delayed Confirmation Action
|