SAD_UC_I_STARZ1

(SQL Table)
Index Back

IvStarZ1 Staging Record

IvStarZ1 Staging Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

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_CEFNO Number(6,0) INTEGER NOT NULL CEF Number
7 SAD_UC_INST Character(3) VARCHAR2(3) NOT NULL UCAS Institution Code

Prompt Table: SAD_UC_INST

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

Prompt Table: SAD_UC_COURSEVW

9 SAD_UC_CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

Prompt Table: SAD_UC_CAMPUSVW

10 SAD_UC_FACULTY Character(20) VARCHAR2(20) NOT NULL Faculty
11 SAD_UC_ENTRYYEAR Number(4,0) SMALLINT NOT NULL Entry Year
12 SAD_UC_ENTRYMONTH Number(2,0) SMALLINT NOT NULL Entry Month
13 SAD_UC_ENTRY_POINT Number(1,0) SMALLINT NOT NULL UCAS Entry Point
14 SAD_UC_RSLT Character(1) VARCHAR2(1) NOT NULL Result
15 SAD_UC_REPLY Character(1) VARCHAR2(1) NOT NULL Reply
D=Declined
F=Firm Acceptance
I=Insurance Acceptance
16 SAD_UC_IMP_STATUS Character(1) VARCHAR2(1) NOT NULL Import Status
E=Error (E)
I=Imported (I)
N=New (N)
P=Pending (P)
R=Pending (R)
T=Error (T)
17 SAD_UC_CRMREC_DECL Character(1) VARCHAR2(1) NOT NULL Criminal Records Declared
D=Declared
U=Undeclared
X=Not Presented