SAD_UC_APDECISN(SQL Table) |
Index Back |
---|---|
Apply decision |
# | 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 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
5 | SAD_UC_DEC_MAKER | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: %EDITTABLE3 |
6 | SAD_UC_REJECT_RSN | Long Character(1330) | VARCHAR2(1330) | Field for DFE API |
7 | SAD_UC_INST | Character(3) | VARCHAR2(3) NOT NULL | UCAS Institution Code |
8 | SAD_UC_COURSE | Character(4) | VARCHAR2(4) NOT NULL | UCAS Course Code |
9 | SAD_UC_CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
10 | SAD_UC_STUDY_MODE | Character(10) | VARCHAR2(10) NOT NULL | Study Mode |
11 | SAD_UC_CYCLE | Number(4,0) | SMALLINT NOT NULL | UCAS Cycle |
12 | SAD_UC_APP_STATUS | Character(30) | VARCHAR2(30) NOT NULL |
Application Status
Prompt Table: SAD_UC_APSTD_VW |
13 | SAD_UC_EXP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Field for DFE Apply
C=Completed E=Error N=New R=Resend |
14 | SAD_UC_TIMESTAMP | DateTime(26) | TIMESTAMP | Timestamp |
15 | SAD_UC_ERROR_MSG | Long Character | CLOB | Field for DFE Apply |
16 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
17 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
18 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
19 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |