SAD_UC_I_IVGSTJ

(SQL Table)
 Index Back

IVGSTARJ Staging record

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

Default Value: OPR_DEF_TBL_CS.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_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
5 SAD_UC_SCN Character(9) VARCHAR2(9) NOT NULL Scottish Candidate Number
6 SAD_UC_SURNAME Character(60) VARCHAR2(60) NOT NULL Surname
7 SAD_UC_FORENAMES Character(60) VARCHAR2(60) NOT NULL Forenames
8 SAD_UC_BIRTHDT Date(10) DATE Date of Birth
9 SAD_UC_GENDER Character(1) VARCHAR2(1) NOT NULL Gender
10 SAD_UC_APR Character(4) VARCHAR2(4) NOT NULL Area Of Permanent Residency
11 SAD_UC_NATIONALITY Character(4) VARCHAR2(4) NOT NULL Nationality
12 SAD_UC_ETHNIC Character(3) VARCHAR2(3) NOT NULL Ethnic Code
13 SAD_UC_DISABLE Character(2) VARCHAR2(2) NOT NULL Disability Code
14 SAD_UC_YRLLINST Number(4,0) SMALLINT NOT NULL School Leaving Year
15 SAD_UC_POSTCODE Character(8) VARCHAR2(8) NOT NULL Postcode
16 SAD_UC_SOCIOECON Character(1) VARCHAR2(1) NOT NULL Socio-Economic Classification
17 SAD_UC_POCC Character(4) VARCHAR2(4) NOT NULL Parental Occupation
18 SAD_UC_PGCECLSS Character(2) VARCHAR2(2) NOT NULL PGCE Degree Class
19 SAD_UC_NATIOND Character(2) VARCHAR2(2) NOT NULL Primary National Identity
20 SAD_UC_ULN Character(10) VARCHAR2(10) NOT NULL Unique Learner Number
21 SAD_UC_PARED Character(1) VARCHAR2(1) NOT NULL Parental Education
22 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)
23 SAD_UC_CARELEAVER Character(2) VARCHAR2(2) NOT NULL Care Leaver
24 SAD_UC_SOCECO2010 Character(1) VARCHAR2(1) NOT NULL Social Economic 2010
25 SAD_UC_POCC2010 Character(4) VARCHAR2(4) NOT NULL Parental occupation
26 SAD_UC_SEXORT Character(2) VARCHAR2(2) NOT NULL Sexual Orientation
27 SAD_UC_RELBLF Character(2) VARCHAR2(2) NOT NULL Religion/Belief