[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Full View for summary of qualifications attained by this applicant |
| Implementation/DBA Data: | Not implemented in this database |
SELECT EX.EXP_QUAL_SUM_ID EXPECTED_QUAL_SUMMARY_ID
, EX.PERSON_ID OSS_PERSON_IDENTIFIER
, EX.EXP_GCE EXPECTED_GCE
, EX.EXP_VCE EXPECTED_VCE
, EX.WINTER_A_LEVELS WINTER_A_LEVELS
, EX.PREV_A_LEVELS PREVIOUS_A_LEVELS
, EX.PREV_AS_LEVELS PREVIOUS_AS_LEVELS
, EX.SQA SQA_CANDIDATE_FLAG
, EX.BTEC QUAL_BTEC_FLAG
, EX.IB QUAL_IB_FLAG
, EX.ILC QUAL_ILC_FLAG
, EX.AILC QUAL_AILC_FLAG
, EX.KSI KEY_SKILLS_FLAG
, EX.ROA RECORD_OF_ACHEIVEMENT_FLAG
, EX.MANUAL MANUAL_QUAL_CHECK
, EX.OEQ OTHER_EXAMINATION_QUAL_FLAG
, EX.PREV_OEQ PREVIOUS_OTHER_EXAM_QUAL_FLAG
, EX.VQI VOCATIONAL_QUAL_INDICATOR
, EX.SEQ_UPDATED_DATE SEQ_UPDATED_DATE
, FT1.PARTY_NUMBER OSS_PERSON_NUMBER
, FT1.PARTY_NAME OSS_PERSON_NAME
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE='OC'
AND CODE=EX.OEQ) OTHER_EXAMINATION_QUAL_DESC
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE='OC'
AND CODE=EX.PREV_OEQ) PREVIOUS_OTHER_EXAM_QUAL_DESC
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'UCAS_VOC_QUAL'
AND VALUE = EX.VQI ) VOCATIONAL_QUAL_DESCRIPTION
, EX.CREATION_DATE CREATION_DATE
, EX.CREATED_BY CREATED_BY
, EX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EX.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGS_UC_EXP_QUAL_SUM EX
, HZ_PARTIES FT1
WHERE EX.PERSON_ID = FT1.PARTY_ID (+) WITH READ ONLY