Product: | IGS - Student System (Obsolete) |
---|---|
Description: | The qualification details view will display the qualifications awarded to an applicant |
Implementation/DBA Data: | Not implemented in this database |
SELECT QD.ROWID ROW_ID
, QD.QUAL_DETS_ID QUAL_DETS_ID
, QD.PERSON_ID PERSON_ID
, QD.EXAM_LEVEL EXAM_LEVEL
, PA.AWARD_TITLE EXAM_LEVEL_DESC
, QD.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, QD.VERSION_NUMBER VERSION_NUMBER
, QD.SUBJECT_CODE SUBJECT_CODE
, FS.DESCRIPTION SUBJECT_CODE_DESC
, QD.PREDICTED_RESULT PREDICTED_RESULT
, QD.APPROVED_RESULT APPROVED_RESULT
, QD.CLAIMED_RESULT CLAIMED_RESULT
, QD.YEAR YEAR
, QD.SITTING SITTING
, LV.MEANING SITTING_DESC
, QD.AWARDING_BODY AWARDING_BODY
, HP.PARTY_NAME AWARDING_BODY_DESC
, AGSG.RANK UCAS_TARIFF
, QD.IMPORTED_FLAG IMPORTED_FLAG
, QD.IMPORTED_DATE IMPORTED_DATE
, QD.CREATION_DATE CREATION_DATE
, QD.CREATED_BY CREATED_BY
, QD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QD.LAST_UPDATED_BY LAST_UPDATED_BY
, QD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_UC_QUAL_DETS QD
, IGS_PS_AWD PA
, IGS_PS_FLD_OF_STUDY_ALL FS
, IGS_LOOKUP_VALUES LV
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
, IGS_AS_GRD_SCH_GRADE AGSG
WHERE QD.EXAM_LEVEL = PA.AWARD_CD
AND QD.SUBJECT_CODE = FS.FIELD_OF_STUDY (+)
AND LV.LOOKUP_TYPE (+) = 'IGS_UC_SITTING'
AND QD.SITTING = LV.LOOKUP_CODE (+)
AND QD.AWARDING_BODY = IHP.OSS_ORG_UNIT_CD (+)
AND IHP.PARTY_ID = HP.PARTY_ID(+)
AND AGSG.GRADING_SCHEMA_CD (+) = QD.GRADING_SCHEMA_CD
AND AGSG.VERSION_NUMBER (+) = QD.VERSION_NUMBER
AND AGSG.GRADE (+) = QD.APPROVED_RESULT