Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Base View for Applicant Examination Results |
Implementation/DBA Data: | Not implemented in this database |
SELECT AP.APP_RESULT_ID APPLICANT_RESULT_IDENTIFIER
, AP.APP_NO UCAS_APPLICANT_NUMBER
, AP.ENQUIRY_NO ENQUIRY_NUMBER
, AP.EXAM_LEVEL EXAM_LEVEL
, AP.YEAR EXAM_YEAR
, AP.SITTING SITTING
, '_LA:AP.SITTING:IGS_LOOKUP_VALUES:IGS_UC_SITTING:MEANING' "_LA:SITTING_DESC"
, AP.AWARD_BODY AWARDING_BODY
, AP.PREDICTED_RESULT PREDICTED_RESULT
, AP.RESULT_IN_OFFER RESULT_IN_OFFER
, AP.EBL_RESULT EBL_RESULT
, AP.EBL_AMENDED_RESULT EBL_AMENDED_RESULT
, AP.CLAIMED_RESULT CLAIMED_RESULT
, AP.IMPORTED IMPORTED_FLAG
, AP.APP_ID APPLICANT_IDENTIFIER
, AP.SUBJECT_ID SUBJECT_IDENTIFIER
, 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_RESULTS AP WITH READ ONLY