Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Base 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
, 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