SAD_UC_OTH_CH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SAD_UC_APPCODE	Character(10)	VARCHAR2(10) NOT NULL	Application Code
3	SAD_UC_PERS_ID	Character(10)	VARCHAR2(10) NOT NULL	Personalid - Unique personal identifier
4	SAD_UC_CHOICENO	Number(3,0)	SMALLINT NOT NULL	Choice Number
5	SAD_UC_TIMESTAMP	DateTime(26)	TIMESTAMP	Timestamp
6	SAD_UC_LASTCHANGE	DateTime(26)	TIMESTAMP	Last Change
7	SAD_UC_REFERRAL_DT	DateTime(26)	TIMESTAMP	Referral Date
8	SAD_UC_INST	Character(3)	VARCHAR2(3) NOT NULL	UCAS Institution Code
9	SAD_UC_COURSE	Character(4)	VARCHAR2(4) NOT NULL	UCAS Course Code
10	SAD_UC_CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus
11	SAD_UC_FACULTY	Character(20)	VARCHAR2(20) NOT NULL	Faculty
12	SAD_UC_HOME	Character(1)	VARCHAR2(1) NOT NULL	Home H=Live at home
13	SAD_UC_DECISION	Character(1)	VARCHAR2(1) NOT NULL	Decision A=Accept C=Conditional Offer D=Delayed Confirmation F=Full Course I=Interview N=None R=Rejection U=Unconditional Offer W=Withdrawal
14	SAD_UC_DECISION_DT	DateTime(26)	TIMESTAMP	Decision Date/Time
15	SAD_UC_DECISIONNBR	Number(2,0)	SMALLINT NOT NULL	Decision Number
16	SAD_UC_REPLY	Character(1)	VARCHAR2(1) NOT NULL	Reply D=Declined F=Firm Acceptance I=Insurance Acceptance
17	SAD_UC_SUMMRY_COND	Character(6)	VARCHAR2(6) NOT NULL	Summary Condition
18	SAD_UC_ENTRYMONTH	Number(2,0)	SMALLINT NOT NULL	Entry Month
19	SAD_UC_ENTRYYEAR	Number(4,0)	SMALLINT NOT NULL	Entry Year
20	SAD_UC_STARTDATE	DateTime(26)	TIMESTAMP	Start Date
21	SAD_UC_ENTRY_POINT	Number(1,0)	SMALLINT NOT NULL	UCAS Entry Point
22	SAD_UC_CHOICE_CNCL	Character(1)	VARCHAR2(1) NOT NULL	Choice Cancelled Y/N Table Edit
23	SAD_UC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action A=Auto Declined D=Decline by Default R=Reject by Default U=Uprated
24	SAD_UC_SUBSTITUTN	Character(1)	VARCHAR2(1) NOT NULL	Substitution 1=Up to 15th Jan 2=After 15 Jan before 30 June 3=JAE upto 15th Jan 4=JAE after 15th Jan
25	SAD_UC_SUBST_DATE	DateTime(26)	TIMESTAMP	Date Substituted
26	SAD_UC_PREV_INST	Character(3)	VARCHAR2(3) NOT NULL	Previous Institution
27	SAD_UC_PREV_COURSE	Character(4)	VARCHAR2(4) NOT NULL	Previous Course
28	SAD_UC_PREV_CAMPUS	Character(3)	VARCHAR2(3) NOT NULL	Previous Campus
29	SAD_UC_ROUTEB_PREF	Number(2,0)	SMALLINT NOT NULL	Route B Preference
30	SAD_UC_ROUTEB_RND	Number(2,0)	SMALLINT NOT NULL	Route B Round
31	SAD_UC_DETAIL	Character(250)	VARCHAR2(250) NOT NULL	Detail
32	SAD_UC_EXTRA_ROUND	Number(3,0)	SMALLINT NOT NULL	Extra Round
33	SAD_UC_RBDDATE	Date(10)	DATE	RBD Date
34	SAD_UC_PREV_DCSN	Character(1)	VARCHAR2(1) NOT NULL	Previous Decision A=Accept C=Conditional Offer D=Delayed Conditional F=Full Course I=Interview R=Rejection U=Unconditional Offer W=Withdrawal
35	SAD_UC_PREV_REPLY	Character(1)	VARCHAR2(1) NOT NULL	Previous Reply D=Declined F=Firm Acceptance I=Insurance Acceptance
36	SAD_UC_DEFER_ENTRY	Character(1)	VARCHAR2(1) NOT NULL	Defer Entry
37	SAD_UC_JOINT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Joint Type A=Joint Admissions Entity C=Joint Course
38	SAD_UC_DC_REASON	Character(50)	VARCHAR2(50) NOT NULL	Delayed Confirmation Reason
39	SAD_UC_DC_ACTION	Long Character(500)	VARCHAR2(500)	Delayed Confirmation Action