Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Full View for the qualifications awarded to an applicant |
Implementation/DBA Data: | Not implemented in this database |
SELECT QU.QUAL_DETS_ID QUAL_DETAILS_IDENTIFIER
, QU.PERSON_ID OSS_PERSON_IDENTIFIER
, QU.EXAM_LEVEL EXAM_LEVEL_CODE
, QU.SUBJECT_CODE SUBJECT_CODE
, QU.YEAR YEAR
, QU.SITTING SITTING
, '_LA:QU.SITTING:IGS_LOOKUP_VALUES:IGS_UC_SITTING:MEANING' "_LA:SITTING_DESC"
, QU.AWARDING_BODY AWARDING_BODY_CODE
, QU.GRADING_SCHEMA_CD GRADING_SCHEMA_CODE
, QU.VERSION_NUMBER VERSION_NUMBER
, QU.PREDICTED_RESULT PREDICTED_RESULT
, QU.APPROVED_RESULT APPROVED_RESULT
, QU.CLAIMED_RESULT CLAIMED_RESULT
, QU.UCAS_TARIFF UCAS_TARIFF
, QU.IMPORTED_FLAG IMPORTED_FLAG
, QU.IMPORTED_DATE IMPORTED_DATE
, FT1.PARTY_NUMBER OSS_PERSON_NUMBER
, FT1.PARTY_NAME OSS_PERSON_NAME
, FT2.AWARD_TITLE EXAM_LEVEL_TITLE
, FT3.DESCRIPTION SUBJECT_CODE_DESC
, FT4.FULL_GRADE_NAME APPROVED_RESULT_DESCRIPTION
, FT4.RANK APPROVED_RESULT_SCORE
, FT5.FULL_GRADE_NAME PREDICTED_RESULT_DESCRIPTION
, FT5.RANK PREDICTED_RESULT_SCORE
, FT6.FULL_GRADE_NAME CLAIMED_RESULT_DESCRIPTION
, FT6.RANK CLAIMED_RESULT_SCORE
, FT7.PARTY_NAME AWARDING_BODY_NAME
, QU.CREATION_DATE CREATION_DATE
, QU.CREATED_BY CREATED_BY
, QU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QU.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGS_UC_QUAL_DETS QU
, HZ_PARTIES FT1
, IGS_PS_AWD FT2
, IGS_PS_FLD_OF_STUDY_ALL FT3
, IGS_AS_GRD_SCH_GRADE FT4
, IGS_AS_GRD_SCH_GRADE FT5
, IGS_AS_GRD_SCH_GRADE FT6
, HZ_PARTIES FT7
, IGS_PE_HZ_PARTIES IHP
WHERE QU.PERSON_ID = FT1.PARTY_ID (+)
AND QU.EXAM_LEVEL = FT2.AWARD_CD (+)
AND QU.SUBJECT_CODE = FT3.FIELD_OF_STUDY (+)
AND QU.GRADING_SCHEMA_CD = FT4.GRADING_SCHEMA_CD (+)
AND QU.VERSION_NUMBER = FT4.VERSION_NUMBER (+)
AND QU.APPROVED_RESULT = FT4.GRADE (+)
AND QU.GRADING_SCHEMA_CD = FT5.GRADING_SCHEMA_CD (+)
AND QU.VERSION_NUMBER = FT5.VERSION_NUMBER (+)
AND QU.PREDICTED_RESULT = FT5.GRADE (+)
AND QU.GRADING_SCHEMA_CD = FT6.GRADING_SCHEMA_CD (+)
AND QU.VERSION_NUMBER = FT6.VERSION_NUMBER (+)
AND QU.CLAIMED_RESULT = FT6.GRADE (+)
AND QU.AWARDING_BODY = IHP.OSS_ORG_UNIT_CD (+)
AND IHP.PARTY_ID = FT7.PARTY_ID(+) WITH READ ONLY