| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 4 |
SAD_UC_IMPORT_LIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Live
Y/N Table Edit
Default Value: N
|
| 5 |
SAD_UC_IMP_APPL_U |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Applicants UCAS
Y/N Table Edit
Default Value: N
|
| 6 |
SAD_UC_IMP_APPL_G |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Applicants UTT
Y/N Table Edit
Default Value: N
|
| 7 |
SAD_UC_IMP_BIO_U |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Biographical Data UCAS
Y/N Table Edit
Default Value: N
|
| 8 |
SAD_UC_IMP_BIO_G |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Biographical Data UTT
Y/N Table Edit
Default Value: N
|
| 9 |
SAD_UC_IMP_EXAM_U |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Exam Results UCAS
Y/N Table Edit
Default Value: N
|
| 10 |
SAD_UC_IMP_CHOI_U |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Application Choice UCAS
Y/N Table Edit
Default Value: N
|
| 11 |
SAD_UC_IMP_CHOI_G |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Application Choices UTT
Y/N Table Edit
Default Value: N
|
| 12 |
SAD_UC_IMP_STRJ_U |
Character(1) |
VARCHAR2(1) NOT NULL |
Import HESA Data UCAS
Y/N Table Edit
Default Value: N
|
| 13 |
SAD_UC_IMP_STRJ_G |
Character(1) |
VARCHAR2(1) NOT NULL |
Import HESA Data UTT
Y/N Table Edit
Default Value: N
|
| 14 |
SAD_UC_PERS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Personalid - Unique personal identifier
|
| 15 |
SAD_UC_APPCODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Application Code
|
| 16 |
SAD_UC_IMP_APPL_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Applicants Apply
Y/N Table Edit
Default Value: N
|