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