SAD_UC_AEXP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
4	SAD_UC_ATTRE	Character(100)	VARCHAR2(100) NOT NULL	Attribution Email
5	SAD_UC_ATTRN	Character(120)	VARCHAR2(120) NOT NULL	Attribution Name
6	SAD_UC_ATTRT	Character(50)	VARCHAR2(50) NOT NULL	Attribution Token
7	SAD_UC_ATTRU	Character(100)	VARCHAR2(100) NOT NULL	Attribution User ID
8	SAD_UC_PERS_ID	Character(10)	VARCHAR2(10) NOT NULL	Personalid - Unique personal identifier
9	SAD_UC_APPCODE	Character(10)	VARCHAR2(10) NOT NULL	Application Code
10	SAD_UC_APP_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Application Status
11	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
12	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
13	SAD_UC_SYSTEM	Character(4)	VARCHAR2(4) NOT NULL	UCAS System APPL=Apply GTTR=UTT GTTR=UTT UCAS=UCAS
14	SAD_UC_REJECT_RSN	Long Character(1330)	VARCHAR2(1330)	Field for DFE API
15	SAD_UC_ERROR_MSG	Long Character	CLOB	Field for DFE Apply
16	SAD_UC_COURSE	Character(4)	VARCHAR2(4) NOT NULL	UCAS Course Code
17	SAD_UC_CYCLE	Number(4,0)	SMALLINT NOT NULL	UCAS Cycle
18	SAD_UC_INST	Character(3)	VARCHAR2(3) NOT NULL	UCAS Institution Code
19	SAD_UC_SITE	Character(5)	VARCHAR2(5) NOT NULL	Site Code
20	SAD_UC_STUDY_MODE	Character(10)	VARCHAR2(10) NOT NULL	Study Mode