| # |
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_INST |
Character(3) |
VARCHAR2(3) NOT NULL |
UCAS Institution Code
|
| 6 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS Course Code
|
| 7 |
SAD_UC_CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 8 |
SAD_UC_ENTRYYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Entry Year
|
| 9 |
SAD_UC_ENTRYMONTH |
Number(2,0) |
SMALLINT NOT NULL |
Entry Month
|
| 10 |
SAD_UC_MODULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Modular
N=No
Y=Yes
|
| 11 |
SAD_UC_TIMESTAMP |
DateTime(26) |
TIMESTAMP NOT NULL |
Timestamp
|
| 12 |
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
|
| 13 |
SAD_UC_VACSTATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Vacancy Status
B=Vacancies Full and Part time
F=Vacancies for Full time
P=Vacancies for Part Time
|
| 14 |
SAD_UC_LONGNAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Long Name
|
| 15 |
SAD_UC_CRSECANC |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Cancelled
|
| 16 |
SAD_UC_CANCDATE |
DateTime(26) |
TIMESTAMP |
Course Cancelled Date
|
| 17 |
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
|
| 18 |
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
|
| 19 |
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
|
| 20 |
SAD_UC_AGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Age Range of Children
M=Middle
P=Primary
S=Secondary
|
| 21 |
SAD_UC_STATUS |
Character(20) |
VARCHAR2(20) NOT NULL |
Status
|
| 22 |
SAD_UC_CRIMCHK_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Criminal Check Required
|