[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Full business view to allow queries on Student Program Attempt UCAS Tariff HESA Details. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT UT.HESA_ST_SPAU_ID HESA_ST_SPAU_ID
, UT.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, PER.PERSON_LAST_NAME PERSON_SURNAME
, PER.PERSON_FIRST_NAME PERSON_GIVEN_NAMES
, PERP.PERSON_NAME PERSON_FULL_NAME
, UT.COURSE_CD PROGRAM_CODE
, PS.TITLE PROGRAM_TITLE
, PS.SHORT_TITLE PROGRAM_SHORT_TITLE
, PS.ABBREVIATION PROGRAM_ABBREVIATION
, UT.VERSION_NUMBER VERSION_NUMBER
, UT.QUALIFICATION_LEVEL QUALIFICATION_LEVEL
, (SELECT AWARD_TITLE
FROM IGS_PS_AWD
WHERE AWARD_CD = UT.QUALIFICATION_LEVEL) QUALIFICATION_LEVEL_TITLE
, 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
, HZ_PERSON_PROFILES PERP
, IGS_PS_VER_ALL PS
WHERE PER.PARTY_ID = UT.PERSON_ID
AND PER.PARTY_ID = PERP.PARTY_ID
AND PERP.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND SYSDATE BETWEEN PERP.EFFECTIVE_START_DATE
AND NVL(PERP.EFFECTIVE_END_DATE
, SYSDATE)
AND PS.COURSE_CD = UT.COURSE_CD
AND PS.VERSION_NUMBER = UT.VERSION_NUMBER WITH READ ONLY