VIEW: APPS.IGSFV_UC_QUAL_DETAILS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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