[Home] [Help]
View: IGSBV_ST_PROG_ATT_UCAS_TARIFF
Product: | IGS - Student System (Obsolete) |
Description: | Base business view to allow queries on Student Program Attempt UCAS Tariff HESA Details. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UT.HESA_ST_SPAU_ID HESA_ST_SPAU_ID
, UT.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, UT.COURSE_CD PROGRAM_CODE
, UT.VERSION_NUMBER VERSION_NUMBER
, UT.QUALIFICATION_LEVEL QUALIFICATION_LEVEL
, UT.NUMBER_OF_QUAL NUMBER_OF_QUALIFICATIONS
, UT.TARIFF_SCORE TARIFF_SCORE
, UT.CREATED_BY CREATED_BY
, UT.CREATION_DATE CREATION_DATE
, UT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UT.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGS_HE_ST_SPA_UT_ALL UT
, HZ_PARTIES PER
WHERE UT.PERSON_ID = PER.PARTY_ID WITH READ ONLY
Columns
Name |
HESA_ST_SPAU_ID |
PERSON_ID |
PERSON_NUMBER |
PROGRAM_CODE |
VERSION_NUMBER |
QUALIFICATION_LEVEL |
NUMBER_OF_QUALIFICATIONS |
TARIFF_SCORE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |