SAD_UC_I_GSTNVW

(SQL View)
 Index Back

Staging record for ivStarN


SELECT INSTITUTION , SAD_UC_PERS_ID , SAD_UC_APPCODE , SAD_UC_APPYEAR , SAD_UC_ULN ,SAD_UC_PREFIXTITLE , SAD_UC_FORENAMES ,SAD_UC_SURNAME , SAD_UC_BIRTHDATE , SEX , SAD_UC_PREV_SNAME , SCC_TEMP_ID , SAD_UC_TIMESTAMP , SAD_UC_IMP_STATUS , SAD_UC_FURTHER_INF , SAD_UC_SUPPORT_REF FROM PS_SAD_UC_I_STARN WHERE sad_uc_system IN('GTTR','APPL')

# 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_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
3 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application ID
4 SAD_UC_APPYEAR Character(4) VARCHAR2(4) NOT NULL Application Year
5 SAD_UC_ULN Character(10) VARCHAR2(10) NOT NULL Unique Learner Number
6 SAD_UC_PREFIXTITLE Character(4) VARCHAR2(4) NOT NULL Prefix Title
7 SAD_UC_FORENAMES Character(60) VARCHAR2(60) NOT NULL Forenames
8 SAD_UC_SURNAME Character(60) VARCHAR2(60) NOT NULL Surname
9 SAD_UC_BIRTHDATE DateTime(26) TIMESTAMP Date of Birth
10 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
11 SAD_UC_PREV_SNAME Character(30) VARCHAR2(30) NOT NULL Previous Surname
12 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
13 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
14 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)
15 SAD_UC_FURTHER_INF Long Character(10240) CLOB Field for DFE API
16 SAD_UC_SUPPORT_REF Character(10) VARCHAR2(10) NOT NULL Field for DFE API