SAD_UC_USR_DFLT

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_CS.OPRID

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

3 SAD_UC_COURSE Character(4) VARCHAR2(4) NOT NULL UCAS Course Code

Prompt Table: SAD_UC_COURSEVW

4 SAD_UC_CAMPUS Character(5) VARCHAR2(5) NOT NULL UCAS Campus

Prompt Table: SAD_UC_CAMPUSVW

5 SAD_UC_ENTRYYEAR Number(4,0) SMALLINT NOT NULL UCAS Entry Year
6 SAD_UC_DEC_MAKER Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: %EDITTABLE

7 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
8 SAD_UC_OFFER_CD Character(8) VARCHAR2(8) NOT NULL Offer Code

Prompt Table: SAD_UC_OFFCD_VW

9 SAD_UC_GT_COURSE Character(4) VARCHAR2(4) NOT NULL UTT Course

Prompt Table: SAD_UC_GTCRSEVW

10 SAD_UC_GT_CAMPUS Character(3) VARCHAR2(3) NOT NULL UTT Campus

Prompt Table: SAD_UC_GTCAMPVW

11 SAD_UC_GTENTRYYEAR Number(4,0) SMALLINT NOT NULL UTT Entry Year
12 SAD_UC_GTDEC_MAKER Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: %EDITTABLE

13 SAD_UC_GT_DECISION Character(1) VARCHAR2(1) NOT NULL Decision
A=Accept
C=Conditional Offer
D=Delayed Conditional
E=Not qualified in English
G=Course Closed
I=Interview
M=Not qualified in Mathematics
N=None
R=Rejection
S=Not qualified in Science
U=Unconditional Offer
W=Withdrawal
14 SAD_UC_GTOFFER_CD Character(8) VARCHAR2(8) NOT NULL Offer

Prompt Table: SAD_UC_GOFFCDVW

15 SAD_UC_APPROVER Character(11) VARCHAR2(11) NOT NULL Approver

Prompt Table: %EDITTABLE

16 SAD_UC_GTAPPROVER Character(11) VARCHAR2(11) NOT NULL Approver

Prompt Table: %EDITTABLE

17 SAD_UC_INST Character(3) VARCHAR2(3) NOT NULL UCAS Institution Code

Prompt Table: SAD_UC_PCODE_VW

18 SAD_UC_AP_COURSE Character(4) VARCHAR2(4) NOT NULL Apply Course

Prompt Table: SAD_UC_ACRC3_VW

19 SAD_UC_APENTRYYEAR Number(4,0) SMALLINT NOT NULL Apply Entry Year
20 SAD_UC_APDEC_MAKER Character(11) VARCHAR2(11) NOT NULL Decision Maker

Prompt Table: %EDITTABLE