Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Full View for Applicant Reference details |
Implementation/DBA Data: | Not implemented in this database |
SELECT AP.APP_NO UCAS_APPLICANT_NUMBER
, AP.REFEREE_NAME REFEREE_NAME
, AP.REFEREE_POST REFEREE_POST
, AP.ESTAB_NAME ESTABLISHMENT_NAME
, AP.ADDRESS1 ADDRESS1
, AP.ADDRESS2 ADDRESS2
, AP.ADDRESS3 ADDRESS3
, AP.ADDRESS4 ADDRESS4
, AP.TELEPHONE TELEPHONE
, AP.FAX FAX
, AP.EMAIL EMAIL
, AP.STATEMENT STATEMENT
, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER
, FT2.PARTY_NUMBER OSS_PERSON_NUMBER
, FT2.PARTY_NAME OSS_PERSON_NAME
, AP.PREDICTED_GRADES PREDICTED_GRADES
, AP.CREATED_BY CREATED_BY
, AP.CREATION_DATE CREATION_DATE
, AP.LAST_UPDATED_BY LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_APP_REFEREES AP
, IGS_UC_APPLICANTS FT1
, HZ_PARTIES FT2
WHERE AP.APP_NO = FT1.APP_NO
AND FT1.OSS_PERSON_ID = FT2.PARTY_ID (+) WITH READ ONLY