SAD_UC_CRS_AET

#	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_INST	Character(3)	VARCHAR2(3) NOT NULL	UCAS Institution Code
6	SAD_UC_COURSE	Character(4)	VARCHAR2(4) NOT NULL	UCAS Course Code
7	SAD_UC_CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus
8	SAD_UC_ENTRYYEAR	Number(4,0)	SMALLINT NOT NULL	Entry Year
9	SAD_UC_ENTRYMONTH	Number(2,0)	SMALLINT NOT NULL	Entry Month
10	SAD_UC_TIMESTAMP	DateTime(26)	TIMESTAMP	Timestamp
11	SAD_UC_FACULTY	Character(20)	VARCHAR2(20) NOT NULL	Faculty
12	SAD_UC_SHORTNAME	Character(20)	VARCHAR2(20) NOT NULL	Short Name
13	SAD_UC_LONGNAME	Character(100)	VARCHAR2(100) NOT NULL	Long Name
14	SAD_UC_JOINTADMS	Character(1)	VARCHAR2(1) NOT NULL	Joint Admission
15	SAD_UC_OPENEXTRA	Character(1)	VARCHAR2(1) NOT NULL	Open Extra
16	SAD_UC_STATUS	Character(20)	VARCHAR2(20) NOT NULL	Status
17	SAD_UC_STARTDATE	DateTime(26)	TIMESTAMP	Start Date
18	SAD_UC_AGERESTR	Character(1)	VARCHAR2(1) NOT NULL	Age Restriction
19	SAD_UC_COURSETYPE	Character(1)	VARCHAR2(1) NOT NULL	Course Type A=Art and Design C=Former CATCH D=Dentistry M=Medicine N=Former NMAS V=Veterinary
20	SAD_UC_INTRV	Character(1)	VARCHAR2(1) NOT NULL	Interview Y/N Table Edit Default Value: N
21	SAD_UC_PORTF_EVID	Character(1)	VARCHAR2(1) NOT NULL	Portfolio Required Y/N Table Edit Default Value: N
22	SAD_UC_CRIMCHK_REQ	Character(1)	VARCHAR2(1) NOT NULL	Criminal Check Required Y/N Table Edit Default Value: N
23	SAD_UC_CYCLE	Number(4,0)	SMALLINT NOT NULL	UCAS Cycle
24	SAD_UC_OPENCLRG	Character(1)	VARCHAR2(1) NOT NULL	Open for Clearing