SAD_UC_IVSTARC

(SQL Table)
 Index Back

IvStarC Base Record

IvStarC Base Record

# 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 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
7 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
8 SAD_UC_LASTCHANGE DateTime(26) TIMESTAMP Last Change
9 SAD_UC_REFERRAL_DT DateTime(26) TIMESTAMP Referral Date
10 SAD_UC_INST Character(3) VARCHAR2(3) NOT NULL UCAS Institution Code
11 SAD_UC_COURSE Character(4) VARCHAR2(4) NOT NULL UCAS Course Code
12 SAD_UC_CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
13 SAD_UC_FACULTY Character(20) VARCHAR2(20) NOT NULL Faculty
14 SAD_UC_HOME Character(1) VARCHAR2(1) NOT NULL Home
H=Live at home
15 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
16 SAD_UC_DECISION_DT DateTime(26) TIMESTAMP Decision Date/Time
17 SAD_UC_DECISIONNBR Number(2,0) SMALLINT NOT NULL Decision Number
18 SAD_UC_REPLY Character(1) VARCHAR2(1) NOT NULL Reply
D=Declined
F=Firm Acceptance
I=Insurance Acceptance
19 SAD_UC_SUMMRY_COND Character(6) VARCHAR2(6) NOT NULL Summary Condition
20 SAD_UC_ENTRYMONTH Number(2,0) SMALLINT NOT NULL Entry Month
21 SAD_UC_ENTRYYEAR Number(4,0) SMALLINT NOT NULL Entry Year
22 SAD_UC_STARTDATE DateTime(26) TIMESTAMP Start Date
23 SAD_UC_ENTRY_POINT Number(1,0) SMALLINT NOT NULL UCAS Entry Point
24 SAD_UC_CHOICE_CNCL Character(1) VARCHAR2(1) NOT NULL Choice Cancelled

Y/N Table Edit

25 SAD_UC_ACTION Character(1) VARCHAR2(1) NOT NULL Action
A=Auto Declined
D=Decline by Default
R=Reject by Default
U=Uprated
26 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
27 SAD_UC_SUBST_DATE DateTime(26) TIMESTAMP Date Substituted
28 SAD_UC_PREV_INST Character(3) VARCHAR2(3) NOT NULL Previous Institution
29 SAD_UC_PREV_COURSE Character(4) VARCHAR2(4) NOT NULL Previous Course
30 SAD_UC_PREV_CAMPUS Character(3) VARCHAR2(3) NOT NULL Previous Campus
31 SAD_UC_ROUTEB_PREF Number(2,0) SMALLINT NOT NULL Route B Preference
32 SAD_UC_ROUTEB_RND Number(2,0) SMALLINT NOT NULL Route B Round
33 SAD_UC_DETAIL Character(250) VARCHAR2(250) NOT NULL Detail
34 SAD_UC_EXTRA_ROUND Number(3,0) SMALLINT NOT NULL Extra Round
35 SAD_UC_RBDDATE Date(10) DATE RBD Date
36 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
37 SAD_UC_PREV_REPLY Character(1) VARCHAR2(1) NOT NULL Previous Reply
D=Declined
F=Firm Acceptance
I=Insurance Acceptance
38 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
39 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
40 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
41 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
42 SAD_UC_ADJUSTMENT Character(1) VARCHAR2(1) NOT NULL Adjustment
C=Reconfirmed in Adjustment
D=Declined in Adjustment
R=Registered for Adjustment
43 SAD_UC_INTRV_RESP Character(1) VARCHAR2(1) NOT NULL Interview Response
A=Accept Interview
D=Decline Interview
R=Request new date/time for inte
44 SAD_UC_INTRVW_DATE DateTime(26) TIMESTAMP Interview Date/Time
45 SAD_UC_CRMREC_DECL Character(1) VARCHAR2(1) NOT NULL Criminal Records Declared
D=Declared
U=Undeclared
X=Not Presented
46 SAD_UC_DBDDATE Date(10) DATE DBD Date
47 SAD_UC_DEFER_ENTRY Character(1) VARCHAR2(1) NOT NULL Defer Entry

Y/N Table Edit

48 SAD_UC_JOINT_TYPE Character(1) VARCHAR2(1) NOT NULL Joint Type
A=Joint Admissions Entity
C=Joint Course
49 SAD_UC_DC_REASON Character(50) VARCHAR2(50) NOT NULL Delayed Confirmation Reason
50 SAD_UC_DC_ACTION Long Character(500) VARCHAR2(500) Delayed Confirmation Action