eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_UC_EXP_QUAL_SUM_V

Product:	IGS - Student System (Obsolete)
Description:	View which selects the Expected Qualification Summary Details
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT EQS.ROWID
, EQS.EXP_QUAL_SUM_ID
, EQS.PERSON_ID
, EQS.EXP_GCE
, EQS.EXP_VCE
, EQS.WINTER_A_LEVELS
, EQS.PREV_A_LEVELS
, EQS.PREV_AS_LEVELS
, EQS.SQA
, EQS.BTEC
, EQS.IB
, EQS.ILC
, EQS.AILC
, EQS.KSI
, EQS.ROA
, EQS.MANUAL
, EQS.OEQ
, URC1.CODE_TEXT
, EQS.PREV_OEQ
, URC2.CODE_TEXT
, EQS.VQI
, HCV.VALUE_DESCRIPTION
, EQS.SEQ_UPDATED_DATE
, EQS.CREATED_BY
, EQS.CREATION_DATE
, EQS.LAST_UPDATED_BY
, EQS.LAST_UPDATE_DATE
, EQS.LAST_UPDATE_LOGIN
FROM IGS_UC_EXP_QUAL_SUM EQS
, IGS_UC_REF_CODES URC1
, IGS_UC_REF_CODES URC2
, IGS_HE_CODE_VALUES HCV
WHERE EQS.OEQ = URC1.CODE(+)
AND URC1.CODE_TYPE(+) = 'OC'
AND EQS.PREV_OEQ = URC2.CODE(+)
AND URC2.CODE_TYPE(+) = 'OC'
AND EQS.VQI = HCV.VALUE(+)
AND HCV.CODE_TYPE(+) = 'UCAS_VOC_QUAL'

Columns

Name
ROW_ID
EXP_QUAL_SUM_ID
PERSON_ID
EXP_GCE
EXP_VCE
WINTER_A_LEVELS
PREV_A_LEVELS
PREV_AS_LEVELS
SQA
BTEC
IB
ILC
AILC
KSI
ROA
MANUAL
OEQ
OEQ_DESC
PREV_OEQ
PREV_OEQ_DESC
VQI
VQI_DESC
SEQ_UPDATED_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN