Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Full View for individual Form Qualifications |
Implementation/DBA Data: | Not implemented in this database |
SELECT FO.APP_NO UCAS_APPLICANT_NUMBER
, FO.QUAL_ID QUALIFICATION_IDENTIFIER
, FO.QUAL_TYPE QUALIFICATION_TYPE
, FO.AWARD_BODY AWARDING_BODY
, FO.TITLE TITLE
, FO.GRADE GRADE
, FO.QUAL_DATE QUALFICATION_DATE
, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER
, FT2.PARTY_NUMBER OSS_PERSON_NUMBER
, FT2.PARTY_NAME OSS_PERSON_NAME
, FO.CREATED_BY CREATED_BY
, FO.CREATION_DATE CREATION_DATE
, FO.LAST_UPDATED_BY LAST_UPDATED_BY
, FO.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_FORM_QUALS FO
, IGS_UC_APPLICANTS FT1
, HZ_PARTIES FT2
WHERE FO.APP_NO = FT1.APP_NO
AND FT1.OSS_PERSON_ID = FT2.PARTY_ID (+) WITH READ ONLY