Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes the most recent outcome of student unit attempt as grade or mark for different grading periods |
Implementation/DBA Data: | Not implemented in this database |
SELECT ROW_ID
, 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
, GRADING_PERIOD_CD
, INCOMP_DEADLINE_DATE
, INCOMP_GRADING_SCHEMA_CD
, INCOMP_VERSION_NUMBER
, INCOMP_DEFAULT_GRADE
, INCOMP_DEFAULT_MARK
, COMMENTS
, 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 = SUAO.GRADING_PERIOD_CD)