PROCESS_INSTANCEN=No
Y=Yes
N=No
Y=Yes
Y/N Table Edit
Y/N Table Edit
Default Value: N
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
SAD_UC_APPL_AET(SQL Table) |
Index Back |
|---|
| # | 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_APPCODE | Character(10) | VARCHAR2(10) NOT NULL | Application Code |
| 6 | SAD_UC_PERS_ID | Character(10) | VARCHAR2(10) NOT NULL | Personalid - Unique personal identifier |
| 7 | SAD_UC_IMPORT_LIVE | Character(1) | VARCHAR2(1) NOT NULL | Import Live |
| 8 | SAD_UC_IMP_APPL_U | Character(1) | VARCHAR2(1) NOT NULL | Import Applicants UCAS |
| 9 | SAD_UC_IMP_APPL_G | Character(1) | VARCHAR2(1) NOT NULL | Import Applicants UTT |
| 10 | SAD_UC_IMP_BIO_U | Character(1) | VARCHAR2(1) NOT NULL | Import Biographical Data UCAS |
| 11 | SAD_UC_IMP_BIO_G | Character(1) | VARCHAR2(1) NOT NULL | Import Biographical Data UTT |
| 12 | SAD_UC_IMP_EXAM_U | Character(1) | VARCHAR2(1) NOT NULL | Import Exam Results UCAS |
| 13 | SAD_UC_IMP_CHOI_U | Character(1) | VARCHAR2(1) NOT NULL | Import Application Choice UCAS |
| 14 | SAD_UC_IMP_CHOI_G | Character(1) | VARCHAR2(1) NOT NULL | Import Application Choices UTT |
| 15 | SAD_UC_NEW_RECORDS | Number(15,0) | DECIMAL(15) NOT NULL | Records Added |
| 16 | SAD_UC_AMENDEDRECS | Number(15,0) | DECIMAL(15) NOT NULL | Records Amended |
| 17 | SAD_UC_INST | Character(3) | VARCHAR2(3) NOT NULL | UCAS Institution Code |
| 18 | SAD_UC_UCAS | Character(1) | VARCHAR2(1) NOT NULL |
UCAS
N=No Y=Yes |
| 19 | SAD_UC_GTTR | Character(1) | VARCHAR2(1) NOT NULL |
UTT
N=No Y=Yes |
| 20 | SAD_UC_MATR_UPDATE | Character(1) | VARCHAR2(1) NOT NULL | Update Matriculated Students |
| 21 | SAD_UC_VIEW | Character(4) | VARCHAR2(4) NOT NULL | UCAS View |
| 22 | SAD_UC_TIMESTAMP | DateTime(26) | TIMESTAMP | Timestamp |
| 23 | SAD_UC_OVERTIMESTP | DateTime(26) | TIMESTAMP | Override Timestamp |
| 24 | SAD_UC_DB_LINK | Character(30) | VARCHAR2(30) NOT NULL | UCAS Database Link |
| 25 | SAD_UC_COUNT | Number(15,0) | DECIMAL(15) NOT NULL | Count |
| 26 | SAD_UC_DELRECSCNT | Number(15,0) | DECIMAL(15) NOT NULL | Deleted Records |
| 27 | SAD_UC_SUBJID | Character(10) | VARCHAR2(10) NOT NULL | Subject ID |
| 28 | SAD_UC_UNITID | Number(10,0) | DECIMAL(10) NOT NULL | Unit ID |
| 29 | SAD_UC_IVEDUCDT | DateTime(26) | TIMESTAMP | IVEDUC Internal Timestamp |
| 30 | SAD_UC_IVEMPLDT | DateTime(26) | TIMESTAMP | IVEMPL Internal Timestamp |
| 31 | SAD_UC_IVFMQDT | DateTime(26) | TIMESTAMP | IVFMQ Internal Timestamp |
| 32 | SAD_UC_IVOFFERDT | DateTime(26) | TIMESTAMP | ivOffer Timestamp |
| 33 | SAD_UC_IVPQRDT | DateTime(26) | TIMESTAMP | IVPQR Internal Timestamp |
| 34 | SAD_UC_IVPREPDT | DateTime(26) | TIMESTAMP | IVPREP Internal Timestamp |
| 35 | SAD_UC_IVQUALDT | DateTime(26) | TIMESTAMP | IVQUAL Internal Timestamp |
| 36 | SAD_UC_IVREFDT | DateTime(26) | TIMESTAMP | ivReference Timestamp |
| 37 | SAD_UC_IVSTARADT | DateTime(26) | TIMESTAMP | IVSTARA Internal Timestamp |
| 38 | SAD_UC_IVSTARCDT | DateTime(26) | TIMESTAMP | IVStarC Timestamp |
| 39 | SAD_UC_IVSTARHDT | DateTime(26) | TIMESTAMP | IVSTARH Internal Timestamp |
| 40 | SAD_UC_IVSTARKDT | DateTime(26) | TIMESTAMP | IVSTARK Internal Timestamp |
| 41 | SAD_UC_IVSTARNDT | DateTime(26) | TIMESTAMP | IVSTARN Internal Timestamp |
| 42 | SAD_UC_IVSTARWDT | DateTime(26) | TIMESTAMP | IVSTARW Internal Timestamp |
| 43 | SAD_UC_IVSTARXDT | DateTime(26) | TIMESTAMP | IVSTARX Internal Timestamp |
| 44 | SAD_UC_IVSTMNTDT | DateTime(26) | TIMESTAMP | ivStatement Timestamp |
| 45 | SAD_UC_IVUNRSDT | DateTime(26) | TIMESTAMP | IVUNRS Internal Timestamp |
| 46 | SAD_UC_IVGDGCDT | DateTime(26) | TIMESTAMP | IVGDGC Internal Timestamp |
| 47 | SAD_UC_IVGEDUCDT | DateTime(26) | TIMESTAMP | IVGEDUC Internal Timestamp |
| 48 | SAD_UC_IVGFDGDT | DateTime(26) | TIMESTAMP | IVGFDG Internal Timestamp |
| 49 | SAD_UC_IVGFMQDT | DateTime(26) | TIMESTAMP | IVGFMQ Internal Timestamp |
| 50 | SAD_UC_IVGOFFERDT | DateTime(26) | TIMESTAMP | ivgOffer Timestamp |
| 51 | SAD_UC_IVGOLNDT | DateTime(26) | TIMESTAMP | IVGOLN Internal Timestamp |
| 52 | SAD_UC_IVGREFDT | DateTime(26) | TIMESTAMP | ivgReference Timestamp |
| 53 | SAD_UC_IVGSTARADT | DateTime(26) | TIMESTAMP | IVGSTARA Internal Timestamp |
| 54 | SAD_UC_IVGSTARGDT | DateTime(26) | TIMESTAMP | IVStarG Timestamp |
| 55 | SAD_UC_IVGSTARHDT | DateTime(26) | TIMESTAMP | IVGSTARH Internal Timestamp |
| 56 | SAD_UC_IVGSTARKDT | DateTime(26) | TIMESTAMP | IVGSTARK Internal Timestamp |
| 57 | SAD_UC_IVGSTARNDT | DateTime(26) | TIMESTAMP | IVGSTARN Internal Timestamp |
| 58 | SAD_UC_IVGSTARWDT | DateTime(26) | TIMESTAMP | IVGSTARW Internal Timestamp |
| 59 | SAD_UC_IVGSTARXDT | DateTime(26) | TIMESTAMP | IVGSTARX Internal Timestamp |
| 60 | SAD_UC_IVGSTMNTDT | DateTime(26) | TIMESTAMP | ivgStatement Timestamp |
| 61 | SAD_UC_IVGEXPDT | DateTime(26) | TIMESTAMP | IVGEXP Internal Timestamp |
| 62 | SAD_UC_IVSTARZ1DT | DateTime(26) | TIMESTAMP | ivstarz1 internal timestamp |
| 63 | SAD_UC_IMP_STRJ_G | Character(1) | VARCHAR2(1) NOT NULL |
Import HESA Data UTT
Y/N Table Edit |
| 64 | SAD_UC_IMP_STRJ_U | Character(1) | VARCHAR2(1) NOT NULL |
Import HESA Data UCAS
Y/N Table Edit |
| 65 | SAD_UC_IVSTARJDT | DateTime(26) | TIMESTAMP | IVSTARJ Internal Timestamp |
| 66 | SAD_UC_IVGSTARJDT | DateTime(26) | TIMESTAMP | IVGSTARJ Internal Timestamp |
| 67 | SAD_UC_CYCLE | Number(4,0) | SMALLINT NOT NULL | UCAS Cycle |
| 68 | SAD_UC_EAR_APPYEAR | Number(4,0) | SMALLINT NOT NULL | Earliest Application Year |
| 69 | SAD_UC_YEAR | Number(4,0) | SMALLINT NOT NULL | School Year |
| 70 | SAD_UC_IMP_UNITS | Character(1) | VARCHAR2(1) NOT NULL | Unit Results |
| 71 | SAD_UC_UNICODE | Character(1) | VARCHAR2(1) NOT NULL | Unicode |
| 72 | SAD_UC_CONTEXTUAL | Character(1) | VARCHAR2(1) NOT NULL | Contextual Data |
| 73 | SAD_UC_IVCONTXDT | DateTime(26) | TIMESTAMP | ivContextual Date |
| 74 | SAD_UC_RUNNING | Character(1) | VARCHAR2(1) NOT NULL |
Refresh Control Running
Default Value: N |
| 75 | SAD_UC_IVGEXPDT1 | DateTime(26) | TIMESTAMP | IVGEXP Internal Timestamp 2015 |
| 76 | SAD_UC_SYSTEM | Character(4) | VARCHAR2(4) NOT NULL |
UCAS System
APPL=Apply GTTR=UTT GTTR=UTT UCAS=UCAS |
| 77 | SAD_UC_IMP_APPL_A | Character(1) | VARCHAR2(1) NOT NULL | Import Applicants Apply |
| 78 | SAD_UC_APPLDT | DateTime(26) | TIMESTAMP | Field for DFE API |
| 79 | SAD_UC_IVASRRDT | DateTime(26) | TIMESTAMP | ivSelf Release Report Date |
| 80 | SAD_UC_UCAPXML | Character(1) | VARCHAR2(1) NOT NULL | Use XML for Applicants |
| 81 | SAD_UC_UCDCXML | Character(1) | VARCHAR2(1) NOT NULL | Use XML for Decisions |
| 82 | SAD_UC_UCIDXML | Character(100) | VARCHAR2(100) NOT NULL | XML-Link User ID |
| 83 | SAD_UC_UCPWXML | Character(50) | VARCHAR2(50) NOT NULL | XML-Link Password |
| 84 | SAD_UC_WPDATADT | DateTime(26) | TIMESTAMP | Widening Participation Date |
| 85 | FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag |
| 86 | SAD_UC_ADRHSTDT | DateTime(26) | TIMESTAMP | Address History Timestamp |