SAD_UC_I_STARN

(SQL Table)
Index Back

Staging record for ivStarN

# 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 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
5 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
6 SAD_UC_APPYEAR Character(4) VARCHAR2(4) NOT NULL Application Year
7 SAD_UC_ULN Character(10) VARCHAR2(10) NOT NULL Unique Learner Number
8 SAD_UC_PREFIXTITLE Character(4) VARCHAR2(4) NOT NULL Prefix Title
9 SAD_UC_FORENAMES Character(60) VARCHAR2(60) NOT NULL Forenames
10 SAD_UC_SURNAME Character(60) VARCHAR2(60) NOT NULL Surname
11 SAD_UC_BIRTHDATE DateTime(26) TIMESTAMP Date of Birth
12 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
13 SAD_UC_PREV_SNAME Character(30) VARCHAR2(30) NOT NULL Previous Surname
14 SAD_UC_SYSTEM Character(4) VARCHAR2(4) NOT NULL System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
15 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)
16 SAD_UC_PROXY_NAME Character(50) VARCHAR2(50) NOT NULL Nominee Name
17 SAD_UC_PROXY_REL Character(50) VARCHAR2(50) NOT NULL Nominee Relationship
18 SAD_UC_FURTHER_INF Long Character(10240) CLOB Field for DFE API
19 SAD_UC_SUPPORT_REF Character(10) VARCHAR2(10) NOT NULL Field for DFE API