Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes the outcome to a student unit attempt, in the form of a mark and possibly a grade for Midterm. |
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
FROM IGS_AS_SU_STMPTOUT_MID SUAOM
WHERE OUTCOME_DT IN (SELECT MAX(OUTCOME_DT) FROM IGS_AS_SU_STMPTOUT_MID WHERE PERSON_ID = SUAOM.PERSON_ID
AND COURSE_CD = SUAOM.COURSE_CD
AND UOO_ID = SUAOM.UOO_ID)