Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes the outcome to a student unit attempt, in the form of a mark and possibly a grade. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, OUTCOME_DT
, GRADING_SCHEMA_CD
, VERSION_NUMBER
, GRADE
, S_GRADE_CREATION_METHOD_TYPE
, FINALISED_OUTCOME_IND
, MARK
, NUMBER_TIMES_KEYED
, TRANSLATED_GRADING_SCHEMA_CD
, TRANSLATED_VERSION_NUMBER
, TRANSLATED_GRADE
, TRANSLATED_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, UOO_ID
, MARK_CAPPED_FLAG
, SHOW_ON_ACADEMIC_HISTRY_FLAG
, RELEASE_DATE
, MANUAL_OVERRIDE_FLAG
FROM IGS_AS_SU_STMPTOUT SUAO
WHERE OUTCOME_DT IN (SELECT MAX(OUTCOME_DT) FROM IGS_AS_SU_STMPTOUT WHERE PERSON_ID = SUAO.PERSON_ID
AND COURSE_CD = SUAO.COURSE_CD
AND UOO_ID = SUAO.UOO_ID
AND GRADING_PERIOD_CD <> 'MIDTERM')
AND GRADING_PERIOD_CD <> 'MIDTERM'