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_PR_SUA_FINAL_OUTCOME_V

Product:	IGS - Student System (Obsolete)
Description:	This view describes the outcome to a student unit attempt, in theform of a mark and possibly a grade (if the default grade for themark is overridden).It also descibes a student's attempt at studying a particularunit offered by the universit
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUAO.OUTCOME_DT
, SUAO.MARK
, SUAO.GRADING_SCHEMA_CD
, SUAO.VERSION_NUMBER
, SUAO.GRADE
, SUAO.TRANSLATED_GRADING_SCHEMA_CD
, SUAO.TRANSLATED_VERSION_NUMBER
, SUAO.TRANSLATED_GRADE
, SUA.DEG_AUD_DETAIL_ID
, SUA.UOO_ID FROM IGS_EN_SU_ATTEMPT SUA
, IGS_AS_SU_STMPTOUT SUAO
WHERE SUA.UNIT_ATTEMPT_STATUS = 'COMPLETED' AND SUAO.PERSON_ID = SUA.PERSON_ID AND SUAO.COURSE_CD = SUA.COURSE_CD AND SUAO.UOO_ID = SUA.UOO_ID AND SUAO.FINALISED_OUTCOME_IND = 'Y'
AND SUAO.OUTCOME_DT IN (SELECT MAX(SUAO1.OUTCOME_DT) FROM IGS_AS_SU_STMPTOUT SUAO1 WHERE SUAO1.PERSON_ID = SUAO.PERSON_ID
AND SUAO1.COURSE_CD = SUAO.COURSE_CD
AND SUAO1.UOO_ID = SUAO.UOO_ID
AND SUAO1.FINALISED_OUTCOME_IND = 'Y') UNION SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUAO.OUTCOME_DT
, SUAO.MARK
, SUAO.GRADING_SCHEMA_CD
, SUAO.VERSION_NUMBER
, SUAO.GRADE
, SUAO.TRANSLATED_GRADING_SCHEMA_CD
, SUAO.TRANSLATED_VERSION_NUMBER
, SUAO.TRANSLATED_GRADE
, SUA.DEG_AUD_DETAIL_ID
, SUA.UOO_ID FROM IGS_EN_SU_ATTEMPT SUA
, IGS_AS_SU_STMPTOUT SUAO WHERE SUA.UNIT_ATTEMPT_STATUS = 'DISCONTIN' AND SUAO.PERSON_ID = SUA.PERSON_ID AND SUAO.COURSE_CD = SUA.COURSE_CD AND SUAO.UOO_ID = SUA.UOO_ID AND SUAO.FINALISED_OUTCOME_IND = 'Y'
AND SUAO.OUTCOME_DT IN (SELECT MAX(SUAO1.OUTCOME_DT) FROM IGS_AS_SU_STMPTOUT SUAO1 WHERE SUAO1.PERSON_ID = SUAO.PERSON_ID
AND SUAO1.COURSE_CD = SUAO.COURSE_CD
AND SUAO1.UOO_ID = SUAO.UOO_ID
AND SUAO1.FINALISED_OUTCOME_IND = 'Y') UNION SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUAO.OUTCOME_DT
, SUAO.MARK
, SUAO.GRADING_SCHEMA_CD
, SUAO.VERSION_NUMBER
, SUAO.GRADE
, SUAO.TRANSLATED_GRADING_SCHEMA_CD
, SUAO.TRANSLATED_VERSION_NUMBER
, SUAO.TRANSLATED_GRADE
, SUA.DEG_AUD_DETAIL_ID
, SUA.UOO_ID FROM IGS_EN_SU_ATTEMPT SUA
, IGS_PS_STDNT_UNT_TRN SUT
, IGS_EN_SU_ATTEMPT TRANSFER_SUA
, IGS_AS_SU_STMPTOUT SUAO
WHERE SUA.UNIT_ATTEMPT_STATUS = 'DUPLICATE'
AND SUT.PERSON_ID = SUA.PERSON_ID
AND SUT.COURSE_CD = SUA.COURSE_CD
AND SUT.UOO_ID = SUA.UOO_ID
AND TRANSFER_SUA.PERSON_ID = SUT.PERSON_ID
AND TRANSFER_SUA.COURSE_CD = SUT.TRANSFER_COURSE_CD
AND TRANSFER_SUA.UOO_ID = SUT.UOO_ID
AND TRANSFER_SUA.UNIT_ATTEMPT_STATUS IN ('COMPLETED'
, 'DISCONTIN')
AND SUAO.PERSON_ID = TRANSFER_SUA.PERSON_ID
AND SUAO.COURSE_CD = TRANSFER_SUA.COURSE_CD
AND SUAO.UOO_ID = TRANSFER_SUA.UOO_ID
AND SUAO.FINALISED_OUTCOME_IND = 'Y'
AND SUAO.OUTCOME_DT IN (SELECT MAX(SUAO1.OUTCOME_DT) FROM IGS_AS_SU_STMPTOUT SUAO1 WHERE SUAO1.PERSON_ID = SUAO.PERSON_ID
AND SUAO1.COURSE_CD = SUAO.COURSE_CD
AND SUAO1.UOO_ID = SUAO.UOO_ID
AND SUAO1.FINALISED_OUTCOME_IND = SUAO.FINALISED_OUTCOME_IND)

Columns

Name
PERSON_ID
COURSE_CD
UNIT_CD
CAL_TYPE
CI_SEQUENCE_NUMBER
CI_START_DT
CI_END_DT
OUTCOME_DT
MARK
GRADING_SCHEMA_CD
GS_VERSION_NUMBER
GRADE
TRANSLATED_GRADING_SCHEMA_CD
TRANSLATED_GS_VERSION_NUMBER
TRANSLATED_GRADE
DEG_AUD_DETAIL_ID
UOO_ID