Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Base 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
, 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
WHERE AP.APP_NO = FT1.APP_NO WITH READ ONLY