SAD_UC_STARWAET

#	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_PERS_ID	Character(10)	VARCHAR2(10) NOT NULL	Personalid - Unique personal identifier
6	SAD_UC_APPCODE	Character(10)	VARCHAR2(10) NOT NULL	Application Code
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	SAD_UC_APPYEAR	Character(4)	VARCHAR2(4) NOT NULL	UCAS Admissions Cycle
9	SAD_UC_TIMESTAMP	DateTime(26)	TIMESTAMP	Timestamp
10	SAD_UC_MISCODED	Character(1)	VARCHAR2(1) NOT NULL	Miscoded Default Value: N
11	SAD_UC_CHOICE_CNCL	Character(1)	VARCHAR2(1) NOT NULL	Cancelled Default Value: N
12	SAD_UC_JOINTADMS	Character(1)	VARCHAR2(1) NOT NULL	Joint Admission Default Value: N
13	SAD_UC_CANCDATE	DateTime(26)	TIMESTAMP	Course Cancelled Date
14	SAD_UC_CHOICE1LOST	Character(1)	VARCHAR2(1) NOT NULL	Choice 1 Lost Default Value: N
15	SAD_UC_CHOICE2LOST	Character(1)	VARCHAR2(1) NOT NULL	Choice 2 Lost Default Value: N
16	SAD_UC_CHOICE3LOST	Character(1)	VARCHAR2(1) NOT NULL	Choice 3 Lost Default Value: N
17	SAD_UC_CHOICE4LOST	Character(1)	VARCHAR2(1) NOT NULL	Choice 4 Lost Default Value: N
18	SAD_UC_CHOICE5LOST	Character(1)	VARCHAR2(1) NOT NULL	Choice 5 Lost Default Value: N
19	SAD_UC_CHOICE6LOST	Character(1)	VARCHAR2(1) NOT NULL	Choice 6 Lost Default Value: N
20	SAD_UC_CHOICE7LOST	Character(1)	VARCHAR2(1) NOT NULL	Choice 7 Lost Default Value: N
21	SAD_UC_REMARK	Character(30)	VARCHAR2(30) NOT NULL	Remark
22	SAD_UC_RECSTATUS	Character(2)	VARCHAR2(2) NOT NULL	Status NA=No Action P=Pending PR=Partially Removed R=Removed