SAD_UC_PQRVW

(SQL View)
Index Back

SELECT INSTITUTION ,SAD_UC_APPCODE ,SAD_UC_PERS_ID ,SAD_UC_SUBJID ,SAD_UC_TIMESTAMP ,SAD_UC_QUALTYPE ,SAD_UC_AWDBDY10 ,SAD_UC_SUBJTITLE ,SAD_UC_SUBJCODE ,SAD_UC_RESULT ,SAD_UC_AMND_RES ,SAD_UC_QUALDTYEAR ,SAD_UC_QUALMONTH ,SAD_UC_SYSTEM ,SAD_UC_TARIFFSCORE FROM %Table(SAD_UC_FRMQUAL) WHERE sad_uc_subjid <> '0'

# 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_SUBJID Character(10) VARCHAR2(10) NOT NULL Subject ID
5 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
6 SAD_UC_QUALTYPE Character(250) VARCHAR2(250) NOT NULL Qualification Type
7 SAD_UC_AWDBDY10 Character(10) VARCHAR2(10) NOT NULL Award Body
8 SAD_UC_SUBJTITLE Character(100) VARCHAR2(100) NOT NULL Subject Title
9 SAD_UC_SUBJCODE Character(6) VARCHAR2(6) NOT NULL Subject Code
10 SAD_UC_RESULT Character(20) VARCHAR2(20) NOT NULL Result
11 SAD_UC_AMND_RES Character(10) VARCHAR2(10) NOT NULL Amended Examination Result
12 SAD_UC_QUALDTYEAR Number(4,0) SMALLINT NOT NULL Qualification Year
13 SAD_UC_QUALMONTH Number(2,0) SMALLINT NOT NULL Qualification Month
14 SAD_UC_SYSTEM Character(4) VARCHAR2(4) NOT NULL UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
15 SAD_UC_TARIFFSCORE Number(5,0) INTEGER NOT NULL Tariff Score