[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view contains the details of credit granted through advanced standing based on the UK Qualifications structure. The credit is shown only as an aggregated summary figure. |
| Implementation/DBA Data: | Not implemented in this database |
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