VIEW: APPS.IGS_PR_ACAD_QUAL_CREDIT_V

Source

View Text - Preformatted

SELECT spa.person_id, hz.party_number person_number, spa.course_cd program_cd, qd.exam_level, awd.award_title exam_level_description, qd.subject_code, fos.description subject_code_description, qd.year, qd.sitting, qd.awarding_body, ins.description awarding_body_description, qd.predicted_result, qd.approved_result, qd.claimed_result, qd.ucas_tariff, qd.qual_dets_id, SUM(adv.credit_points) credit_points FROM igs_uc_qual_dets qd, igs_en_stdnt_ps_att_all spa, hz_parties hz, igs_or_institution ins, igs_ps_awd awd, igs_ps_fld_of_study_all fos, ( SELECT asul.person_id, qual_dets_id, as_course_cd, credit_points credit_points FROM igs_av_stnd_unit_lvl_all asul WHERE asul.test_segment_id IS NOT NULL AND asul.s_adv_stnd_granting_status = 'GRANTED' ) adv WHERE qd.person_id = spa.person_id AND hz.party_id = spa.person_id AND adv.person_id = spa.person_id AND adv.as_course_cd = spa.course_cd AND adv.qual_dets_id = qd.qual_dets_id AND ins.institution_cd (+)= qd.awarding_body AND awd.award_cd (+)= qd.exam_level AND fos.field_of_study (+)= qd.subject_code GROUP BY spa.person_id, hz.party_number, spa.course_cd , qd.exam_level, awd.award_title, qd.subject_code, fos.description , qd.year, qd.sitting, qd.awarding_body, ins.description , qd.predicted_result, qd.approved_result, qd.claimed_result, qd.ucas_tariff, qd.qual_dets_id

View Text - HTML Formatted

SELECT SPA.PERSON_ID
, HZ.PARTY_NUMBER PERSON_NUMBER
, SPA.COURSE_CD PROGRAM_CD
, QD.EXAM_LEVEL
, AWD.AWARD_TITLE EXAM_LEVEL_DESCRIPTION
, QD.SUBJECT_CODE
, FOS.DESCRIPTION SUBJECT_CODE_DESCRIPTION
, QD.YEAR
, QD.SITTING
, QD.AWARDING_BODY
, INS.DESCRIPTION AWARDING_BODY_DESCRIPTION
, QD.PREDICTED_RESULT
, QD.APPROVED_RESULT
, QD.CLAIMED_RESULT
, QD.UCAS_TARIFF
, QD.QUAL_DETS_ID
, SUM(ADV.CREDIT_POINTS) CREDIT_POINTS
FROM IGS_UC_QUAL_DETS QD
, IGS_EN_STDNT_PS_ATT_ALL SPA
, HZ_PARTIES HZ
, IGS_OR_INSTITUTION INS
, IGS_PS_AWD AWD
, IGS_PS_FLD_OF_STUDY_ALL FOS
, ( SELECT ASUL.PERSON_ID
, QUAL_DETS_ID
, AS_COURSE_CD
, CREDIT_POINTS CREDIT_POINTS
FROM IGS_AV_STND_UNIT_LVL_ALL ASUL
WHERE ASUL.TEST_SEGMENT_ID IS NOT NULL
AND ASUL.S_ADV_STND_GRANTING_STATUS = 'GRANTED' ) ADV
WHERE QD.PERSON_ID = SPA.PERSON_ID
AND HZ.PARTY_ID = SPA.PERSON_ID
AND ADV.PERSON_ID = SPA.PERSON_ID
AND ADV.AS_COURSE_CD = SPA.COURSE_CD
AND ADV.QUAL_DETS_ID = QD.QUAL_DETS_ID
AND INS.INSTITUTION_CD (+)= QD.AWARDING_BODY
AND AWD.AWARD_CD (+)= QD.EXAM_LEVEL
AND FOS.FIELD_OF_STUDY (+)= QD.SUBJECT_CODE GROUP BY SPA.PERSON_ID
, HZ.PARTY_NUMBER
, SPA.COURSE_CD
, QD.EXAM_LEVEL
, AWD.AWARD_TITLE
, QD.SUBJECT_CODE
, FOS.DESCRIPTION
, QD.YEAR
, QD.SITTING
, QD.AWARDING_BODY
, INS.DESCRIPTION
, QD.PREDICTED_RESULT
, QD.APPROVED_RESULT
, QD.CLAIMED_RESULT
, QD.UCAS_TARIFF
, QD.QUAL_DETS_ID